i use Tom Bennedum's original extension; it has suited my needs. Will give this remix a try and report.
Thanks.
1 Like
Works for me.
@TIMAI2 is it possible to ExportDatabase as /peopleCodes.db in ASD and then read it with the File.ReadFrom component?
Thanks for this great extensions as always you are awesome and genius
i was extracting one of .db files using this [ SQLiteStudio ] ( https://sqlitestudio.pl/ )
you can create them easily as well extract other apks db files 
The sqlite db is not in a text format suitable for reading with file component.
It is possible to query the entire table then save the result to a csv file for future reading.
1 Like
Please read my guide again, which I have updated, I found a quirk with the return of list of lists....
I was testing this @TIMAI2 extension and noticed that sometimes (like a daemon) when I deleted the aaaaaa.db file, .db-shm and .db-wal were created, here I found the explanation:
This is just a test application:
Two database paths are established: ASD/peoplesCode.db and ASD/peoplesCode2.db.
It opens, creates, inserts and selects in peoplesCode.db.
Store this file to CloudDB (in Base64 - extension).
Get as peoplesCode2.db (from Base64 - extension).
Open and Select * of peoplesCode2.db
If you want to go back to the peoplesCode.db you must Click in OpenDatabase peoplesCode.db
Borrar_Sqlite.aia (54.8 KB)
How are you deleting the database? This should only be possible using external file management, nothing to do with the extension. But best practice would be to ensure the database is closed and not the "main" database before deleting?
My comment was only because I was unaware of the existence of the .db-wal and .db-shm files.
I have tested it on an Android 9, MIT Comp. and installed.
When I delete the ASD/peoplesCode.db file without closing it, the .db-wal and .db-shm files are created.
I delete it using the File component, File.Delete
Interestingly, if I now close the database and File.Delete: ASD/peoplesCode.db again, the .db-wal and .db-shm are deleted, they are shared memory files.
1 Like
Hi team
, I need som help about SQLlite extension when I working with companion on the phone, I try to import the database from the phone, this is a empty database with all tables and I need to begin the app with this database, not to 'create' the tables on then phone. Well, with sqllitestudio I create this database and transfer it to phone but the "Import" method of this extension return all time 'error', pls, can someone tell me where I can put the empty database for the import to work. thans.
From the documentation
The simplest way is to upload the database into the assets of your app, see also @TIMAI2's guide METRIC RAT AI2 - Working with SQLite
Else use the file component to copy it from shared storage /Download or /Documents to the ASD and import from there
Taifun
Which extension are you using ? (SQLite1) ?
Mmmm... may be OK set column headers to false using a clock started by Screen1.Initialize?
Column Headers Bug now fixed, download latest version 3
Also ListFixer merged to main extension
SimpleSqliteV3
For Android <10 there is a bug (typo ?) that carried over from the original extension
return getExternalStoragePath() + "/AppInventor/data/";
should read
return getExternalStoragePath() + "/AppInventor/assets/";
Should now be fixed
For Android 12, just use //myDatabase.sqlite, extension is looking for // for asset files
... the same of course on Android 10+
On Android ≤ 9 a relative path must therefore be set (at least as long as this is not adjusted in the extension).
Hmmm, looks like
is doubling up on /storage/emulated/0....
Will test some more