Debugging a database app is easier when you can see the queries it runs. This Xojo tutorial shows how to subclass SQLiteDatabase and add logging to its methods.

https://blog.xojo.com/2025/02/05/customize-and-extend-core-databases-functionality/

#DatabaseDevelopment #SQLite #Programming

Convert SQLite Database files to Multiple formats (Excel, CSV, JSON, HTML, and many others) securely with Softaken SQLite DB Converter
Read More: www.softaken.com/sqllite-db-c...

#sqlite #sqliteconverter #sqlitedbconverter #sqliteconversion #sqlitedatabaseconverter #sqlitedatabase #sqlitetocsv

SQLiteDatabase

Use WriteAheadLogging for better write performance. Transactions to protect integrity and speed up bulk operations. Long queries in a Thread to keep UI responsive. Small app database, serious app performance.

#Xojo #SQLite #Performance #Coding

Did you know that you can load extensions in SQLite?

You can load an extension in MBS Xojo SQL Plugin using SQLite as well as into Xojo's built-in SQLiteDatabase.

You can register custom functions to use in the SQLite database and define them in #Xojo.

www.mbsplugins.de/archive/2024...

When is the pool closed? Understand normal circumstances, the pool is closed when the SQLiteDatabase that owns it is closed.

But.. that's not always what happens, and this is where the bug lies.

SQLiteDatabase is a SQLiteClosable, which has a reference counter

cs.android.com/android/plat...

Today, a little thread on an interesting SQLiteDatabase bug in Android 16

What happens when you run a query, get a cursor back, close the database and then only try to read the contents of the cursor?

=> The underlying SQLiteConnectionPool throws an exception:

cs.android.com/android/plat...