Has anybody done SQLite Wrapper ?

[unixkd]

Hi all,

I am aware that Xbase++ 2.0 will support SQLite natively when it is released. Before then, has anybody done SQLite Wrapper ? I have a project that will require getting data from a 3rd party program that uses SQLite in realtime.

Thanks.

Joe

[Auge_Ohr]

hi,

look at Pablos Website http://www.xbwin.com


but before you start your Project read this :

http://sqlite.org/whentouse.html#appfileformat

*** qoute ***
Situations Where Another RDBMS May Work Better
a.. Client/Server Applications

If you have many client programs accessing a common database over a
network, you should consider using a client/server database engine instead
of SQLite. SQLite will work over a network filesystem, but because of the
latency associated with most network filesystems, performance will not be
great.

b.. Also, the file locking logic of many network filesystems
implementation contains bugs (on both Unix and Windows). If file locking
does not work like it should, it might be possible for two or more client
programs to modify the same part of the same database at the same time,
resulting in database corruption. Because this problem results from bugs in
the underlying filesystem implementation, there is nothing SQLite can do to
prevent it.

c.. A good rule of thumb is that you should avoid using SQLite in
situations where the same database will be accessed simultaneously from many
computers over a network filesystem.

*** eof ***

so it only work if you the only User in your Network

[Auge_Ohr]

this is the Thread where you find lates Attachment

From: "Pablo Botella"
Newsgroups: ot4xb.examples
Subject: testing class sqlite3_xb
Date: Sat, 6 Feb 2010 14:25:00 +0100

[unixkd]

There is a Client/Server version of SQLite like the one offer by cubeSQL. Though not free but at a very low price.
www.sqlabs.com/cubesql.php

Joe