Sqlite embedded in delphi application

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
jota
Posts: 34
Joined: Tue 22 Nov 2011 19:21

Sqlite embedded in delphi application

Post by jota » Tue 31 Jul 2012 10:02

Hello

I want to use the sqlite database through its C code, once included in delphi, to avoid using sqlite3.dll.

How I can indicate this change to the component "TUniConnection".

Thank in advance.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Sqlite embedded in delphi application

Post by AlexP » Tue 31 Jul 2012 12:27

hello,

In the latest UniDAC version 4.3.8 we have implemented Direct mode under Windows 32 in the SQLite provider. To use Direct mode, you should set the Direct property to True on the Options tab of the UniConnection dialog or in code:

UniConnection.SpecificOptions.Values['Direct'] := 'True';

In this case, the built-in SQLite library version 3.7.12 will be used.

jota
Posts: 34
Joined: Tue 22 Nov 2011 19:21

Re: Sqlite embedded in delphi application

Post by jota » Sun 19 Aug 2012 10:06

Hello.

In direct mode can i include and compile my own amalgamated file sqlite3.c?. If so, in what way I can do it?.

I observe in specific software for Sqlite (LiteDAC) exist direct mode too. LiteDAC offers all components UniDAC? UniDAC components can be updated easily and transparently to LiteDAC components?

Thank in advance.

ZEuS
Devart Team
Posts: 240
Joined: Thu 05 Apr 2012 07:32

Re: Sqlite embedded in delphi application

Post by ZEuS » Mon 20 Aug 2012 08:07

There is no possibility to use your own SQLite amalgamation file in UniDAC, because in UniDAC we have used a version of sqlite3.c with some our enhancements made in order to provide database encryption.
UniDAC and LiteDAC have almost identical set of components, that have similar properties and methods. So, you will not have considerable difficulties when migrating from UniDAC to LiteDAC.

Post Reply