[fpc-pascal] sql server embedded: sqlite the only solution?

Luiz Americo Pereira Camara luizmed at oi.com.br
Tue Dec 22 14:14:58 CET 2009


JoshyFun escreveu:
> Hello FPC-Pascal,
>
> Tuesday, December 22, 2009, 12:55:07 AM, you wrote:
>
> ZD> I think you talk about Firebird embedded version 1.0, SQlite3 best than it
> ZD> I have Point of Sale application use Firebird 2.1 in desktop PC and
> ZD> Sqlite3 in Wince, the same project with same SQL statements (with a
> ZD> little directive for special queries).
>
> SQLite is faster than Firebird, but take care that SQLite does not
> enforce foreign keys, so data integrity must be handled by the
> programmer "manually".
>   

Not anymore. See http://www.sqlite.org/releaselog/3_6_19.html

Luiz




More information about the fpc-pascal mailing list