Devart Forums

I just downloaded latest version (4.4.2) of LiteDAC and direct access is still based on SQLite client 3.27.2 - this release is old and lacks some very important updates, esp. UPDATE FROM in 3.33 generated columns, alter table drop column and Upsert in 3.35 as well as a number of bug fixes and minor improvements.

When do you expect to have a new version that supports a more modern SQLite client - I am prevented from using the DLL version by our installation restrictions, but would really like to use the newer features.

Couldn't you just replace the provided sqlite3.o object file with a newer one, e.g. from the mORMot project?

The Direct mode is implemented in our components for all supported platforms. In the latest version of our product, we use the source code of SQLite client library 3.27, which has been rigourously tested with our product on all platforms.
We're currently testing compatibility of our products with newer versions of the client library.
Without using Direct mode, you can use any version of the client library available on the official website of the SQLite project