Guile module for sqlite

Guile module for sqlite

[Romel R. Sandoval Palomo]

Hello.

I'm starting to write a guile module for sqlite3 API. I'm progressing
slowly because I'm new in guile.

I send this mail just to know if there is anybody working on the same
task. So we don't duplicate work.

Also I have a doubt if is correct to call the module (db sqlite) so it
will be loaded with:

(use-modules (db sqlite))

Regards.

-- 
Romel R. Sandoval

Re: Guile module for sqlite

[Linas Vepstas]

On 15 May 2010 15:24, Romel R. Sandoval Palomo <romel@lavabit.com> wrote:
> Hello.
>
> I'm starting to write a guile module for sqlite3 API. I'm progressing
> slowly because I'm new in guile.
>
> I send this mail just to know if there is anybody working on the same
> task. So we don't duplicate work.
>
> Also I have a doubt if is correct to call the module (db sqlite) so it
> will be loaded with:
>
> (use-modules (db sqlite))

An alternative would be to write a backend for guile-dbi,
that way, one can use the same api for any sql db

See http://home.gna.org/guile-dbi/

Its certainly easier to write the backend for guile-dbi,
than it would be to create a whole api from scratch.

--linas

Re: Guile module for sqlite

[tantalum]

Hi,

I did write a guile-dbi module for sqlite3.
I am using it everyday successfully for basic queries.

You can find it under: http://thaseph.de/ande/guile-dbd-sqlite3.html


Hope it helps

Re: Guile module for sqlite

[Romel R. Sandoval Palomo]

Thank you, its great, unfortunately to me, I'm targeting 
guile 2.0 (1.9.10) and the released guile-dbi (2.1.2) use the 
deprecated guile/gh.h

I found guile-dbi developers remove that dependency on its SVN
repository, but I failed to build because I failed to generate 
configure script using autogen.sh

I got this while running guile-dbi autogen.sh:

{{{
automake (GNU automake) 1.11
libtoolize: putting auxiliary files in `.'.
libtoolize: copying file `./ltmain.sh'
libtoolize: putting macros in AC_CONFIG_MACRO_DIR, `m4'.
libtoolize: copying file `m4/libtool.m4'
libtoolize: copying file `m4/ltoptions.m4'
libtoolize: copying file `m4/ltsugar.m4'
libtoolize: copying file `m4/ltversion.m4'
libtoolize: copying file `m4/lt~obsolete.m4'
Creating aclocal.m4: aclocal  -I ac-helpers
automake --add-missing --copy --foreign

* * * warning: possible errors while running automake - check autogen.err

Creating configure...
configure: WARNING: unrecognized options: --enable-maintainer-mode
/configure: line 2122: syntax error near unexpected token `$PACKAGE,$VERSION,bug-guile@gnu.org'
/configure: line 2122: `AM_INIT_AUTOMAKE($PACKAGE,$VERSION,bug-guile@gnu.org)'
}}}

My autogen.err:

