Guile-SQLite3 - Guile-SQLite

Guile-SQLite3 - Guile-SQLite

[David Pirotte]

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

Hello Guilers,

I would like to work on and submit a GNU eval request for GNU Guile-SQLIte
but 2 quizz first:

1]

The current name is Guile-SQLite3 and I would like to drop the 3 from the name,
precisely not to have the API version in the name, rather, as we do for GNU
Guile-Gnome keeping the name generic and deal with these specificities in the source
tree, tar names ...

However, Andy Wingo [the original author of Guile-SQLite3 binding] mentioned on irc
that a guile-sqlite project previously existed maybe?  I can't find it and would
like, if this is accurate, the author or anyone who would be aware to answer here,
thanks!

If no answer, I'll consider the previous project either dead or maybe did not
'officially' existed and fell free to rename Guile-SQLite3 -> Guile-SQLite

2]

I have a local copy [has you know it was on gitorious...] but I'm not sure I have
the latest, so below, a git log of my local version:  if anyone has a more
recent version, please ping me thanks!

Cheers,
David

;;;
;;; Guile-SQLite3 git log of my local version
;;;

commit 7da16e079a007c2ffabb249d8dd829431c696827
Author: David PIROTTE <david@altosw.be>
Date:   Wed Feb 26 15:36:03 2014 -0300

    Fix sqlite-bind
    
    * bind-bouble pointing to "sqlite3_bind_double" instead of "sqlite3_bind_blob".

commit c55adf43a8c0e59706f40e65a07d457d60e55a83
Author: Sunjoong Lee <sunjoong@gmail.com>
Date:   Wed May 2 03:12:49 2012 +0900

    Fix sqlite-transient used in sqlite-bind.
    
    sqlite-transient is a value of C macro SQLITE_TRANSIENT and it is:
      typedef void (*sqlite3_destructor_type)(void*);
      #define SQLITE_STATIC      ((sqlite3_destructor_type)0)
      #define SQLITE_TRANSIENT   ((sqlite3_destructor_type)-1)

commit 2f151398d32b36aa0f92daed419306f34d055d2b
Author: Sunjoong Lee <sunjoong@gmail.com>
Date:   Wed May 2 02:48:15 2012 +0900

    Test whether a crash occurs when using sqlite-bind with a string.
    
    There was a segfault crash when using sqlite-bind with a string
    beacuse of sqlite-transient used in sqlite-bind.

commit 1122c52736f8382b093d5e626e77de41b1a23842
Author: David Pirotte <david@altosw.be>
Date:   Fri Jan 20 16:03:01 2012 -0200

    sqlite-open, reviewed
    
    This patch modifies the default optional flags value from 0 to
    SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE.  The API documentation says:
    "... This is the behavior that is always used for sqlite3_open() ... The
    sqlite3_open_v2() interface works like sqlite3_open() ..."

commit e24790f5f40647328b59800857bbd897f30a9421
Author: David Pirotte <david@altosw.be>
Date:   Fri Jan 20 14:38:13 2012 -0200

    sqlite3_enable_load_extension, added
    
    Extension loading while evaluating user-entered SQL is disabled per default.
    This API can be used to turn the sqlite3_load_extension() mechanism on and off.

commit 2b215efe32bb70781a1b97e9e3b69097aec72dd3
Author: Detlev Zundel <dzu@denx.de>
Date:   Mon Apr 11 16:55:03 2011 +0200

    As there is a 'null-pointer?' predicate use it.

commit c37f372990d9edddd859e9b999eb38151ce33cf8
Author: Detlev Zundel <dzu@denx.de>
Date:   Mon Apr 4 18:09:06 2011 +0200

    Fix sqlite-bind.
    
    - sqlite-transient needs to be a pointer
    - fix typo for string case

commit 97aae36202ca7ba0abec5cf0da95a56ac706805f
Author: Detlev Zundel <dzu@denx.de>
Date:   Mon Apr 4 18:13:18 2011 +0200

    Fix interpretation of null pointers from the library

commit f45fc5c709d241a147e061e92062993cce1b4841
Author: Detlev Zundel <dzu@denx.de>
Date:   Mon Apr 4 18:12:39 2011 +0200

    Add some basic functionality testing

commit 1018e0617b08c0f79556ea1e6188963ce01bb952
Author: Detlev Zundel <dzu@denx.de>
Date:   Mon Apr 4 18:11:58 2011 +0200

    Make sqlite-map really apply the procedure argument

commit 2418c58270cfd4cc8e6ee63e80c523e55554e8fe
Author: Detlev Zundel <dzu@denx.de>
Date:   Fri Apr 1 16:30:44 2011 +0200

    Fix command line parameter for test execution
    
    Signed-off-by: Detlev Zundel <dzu@denx.de>

commit c26452373fbe7a576e802f140448d65c594b4450
Author: Detlev Zundel <dzu@denx.de>
Date:   Thu Mar 31 18:15:12 2011 +0200

    Fix and simplify foreign string conversions
    
    Use the versions of string->pointer and pointer->string that accept an
    encoding parameter.
    
    The previous version of string->utf8-pointer missed the null termination
    of the string.
    
    Signed-off-by: Detlev Zundel <dzu@denx.de>

