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

[Alan Mead]

Luiz, thanks!  A couple questions below...

Luiz Américo <pascalive at bol.com.br> wrote:

> 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

On both Linux and Windows, I'm using the binary libraries from
sqlite.org.  The bindings themselves fail to compile.  It looks like
a Windows-specific call is being used.

> > 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.

I'll give it a shot and I'll post here if I run into trouble.

The Wiki says that the bindings work with >= 2.83 ... does that
include 3.x?  Or do I need to go get the bindings below?

> 
> 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