B4J Question Windows and Linux targets, how to use SQLite API?

[Avon]

Can someone point me to how to use the SQLite API with Windows and Linux targets?

 

[DonManfred]

jRDC2 runs on Windows and even on Linux and it is able to use an SQLite-jdbc-Connector (you are already using it)

 

[Avon]

Maybe, but I don't like what I'm already using... I need to acheive better performance with large result sets. Does SQLite-jdbc-Connector add overhead like garbage collection to what I could get from sqlite3.dll?

 

[Erel]

SQL Tutorial

 

[Avon]

Sorry, my original post was ambiguous.

I don't want to use jDBC or any other superstructure, just the rawest form of SQLite. I'm totally at home with the SQlite C API, and have been writing SQL queries for decades. I just need to get the optimum performance out of SQLite with the minimum overhead. I will never need to port my code to another DB.

 

[Avon]

SQLite distributes a library for Android:

A precompiled Android library containing the core SQLite together with appropriate Java bindings, ready to drop into any Android Studio project.

Maybe that's the place to start.

Anyone tried it?

 

[Erel]

The correct way is to use the JDBC driver. The performance will be very good.

 

[billzhan]

There are different SQlite JDBC drivers.

B4J comes with xerial (https://bitbucket.org/xerial/sqlite-jdbc) which use the native SQlite libraries for different OSes , and no manual configurations needed.

What is different from Zentus's SQLite JDBC?
The current sqlite-jdbc implementation is based on the code of Zentus's SQLite JDBC driver (missing link). We have improved it in two ways:

• Support major operating systems by embedding native libraries of SQLite, compiled for each of them.
• Remove manual configurations

You can use Dbutils code module to make your code simple.
https://www.b4x.com/android/forum/threads/dbutils-example.34611/

A similar one for B4A and B4i:
https://www.b4x.com/android/forum/threads/dbutils-android-databases-are-now-simple.8475/

https://www.b4x.com/android/forum/threads/module-dbutils.46563/