We ended up using the PhoneGap SQLite plugin, here’s why: We started off using a plain old Web SQL Database in our PhoneGap app, but ran into the following limitations: Size of database is limited to 5MB (the user can be prompted to allow more, but we didn’t want such prompts in our app) Pre-populating … Read more
To allow the VACUUM command to run, change the directory for temporary files to one that has enough free space. SQLite’s documentation says the temporary directory is (in order): whatever is set with the PRAGMA temp_store_directory command; or whatever is set with the SQLITE_TMPDIR environment variable; or whatever is set with the TMPDIR environment variable; … Read more
select replace(str, rtrim(str, replace(str, “https://stackoverflow.com/”, ”)), ”) from table; Step-by-step explanation. For example, we have the string: /storage/udisk/1200 Mics/[2002] 1200 Micrograms/1200 Mics – 03 – Mescaline.mp3 The replace(str, “https://stackoverflow.com/”, ”) removes / chars from str so we will have: storageudisk1200 Mics[2002] 1200 Micrograms1200 Mics – 06 – Ecstasy.mp3 Let’s call this noslashes. Next we use … Read more
This doesn’t answer the original question How can I properly re-open room db after I close it? However, moving everything to the original database file is what you want to do, then you don’t have to close the database in the first place. You can instead force a checkpoint using the wal_checkpoint pragma. Query the … Read more
You need to link the sqlite3 library along with your program: g++ main.cpp -lsqlite3
try this way select (select count() from XXX) as count, * from XXX;
Click here to see my blog post on this subject. CommonsWare is right on (as usual). Expanding on his post, here is some sample code that illustrates three possible approaches. These will allow access to the database throughout the application. Approach #1: subclassing `Application` If you know your application won’t be very complicated (i.e. if … Read more
I don’t know of any performance penalties in frequent closing/opening of the database (regardless of its size). I think the answer to this question also depends on what type of application is accessing the database. Do you “re-query” the database a lot? Then it seems rectified to keep it open. Do you fetch different data … Read more
You still have to create the column checklist_id INTEGER before you add it as a Foreign key. So it would be: CREATE TABLE checklist ( _id INTEGER PRIMARY KEY AUTOINCREMENT, checklist_title TEXT, description TEXT, created_on INTEGER, modified_on INTEGER ); CREATE TABLE item ( _id INTEGER PRIMARY KEY AUTOINCREMENT, checklist_id INTEGER, item_text TEXT, item_hint TEXT, item_order … Read more
You are assuming that the current working directory is the same as the directory your script lives in. It is not an assumption you can make. Your script is opening a new database in a different directory, one that is empty. Use an absolute path for your database file. You can base it on the … Read more