[fpc-pascal] Cross-platform lightweight/fpc SQLite bindings?

[Luiz Américo]

Alan Mead wrote:
> I just want some fairly light-weight sqlite3 bindings that work on
> Linux and Windows.  The code on the SQLite website works great on
> Windows but fails to compile on Linux.  (I don't know Windows API
> calls... it looks like he's searching for a function name in the
> DLL.) 

Are you failling to compile the sqlite library itself or the fpc binding 
(sqlite3.pas)?
The fpc binding does not depend of an other library except the sqlite itself

> I've tried a few other solutions and they have either not worked
> cross-platform or they are meant for Delphi and I couldn't compile
> them using just FPC.  
> 
> [I could use Lazarus... Is it easy to learn to use TDataSet?  My
> ideal would be something like Perl's DBI... prepare(), execute(),
> fetch_row(), etc.  I know SQL and don't need a lot of abstractions
> getting in the way.]

Yes it is. I recommend read any Delphi TDataset tutorial before using 
the fpc one if you are not familiar with it. Then if you choose to use 
TSqliteDatset take a look at lazarus wiki at Database/Sqlite section.

You can use TDataset also in console apps. See the examples in the dir 
http://svn.freepascal.org/svn/fpc/branches/fixes_2_0/fcl/db/sqlite/
Just rename from TSqliteDataset to TSqlite3dataset and sqliteds to 
sqlite3ds.

> Before I try to debug one of these non-working-solutions, does anyone
> know of an existing FPC (not Delphi/Lazarus) solution that works on
> both Windows and Linux?

At the time i tested, both the binding and the TDataset were working in 
Linux and Windows, but were a change in the binding later. I'll take a look.

You can find the newest units for sqlite3 in the svn repository:

base sqlite3 (binding):
http://svn.freepascal.org/svn/fpc/branches/fixes_2_0/packages/base/sqlite/sqlite3.pp

TDataset descendants
http://svn.freepascal.org/svn/fpc/branches/fixes_2_0/fcl/db/sqlite/customsqliteds.pas
http://svn.freepascal.org/svn/fpc/branches/fixes_2_0/fcl/db/sqlite/sqliteds3.pas

Luiz