{{{
aclocal: couldn't open directory `ac-helpers': No existe el fichero ó directorio
configure.ac: no proper invocation of AM_INIT_AUTOMAKE was found.
configure.ac: You should verify that configure.ac invokes AM_INIT_AUTOMAKE,
configure.ac: that aclocal.m4 is present in the top-level directory,
configure.ac: and that aclocal.m4 was recently regenerated (using aclocal).
src/Makefile.am:35: Libtool library used but `LIBTOOL' is undefined
src/Makefile.am:35:   The usual way to define `LIBTOOL' is to add `AC_PROG_LIBTOOL'
src/Makefile.am:35:   to `configure.ac' and run `aclocal' and `autoconf' again.
src/Makefile.am:35:   If `AC_PROG_LIBTOOL' is in `configure.ac', make sure
src/Makefile.am:35:   its definition is in aclocal's search path.
/usr/share/automake-1.11/am/depend2.am: am__fastdepCC does not appear in AM_CONDITIONAL
/usr/share/automake-1.11/am/depend2.am:   The usual way to define `am__fastdepCC' is to add `AC_PROG_CC'
/usr/share/automake-1.11/am/depend2.am:   to `configure.ac' and run `aclocal' and `autoconf' again.
/usr/share/automake-1.11/am/depend2.am: AMDEP does not appear in AM_CONDITIONAL
/usr/share/automake-1.11/am/depend2.am:   The usual way to define `AMDEP' is to add one of the compiler tests
/usr/share/automake-1.11/am/depend2.am:     AC_PROG_CC, AC_PROG_CXX, AC_PROG_CXX, AC_PROG_OBJC,
/usr/share/automake-1.11/am/depend2.am:     AM_PROG_AS, AM_PROG_GCJ, AM_PROG_UPC
/usr/share/automake-1.11/am/depend2.am:   to `configure.ac' and run `aclocal' and `autoconf' again.
src/test/Makefile.am:28: Libtool library used but `LIBTOOL' is undefined
src/test/Makefile.am:28:   The usual way to define `LIBTOOL' is to add `AC_PROG_LIBTOOL'
src/test/Makefile.am:28:   to `configure.ac' and run `aclocal' and `autoconf' again.
src/test/Makefile.am:28:   If `AC_PROG_LIBTOOL' is in `configure.ac', make sure
src/test/Makefile.am:28:   its definition is in aclocal's search path.
}}}

Could anybody help me with this guilde-dbi configure script generation problem, please?

El dom, 16-05-2010 a las 01:57 +0200, tantalum escribió:
> Hi,
> 
> I did write a guile-dbi module for sqlite3.
> I am using it everyday successfully for basic queries.
> 
> You can find it under: http://thaseph.de/ande/guile-dbd-sqlite3.html
> 
> 
> Hope it helps
> 

Re: Guile module for sqlite

[Linas Vepstas]

On 17 May 2010 20:57, Romel R. Sandoval Palomo <romel@lavabit.com> wrote:
> Thank you, its great, unfortunately to me, I'm targeting
> guile 2.0 (1.9.10) and the released guile-dbi (2.1.2) use the
> deprecated guile/gh.h

The only thing using this is the test case; you can use the test
case from svn, copy it to the 2.1.2 source tree, and it should
work fine; removing gh.h was a trivial fix.

I will try to create a version 2.1.3 tomorrow and/or "real soon now".

--linas

Re: Guile module for sqlite

[Linas Vepstas]

Hi,

On 15 May 2010 18:57, tantalum <tantalum@online.de> wrote:
> Hi,
>
> I did write a guile-dbi module for sqlite3.
> I am using it everyday successfully for basic queries.
>
> You can find it under: http://thaseph.de/ande/guile-dbd-sqlite3.html

I've just repackaged and released it as
http://download.gna.org/guile-dbi/guile-dbd-sqlite3-2.1.3.tar.gz

-- fixed configure.ac to correctly search for sqlite
-- added an autogen.sh file
-- added missing files (NEWS, ChangeLog) to keep the
   automake/libtoolize scripts quiet


SQLite3 is now listed as one of the DBD backends on
http://home.gna.org/guile-dbi/


Linas

Re: Guile module for sqlite

[Linas Vepstas]

On 17 May 2010 20:57, Romel R. Sandoval Palomo <romel@lavabit.com> wrote:
> Thank you, its great, unfortunately to me, I'm targeting
> guile 2.0 (1.9.10) and the released guile-dbi (2.1.2) use the
> deprecated guile/gh.h

I removed the guile/gh.h years ago, and should have published
version 2.1.3 when I did, but forgot.

There is now a version 2.1.3 available. Just running plain-old
./configure should work fine; let me know if there are any problems.

And, yes, there's now a guile-dbd-sqlite-2.1.3 as well,
thanks to tantalum and to Julian Kalbhenn <jkal@gmx.net>

--linas