[Lazarus] Embedded/small database

Bee bee.ography at gmail.com
Wed Feb 18 11:12:42 CET 2015

I don't understand why FreePascal users need SQLite while we already have
ZMSQL. Basically ZMSQL acts more or less like sqLite. But ZMSQL doesn't
need external library. Check it out at: http://wiki.freepascal.org/ZMSQL

On Wed, Feb 18, 2015 at 4:28 PM, patspiper <patspiper at gmail.com> wrote:

> On 17/02/15 21:50, Michael Van Canneyt wrote:
>> On Tue, 17 Feb 2015, Kostas Michalopoulos wrote:
>>  Sqlite can be very fast, but it needs the proper setup for that (which
>>> may not be
>>> relevant in all cases).
>>> Beyond that, Sqlite has a lot of high profile users (not to make a piss
>>> match, but i
>>> couldn't see any big users in Firebird's site and even those didn't seem
>>> to mention if
>>> it was embedded or client/server):
>>> https://www.sqlite.org/famous.html
>>> There are other less known uses of course, like the Fossil VCS and AFAIK
>>> Apple also
>>> uses it for the time capsule and FS versioning.
>>> Honestly, i wouldn't put down Sqlite :-).
>> I would. Any database that allows you to store a string in a field that
>> is declared as integer (as sqlite does), is out. It goes against the basic
>> rules of the RDBMs: ACID. Period.
>> If you ever encounter such a situation, the whole pascal db code simply
>> goes 'poof'.
>> If the table definition says 'integer', it should be an integer. if
>> sqlite does not guarantee this (and it does not, it considers this a
>> feature), it is out.
>> I don't even understand that any pascal programmer (pascal being stronly
>> typed) can consider such a system. But there are many things I don't
>> understand :)
> Is there any other free WinCE database engine?
> Stephano
> --
> _______________________________________________
> Lazarus mailing list
> Lazarus at lists.lazarus.freepascal.org
> http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20150218/015159f1/attachment-0003.html>

More information about the Lazarus mailing list