[ask]Is there native sqlite
lazarus / 16-Databases

----------------------------------------------------------------------
irw10062 · 2012-10-05 02:01

is there any native sqlite for lazarus,
no need library .dll / .so to run it

thanks

----------------------------------------------------------------------
CaptBill · 2012-10-05 02:48

There are components on the SqlDB tab which set you right up. Not
"natively" but as pre-installed dcu's.

----------------------------------------------------------------------
irw10062 · 2012-10-05 03:24

Quote from: CaptBill on October 05, 2012, 04:48:01 amThere are
components on the SqlDB tab which set you right up. Not "natively" but
as pre-installed dcu's.

what's the name of component, TSQLite3Connectin required library

----------------------------------------------------------------------
CaptBill · 2012-10-05 03:43

Do you not have a SqlDB tab on your component palette? I thought it
came stock with all installations. Maybe it is not stock so you must
install it then.

----------------------------------------------------------------------
irw10062 · 2012-10-05 06:10

sqldb need connector, and the connector need client library

----------------------------------------------------------------------
BigChimp · 2012-10-05 06:23

irw10062, you're right: Lazarus/FPC sqlite connectors all require an
sqlite .dll/.so/.dylib.

Native database options are zmsql or tdbf (or, at a lower level, you
can use bufdataset, memdataset, csvdataset directly in your code)

----------------------------------------------------------------------
marcov · 2012-10-05 07:56

Sqllite is PD, so static linking could be an option. (so compile
sqlite library to .a, and link that .a into the binary, adapting
headers if necessary)

That is not a prepared path though, so not for the faint of heart

----------------------------------------------------------------------
Dibo · 2012-10-05 08:30

Quote from: marcov on October 05, 2012, 09:56:32 amSqllite is PD, so
static linking could be an option. (so compile sqlite library to .a,
and link that .a into the binary, adapting headers if necessary)
I've never heard about this trick. Exists any free pascal wiki page
about this? Could this also work with libQt4Pas?

----------------------------------------------------------------------
ludob · 2012-10-05 09:32

QuoteI've never heard about this trick.See this thread http://forum.la
zarus.freepascal.org/index.php/topic,15712.msg84781.html#msg84781 for
step by step instructions for linking statically sqlite. It is written
in such a way that it can be applied to other libraries.
QuoteCould this also work with libQt4Pas?Probably. There is no problem
with the licence (lgpl with linking exception) but you link your app
to certain level of QT by doing so. libQt4Pas comes also with some
linux distributions. I don't know if and to what extend they are
customised for the distribution.