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

Avon

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

Avon

Member
Licensed User
Longtime User
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?
 
Upvote 0

Avon

Member
Licensed User
Longtime User
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.
 
Upvote 0

Avon

Member
Licensed User
Longtime User
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?
 
Upvote 0

billzhan

Active Member
Licensed User
Longtime User
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.




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/
 
Upvote 0
Cookies are required to use this site. You must accept them to continue using the site. Learn more…