[Lazarus] More explorations with tiOPF

[Sven Barth]

Am 15.03.2011 14:10, schrieb Graeme Geldenhuys:
> Op 2011-03-15 15:04, michael.vancanneyt@**** het geskryf:
>>
>> SQLLite obviously. Firebird embedded is a full firebird, with all
>> functionalies of a server.
>
>
> That what I thought. But you had me worried there for a second! :)
>
>
> By the way, that SQLLite issue seems very similar to the one in MySQL
> too. The latter allows you to setup field constraints without problems
> (yeah, they finally caught up on that one), but when you insert data,
> such field constrains are simply ignored. :-)
>
> It still blows my mind why Firebird RDBMS isn't more popular, yet
> half-baked ones like MySQL (and from what I can read SQLLite too) is.

While the type-safety can potentially lead to problems when non-Pascal 
systems access the database as well, I wouldn't describe SQLite (btw: 
only one "L" ;) ) as half-baked. It was a decision of the developers to 
allow this (although one might argue how they came to such a decision...).

Nevertheless SQLite has its usage, because it is so small (to be fair: I 
don't know the size of the Firebird embedded lib), so it's suited very 
well for embedded applications. This (and the license) might be the 
reason, that SQLite is used in iOS and Android as well.

Regards,
Sven