[Lazarus] Problem with zeos and sqlite-3

[Sven Barth]

On 16.02.2013 13:58, Michael Van Canneyt wrote:
>
>
> On Sat, 16 Feb 2013, Sven Barth wrote:
>
>>
>> Am 16.02.2013 13:28 schrieb "Michael Van Canneyt"
>> <michael at freepascal.org>:
>> >> Furthermore, SQLite makes a good partner for FreePascal and Lazarus,
>> >> so you should not discourage people here from using it.
>> >
>> >
>> > I strongly disagree it is a good partner.
>> >
>> > Object Pascal is a strongly typed language:
>> > FPC database code expects an integer in a column declared as integer.
>> >
>> > So if sqlite does not ensure this, it is a bad partner for Object
>> Pascal.
>> >
>> > A good partner is Firebird or Postgres: real databases with stable
>> apis.
>> >
>> > I will never stop discouraging people from what I think is very bad
>> software.
>> > And I consider sqlite very bad for the reasons outlined above.
>>
>> But unlike Firebird and PostgreSQL one can rather simply port SQLite
>> to a new platform. And I also like the idea of virtual
>> tables. So in that sense the ZMSQL you posted might be a compareable
>> alternative if now one only adds support for virtual
>> tables, adds some other nice features like triggers (or do they exist
>> already?) and improves the performance :D
>
> Well, as far as I know : ZMSQL are always virtual tables. You have
> triggers: all TDataset events.
>

I've not yet looked in detail at ZMSQL. I've only taken a quick look at 
the wiki article on my way from the U-bahn to my train yesterday.

> And I never denied the ease of use of sqlite.
> I just don't think it is a database in the RDBMs sense of the word.
>
> It remains for me at the level of TIniFile or TXMLDocument.
>
> And looking at how it's commonly used: mostly it seems to be config
> settings or key/value pairs and I don't think you need SQL for those.

In our WinCE client for our application we use it for a miniature 
version of our database. As the client does not need all tables and only 
a specific subset of the data we generate a database on the host 
computer and download that to the device. When the user is done the 
database is copied back and the created data is integrated with the 
normal database (which is either a Oracle, MSSQL or DB2 one).

Regards,
Sven