Re: PATCH [0/12]: Guile-DBI and Guile-DBD-Postgres

Re: PATCH [0/12]: Guile-DBI and Guile-DBD-Postgres

[Mike Gran]

----- Original Message ----
> From: Linas Vepstas <linasvepstas@gmail.com>
> 
> Hi,
> 
> Below follows a series of 12 patches against Guile-DBI and DBD-Postgres.
> 

Linus, thank you for doing this.

-Mike Gran

PATCH [0/12]: Guile-DBI and Guile-DBD-Postgres

[Linas Vepstas]

Hi,

Below follows a series of 12 patches against Guile-DBI and DBD-Postgres.

Guile DBI is a wrapper for accessing SQL databases.

https://gna.org/projects/guile-dbi/

I'm posting here -- although there used to be guile-dbi-user and guile-dbi-devel
mailing lists, these had no subscribers, and quickly filled with spam, as
evidenced by their mail archives. I've applied to get an account on gna.org
to post the patches there, but its been a week, and my account application
still hasn't gone through :-( It also appears that the original maintainer,
Maurizio Boriani, is not responding to email. Bummer.

The patches fix a variety of different crashes and hangs, and also fix
problems with missing data (e.g. for a query with N records, only N-1
were being returned -- bad news when N=1)

--linas

Re: PATCH [0/12]: Guile-DBI and Guile-DBD-Postgres

[Neil Jerram]

2008/9/19 Linas Vepstas <linasvepstas@gmail.com>:
>
> I'm posting here -- although there used to be guile-dbi-user and guile-dbi-devel
> mailing lists, these had no subscribers, and quickly filled with spam, as
> evidenced by their mail archives. I've applied to get an account on gna.org
> to post the patches there, but its been a week, and my account application
> still hasn't gone through :-( It also appears that the original maintainer,
> Maurizio Boriani, is not responding to email. Bummer.

Can anyone provide firm evidence regarding whether guile-dbi is now
maintained or unmaintained?

If it is unmaintained, I guess we could consider merging it into the
core Guile distribution.  Any thoughts on that?

Also, can anyone provide a summary of all the DB-related libraries for
Guile?  I believe there's guile-pg, and guile-sqlite, but (i) there
could be others I've forgotten, and (ii) it would be great if someone
could summarize how they differ / overlap / compare with each other.

> The patches fix a variety of different crashes and hangs, and also fix
> problems with missing data (e.g. for a query with N records, only N-1
> were being returned -- bad news when N=1)

Cool, thanks.  If it turns out to make sense to pull guile-dbi into
core Guile, I guess we'll review and incorporate these patches at that
time.

Regards,
     Neil

Re: PATCH [0/12]: Guile-DBI and Guile-DBD-Postgres

[Greg Troxel]

[-- Attachment #1: Type: text/plain, Size: 839 bytes --]


  Also, can anyone provide a summary of all the DB-related libraries for
  Guile?  I believe there's guile-pg, and guile-sqlite, but (i) there
  could be others I've forgotten, and (ii) it would be great if someone
  could summarize how they differ / overlap / compare with each other.

I am familiar with guile-pg.  It used to be on sourceforge, and was
unmaintained, and then ttn took it over and has done a lot of work on
it.  Last I checked guile-pg only supported guile through 1.6 due to it
using hte load-module-from-.so feature removed in 1.8, but ttn has said
that he'd take patches to make guile-pg work with 1.8+.

There is ttn's guile-gdbm: http://www.gnuvola.org/software/guile-gdbm/

There is no guile-dbi package in pkgsrc.

I dimly remember a pg-guile which was BSD licensed but have not heard
anything about it in years.

[-- Attachment #2: Type: application/pgp-signature, Size: 193 bytes --]

Re: PATCH [0/12]: Guile-DBI and Guile-DBD-Postgres

[Greg Troxel]

[-- Attachment #1: Type: text/plain, Size: 705 bytes --]


  Also, can anyone provide a summary of all the DB-related libraries for
  Guile?  I believe there's guile-pg, and guile-sqlite, but (i) there
  could be others I've forgotten, and (ii) it would be great if someone
  could summarize how they differ / overlap / compare with each other.

guile-pg has really nice support for converting postgresql types to and
From scheme types, and you can register custom converters.  So it's much
beyond just being able to run query strings and get string answers.  I
have the impression that it's implementation is tied to pg.

IMHO the right thing would be to use the type mapping part of guile-pg
with a DBI sort of back end to go to various databases.

[-- Attachment #2: Type: application/pgp-signature, Size: 193 bytes --]

Re: PATCH [0/12]: Guile-DBI and Guile-DBD-Postgres

[Linas Vepstas]

2008/9/19 Greg Troxel <gdt@ir.bbn.com>:
>
> guile-pg has really nice support for converting postgresql types to and
> From scheme types,

? I would be surprised if any database interface returned a
string, when the database column was declared an int,
so I don't quite understand this ...

> and you can register custom converters.

This could be interesting. Different databases have all
sorts of crazy column formats (23 different types of dates,
money amounts, "binary large objects" etc),  and clearly
guile-dbi doesn't have this.  Its a fairly small/low-brow
package.

> have the impression that it's implementation is tied to pg.

I didn't even look at guile-pg, because I know that some of
the users of my code will insist on mysql.  So I had to be
agnostic.

--linas

Re: PATCH [0/12]: Guile-DBI and Guile-DBD-Postgres

[Greg Troxel]

[-- Attachment #1: Type: text/plain, Size: 310 bytes --]


  ? I would be surprised if any database interface returned a
  string, when the database column was declared an int,
  so I don't quite understand this ...

That would be the SQL way :-) I haven't looked at guile-dbi; perhaps it
has the critical conversions already.

guile-pg does support pg large objects.

[-- Attachment #2: Type: application/pgp-signature, Size: 193 bytes --]

Re: PATCH [0/12]: Guile-DBI and Guile-DBD-Postgres

[Linas Vepstas]

2008/9/20 Greg Troxel <gdt@ir.bbn.com>:
> ? I would be surprised if any database interface returned a
>  string, when the database column was declared an int,
>  so I don't quite understand this ...
>
> That would be the SQL way :-) I haven't looked at guile-dbi; perhaps it
> has the critical conversions already.

Yes, it does, in the DBD layer. One of my patches fixed
a faulty float pt conversion.

--linas