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

[JoshyFun]

Hello FPC-Pascal,

Tuesday, December 22, 2009, 1:46:33 PM, you wrote:

>> 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".
MVC> About the "sqlite is faster":
MVC> This depends highly on the kind of queries you are using.
MVC> In my tests, sqlite was significantly slower than firebird. I compared
MVC> speeds of 4 different embedded engines, and sqlite was definitely not
MVC> the fastest one.

SQLite is faster in "simple" queries and in exchange with used memory
etc. For serious projects with important data it has many deficiences.

MVC> Secondly, I would never recommend sqlite for use with Pascal applications,
MVC> since sqlite does not even enforce the data to be of the correct type, which
MVC> creates problems if a field of type INT contains e.g. textual data, causing
MVC> a pascal application to crash.
MVC> (last time I checked, they called this "a feature")

Yes :) As far as I know, everything is a "text" field.

-- 
Best regards,
 JoshyFun