commit d1bea06d2a81eae69cc4f2b510a611ad5e1f815a
Author: Detlev Zundel <dzu@denx.de>
Date:   Thu Mar 31 18:14:06 2011 +0200

    Export SQLITE_* constants.
    
    Signed-off-by: Detlev Zundel <dzu@denx.de>

commit e784dd3b4824c7c9c46a79a9d131864039be2d66
Author: Andy Wingo <wingo@pobox.com>
Date:   Thu Nov 25 16:32:58 2010 +0100

    fix .go installation
    
    * Makefile.am: Fix installation.

commit cbfbe4c28bd74fa0c4a20b0d4c22fbb28476d3c9
Author: Andy Wingo <wingo@pobox.com>
Date:   Thu Nov 25 15:09:21 2010 +0100

    more conventional fold and map
    
    * sqlite3.scm (sqlite-fold, sqlite-map): Use a more conventional arg
      ordering.

commit a697362eced6cd23cf2d956b2e880bc0e758f58c
Author: Andy Wingo <wingo@pobox.com>
Date:   Thu Nov 25 14:52:30 2010 +0100

    sqlite-step returns rows from query
    
    * sqlite3.scm: Add ability to get data from the database.

commit 348c9cd384762b03ca7c56f97c130bf354d976dc
Author: Andy Wingo <wingo@pobox.com>
Date:   Thu Nov 25 13:33:23 2010 +0100

    add prepare / reset / finalize
    
    * sqlite3.scm: Add prepare / reset / finalize implementations.

commit 68e74cbec28ca6657441a059f9c50fb62940801f
Author: Andy Wingo <wingo@pobox.com>
Date:   Thu Nov 25 12:55:08 2010 +0100

    better error handling
    
    * sqlite3.scm: Move things around. Better error handling.

commit c1b506d7dbb91dc1daf53912479c58eca89d5caa
Author: Andy Wingo <wingo@pobox.com>
Date:   Thu Nov 25 12:24:30 2010 +0100

    initial import

[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 473 bytes --]

Re: Guile-SQLite3 - Guile-SQLite

[dsmich]

---- David Pirotte <david@altosw.be> wrote: 
> Hello Guilers,
> 
> I would like to work on and submit a GNU eval request for GNU Guile-SQLIte
> but 2 quizz first:
> 
> 1]
> 
> The current name is Guile-SQLite3 and I would like to drop the 3 from the name,
> precisely not to have the API version in the name, rather, as we do for GNU
> Guile-Gnome keeping the name generic and deal with these specificities in the source
> tree, tar names ...
> 
> However, Andy Wingo [the original author of Guile-SQLite3 binding] mentioned on irc
> that a guile-sqlite project previously existed maybe?  I can't find it and would
> like, if this is accurate, the author or anyone who would be aware to answer here,
> thanks!
> 
> If no answer, I'll consider the previous project either dead or maybe did not
> 'officially' existed and fell free to rename Guile-SQLite3 -> Guile-SQLite

The guile-sqlite that was on gitorius was by me.  It's very simple and basically
only exposes the exec call.  It's what sneek uses.

Andy's implementation is much more fully featured, and is also written in Scheme.
My guile-sqlite is written mostly in C.

-Dale

Re: Guile-SQLite3 - Guile-SQLite

[David Pirotte]

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

Hi Dale,

> > However, Andy Wingo [the original author of Guile-SQLite3 binding] mentioned on
> > irc that a guile-sqlite project previously existed maybe?  I can't find it and
> > would like, if this is accurate, the author or anyone who would be aware to
> > answer here, thanks!

> > If no answer, I'll consider the previous project either dead or maybe did not
> > 'officially' existed and fell free to rename Guile-SQLite3 -> Guile-SQLite  

> The guile-sqlite that was on gitorius was by me.  It's very simple and basically
> only exposes the exec call.  It's what sneek uses.

> Andy's implementation is much more fully featured, and is also written in Scheme.
> My guile-sqlite is written mostly in C.

Thanks for answering.  Since then we've been chatting on irc, so just to confirm here
and for followers that you have agreed I could rename.

Thanks,
David
 

[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 473 bytes --]

Re: Guile-SQLite3 - Guile-SQLite

[dsmich]

---- David Pirotte <david@altosw.be> wrote: 
> Hi Dale,
> 
> > > However, Andy Wingo [the original author of Guile-SQLite3 binding] mentioned on
> > > irc that a guile-sqlite project previously existed maybe?  I can't find it and
> > > would like, if this is accurate, the author or anyone who would be aware to
> > > answer here, thanks!
> 
> > > If no answer, I'll consider the previous project either dead or maybe did not
> > > 'officially' existed and fell free to rename Guile-SQLite3 -> Guile-SQLite  
> 
> > The guile-sqlite that was on gitorius was by me.  It's very simple and basically
> > only exposes the exec call.  It's what sneek uses.
> 
> > Andy's implementation is much more fully featured, and is also written in Scheme.
> > My guile-sqlite is written mostly in C.
> 
> Thanks for answering.  Since then we've been chatting on irc, so just to confirm here
> and for followers that you have agreed I could rename.

Yes, no problem.

> Thanks,
> David

-Dale