Brute force approach: Send it the “.dump” command to create a text representation of the data. Read that data in into the second database. Not sure you can use that. If you need a fine grained update (sending a copy of each upto the other copy), have a look at sqlite3_update_hook But how do you … Read more
An index cannot safely be used in this case. A naive implementation would transform this: … WHERE word LIKE ‘search_string%’ into … WHERE word >= ‘search_string’ AND word < ‘search_strinh’ by incrementing the last character of the search string. The greater-than and less-than operators can use an index, where LIKE cannot. Unfortunately, that won’t work … Read more
What library are you using for SQLite? I did a search based on the connection URI you indicated and found this one. In the documentation it says: 2009 May 19th: sqlite-jdbc-3.6.14.1 released. This version supports “jdbc:sqlite::resource:” syntax to access read-only DB files contained in JAR archives, or external resources specified via URL, local files address … Read more
I found this blog entry which guides you to do these steps: Create a dump of the PostgreSQL database. ssh -C [email protected] pg_dump –data-only –inserts YOUR_DB_NAME > dump.sql Remove/modify the dump. Remove the lines starting with SET Remove the lines starting with SELECT pg_catalog.setval Replace true for ‘t’ Replace false for ‘f’ Add BEGIN; as … Read more
First of all, the one that has been deprecated by W3C is WebSQL not SQLite IndexedDB – It is incompatible with many types of mobile OS and is only compatible with certain types of versions of mobile OS Developers cannot use SQL with IndexedDB. They can with SQLite and WebSQL Most developers actively avoid using … Read more
I found out, that it is possible. Use: sqlite3.exe MainDB.db ATTACH DATABASE ‘SomeTableFile.db’ AS stf; Access the table from the other database file: SELECT * FROM stf.SomeTable; You can even join over several files: SELECT * FROM MainTable mt JOIN stf.SomeTable st ON (mt.id = st.mt_id); https://www.sqlite.org/lang_attach.html tameera said there is a limit of 62 … Read more
That isn’t quite an SQL file, that contains a bunch of MySQL-specific stuff some of which SQLite will accept and some it won’t. We’ll start at the top. You don’t need create database or use with SQLite. If you want to create a database just name it when you run sqlite3 from the command line: … Read more
Apparently the looping construct in SQLite is the WITH RECURSIVE clause. That documentation link has sample count-to-ten code, a Mandelbrot set plotter, and a Sudoku puzzle solver, all in pure SQL. Here’s an SQLite query that computes the Fibonacci sequence to give you a feel for it: sqlite> WITH RECURSIVE …> fibo (curr, next) …> … Read more