2008/10/3 Gustavo R. Montesino <[EMAIL PROTECTED]>
> Hello,
>
> In the past, Vivien has said it would be possible to backport some
> patches from libgda 3.1 branch to 3.0 to make it work properly using the
> system sqlite instead of the embedded one.
>
> I've tried to dig the needed patches from svn to fix the libgda3-sqlite
> debian packages (and consequently the Ubuntu ones) but haven't succeeded
> so far. Does someone know exactly what patches/svn revisions must be
> applied to make it work?
>
The configure script of V3.0 on purpose fails to detect an SQLite system
install and always falls back to the embedded one. The reason is that the
embedded version has been patched to allow the library to get meta data
about a database. You can force the configure script to use the system one
(and the generated lib will depend on the system DLL) simply by modifying
the configure.in script:
Index: configure.in
===================================================================
--- configure.in (révision 3224)
+++ configure.in (copie de travail)
@@ -927,7 +927,7 @@
realvers=`sqlite3 -version`
microvers=`sqlite3 -version | cut -d '.' -f 3`
AC_MSG_CHECKING(for sqlite version)
- if test $microvers -lt 100
+ if test $microvers -lt 1
then
AC_MSG_RESULT(Version $realvers of SQLite does not
implement required pragmas, using embedded SQLite)
have_sqlite=no
The problem will be that some meta data won't be fetched at all. Fixing this
has been done for the upcoming V4 and is quite a lot of work.
Now, if it's for Anjuta (as I understand from
https://bugs.launchpad.net/ubuntu/+source/libgda3/+bug/145361), then it's
useless as Anjuta (latest version) uses a preversion of Libgda V4 (3.99.4
should be Ok). The V4 can be built using a system installed SQlite or an
embedded version.
Also, please note that I'm not sure the "applications should use the system
installed SQLite" policy can be applied in all cases anyway, so maybe it's a
lost battle: SQLite being an embedded library, its configuration is very
customizable, and for example Mozilla also embedds it but disables some
features so it can't use a system installed SQLite.
Regards,
Vivien
_______________________________________________
gnome-db-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnome-db-list
