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

Re: [SOLVED] Guile module for sqlite

[Romel R. Sandoval Palomo]

Perfect, now I have guile-dbi and guile-dbd-sqlite working on guile 2.0

The only issue was with LIBADD. I edited Makefiles to use -lguile-2.0
instead of -lguile

Thanks to Linas Vepstas, tantalum, and Julian Kalbhenn.

El mar, 18-05-2010 a las 10:17 -0500, Linas Vepstas escribió:
> 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

Re: [SOLVED] Guile module for sqlite

[Andy Wingo]

Hi,

On Tue 18 May 2010 21:26, "Romel R. Sandoval Palomo" <romel@lavabit.com> writes:

> Perfect, now I have guile-dbi and guile-dbd-sqlite working on guile 2.0
>
> Thanks to Linas Vepstas, tantalum, and Julian Kalbhenn.

Yes, thanks, that's great!

> The only issue was with LIBADD. I edited Makefiles to use -lguile-2.0
> instead of -lguile

Linas would you mind looking into this? If you want to maintain back
compatibility, use `guile-config link' or the GUILE_LIBS macro. 

Cheers,

Andy
-- 
http://wingolog.org/

Re: [SOLVED] Guile module for sqlite

[Linas Vepstas]

Hi,

On 21 May 2010 06:06, Andy Wingo <wingo@pobox.com> wrote:
> Hi,
>
> On Tue 18 May 2010 21:26, "Romel R. Sandoval Palomo" <romel@lavabit.com> writes:
>
>> The only issue was with LIBADD. I edited Makefiles to use -lguile-2.0
>> instead of -lguile
>
> Linas would you mind looking into this? If you want to maintain back
> compatibility, use `guile-config link' or the GUILE_LIBS macro.

Done. Curiously, there was a check in ./configure to see
if guile_config existed, but then it was never actually used!

I also added similar checks for the sqlite3 and mysql backends
(postgres doesn't seem to have one)

There's now a version 2.1.4 of everything that incorporates this.
I hope that the additional mysql/sqlite3 checks don't end
up breaking more than they fix ...

Let me know if there are any other problems.

Again: guile-dbi website:
http://home.gna.org/guile-dbi/

-- Linas