How to use SQL Lite?

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
fellipeh
Posts: 7
Joined: Wed 09 Apr 2008 11:21

How to use SQL Lite?

Post by fellipeh » Fri 31 Jul 2009 19:55

Hello, whats files I can provide to use SQLLite with UniDAC? How can I manipulate the database?

Best Regards

Joao Cadilhe
Posts: 27
Joined: Wed 30 Jan 2008 19:29
Location: Brazil

Post by Joao Cadilhe » Sat 01 Aug 2009 14:17

You have to put Sqlite dll in your application folder. To create and mantain sqlite databases you can use SqlLite Expert from http://www.sqliteexpert.com/ there is a free personal edition.

Recently i had to create a small utility program with sqlite and Unidac but i migrated from sqlite to Firebird embendded (and Unidac) because of many sqlite deadlocks errors (just because we had to create multiple connections and operations from same application). Version 2.5 (still in beta) of firebird embendded now suport multiple local database conections (with new superclassic server mode) and it was a perfet choice for me (Unidac and Firebird is really a great choice).

Joao Cadilhe.

fellipeh
Posts: 7
Joined: Wed 09 Apr 2008 11:21

Post by fellipeh » Mon 03 Aug 2009 13:14

Thanks,

Post Reply