Devart Forums

In my applications, the only database I will use is Sqlite.

Given that Sqlite is so widely used even in non database applications, I suggest you provide simple TDataSet (Table/Query) wrappers for Sqlite so that the final EXE won't be bloated. All current TDataset wrappers for Sqlite are either full of bugs or very expensive. Is this possible? I'm currently deciding which to buy, UniDAC or AnyDAC.


Thank you.

Hello,


The latest version of our products have been significantly changed due to the implementation of support for the new version of RadStudio XE2 and for multiple platforms. (The new version of UniDAC supports working with SQLite on MacOS and Win64).
Implementing support for static linking of the SQLite library is the next top-priority functionality that we plan to implement the next year. Next year we also plan to release a separate product for SQLite that will be more cost-effective than UniDAC and competing products.

It's great that you will offer a TDataSet wrapper for SQLITE. I hope it will offer similar interface to TTable/TQuery or TAdoTable/TADOQuery so that there won't be any learning curve.

The only TDataSet wrapper for SQLITE I have NOT tested is DISQLite3, which is way too expensive.

All the free implementations are full of bugs: I wasted around a month looking for and testing various packages, to my great disappointment.


Regarding static linking, it's very simple. I've been using static linking to SQLITE objs for a very long time. It will only take you minutes.