USB cable - sqlite3 command

[marco4phx]

Hi, on my handheld with Android 13 the
adb shell sqlite3 --version
report
/system/bin/sh: sqlite3: inaccessible or not found
Can you help to install it ?

[pawelsalawa]

sqlite3 command is not available on psyhical devices. See https://android.stackexchange.com/a/5121

[pawelsalawa]

The source code of this jar file is at https://github.com/pawelsalawa/sqlitestudio-android/tree/master/SQLiteStudioRemoteProject

According to file https://github.com/pawelsalawa/sqlitestudio-android/blob/master/SQLiteStudioRemoteProject/sqlitestudioremote/src/main/java/pl/com/salsoft/sqlitestudioremote/internal/SQLiteStudioDbService.java, the list of databases it provided by the Android API:

for (String dbFile : context.databaseList()) {
    // ....
}

The context is injected by Android API. Here's documentation of the method: https://developer.android.com/reference/android/content/Context#databaseList()

Now, your database is probably not visible because of the problem described in #3411.
It will probably be resolved at some point of time, but not soon.

[marco4phx]

Hi, using the Api Context.databaseList()
I get now the database file list, whose absolute path is /data/user/0/com.acme.myapp/databases/DATABASE.db

but in Delphi I cannot install files in absolute paths, and my db file is put in the same path of the App:
/data/user/0/com.acme.myapp/files/DATABASE.db

If would be possible select an absolute file path from SQLiteStudio when selecting the database URL, I would pay for this feature.
Also setting the same path of the App as search URL would be good...
Let me know,
BR

[pawelsalawa]

It will be 99% fixed, but not anytime soon. I am working right now on other features.

[marco4phx]

Ok...
meanwhile I have found a bug; when I copy a table from local DB to an Android DB, I get the error:
Error while creating index in target database: index idx_CustomerId already exists
It happens with any table which have at least one index.

If in the Copy options (with drag&drop) I deselect the "include indexes" option,
the copy is successful, but without the indexes of the source table...

[pawelsalawa]

Okay. Created #5221 for this.

[marco4phx]

Hi, I have installed SQLiteStudio on other machines, but do not find the "Get Android connector JAR file" option under menu Tools...
Also the "Android SQLite" database type is missing in Add Database...
What are the requirements necessary to show the Android options ?
I have ADB on both machines...

[pawelsalawa]

Isn't the \ a problem here? I think that he url shuld be made with /, but I don't really remember now how this Android plugin works...

[marco4phx]

No, the path seems ok;
I have found a trick to make the OK button enabled; selecting the IP address, if I select the DB proposed (which is that altready on the device!) the Ok button keep disabled...
But if I go again to select the IP and db name, and select the + button (create e new database on device) then the button is Enabled and the db created on remote, and accessible !
Then I go back to select the IP and db name, and change the db name to mine already on device, then the OK button is enabled and I can access my db...!!!
I have verified the device is listening on port 12121 using "Telnet 12121" because typing anything I get answer
{"generic_error":4}
Definitely there is something wrong in the way this form works...

[pawelsalawa]

Yeah, the Android plugin was not updated for a long time. I even archived it some time ago, as I though nobody uses it anymore, but over the time there were some requests and reports related to it (I label them with plugin-android - plugin-android ). Your above one will be another to add nad when I sit down to work on the plugin, I will restore the archived repo.

[pawelsalawa]

Created #5235 for it.

[marco4phx]

I think that when Android developers will understand what they can do with SQLiteStudio and this plugin, it will have a big interest among this kind of developers...