Anirban wrote:I was wondering if the latest Kexi always uses the latest SQlite release under the hood, and respects the limits that SQLite databases have. The most recent one, for example can allow the database to grow to Terabyte order (not that I will use SQLite for such a big database!).

The question pertains to all platforms (Linux, Mac OS X and Windows 7/8)

Thanks for your time

Kexi uses 'system' sqlite, i.e. the one shipped with the operating system. On build-time or run-time you can pick your own version since SQLite is just a dynamically loaded library. On 'configure' stage of cmake, Kexi's buildsystem recommends the newest SQLite to you checks minimal, that is 3.6.16.

So you have the newest features SQLite if you upgrade sqlite of course and if Kexi exposes/makes use of them.

But you should be aware that for maximum GUI convenience and reliability Kexi pre-loads all the data of given table or query in forms and tables. This make it costly to open large tables even of GB is size, not TB. The reason for this naive approach is that we would need forward and backward DB cursors with read-write access to the database, something not clearly available in SQLite. Well, we're using the DB cursor feature even for MySQL/PostgreSQL, but we'd like to do that.