Direct SQLite client libraries are old

Discussion of open issues, suggestions and bugs regarding LiteDAC (SQLite Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 1
Joined: Thu 29 Apr 2021 14:30

Direct SQLite client libraries are old

Post by garywalker7301 » Thu 29 Apr 2021 14:54

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.

Posts: 25
Joined: Wed 04 Apr 2018 08:30

Re: Direct SQLite client libraries are old

Post by frickler » Thu 24 Jun 2021 14:09

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

Devart Team
Posts: 1700
Joined: Mon 06 Jul 2015 11:34

Re: Direct SQLite client libraries are old

Post by MaximG » Fri 23 Jul 2021 12:12

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

Post Reply