Problems with guile-sqlite3

[Detlev Zundel]

Hi,

having a all new shiny, I wanted to do some random tests with it and
turned to Andys sqlite3 bindings[1].  Compiling and installing worked
like a breeze but I'm having some beginners trouble.

Looking into sqlite3.scm I gather that the following session should
open up a connection to my "mydb" database:

,----
| scheme@(guile-user)> ,use (sqlite3)
| scheme@(guile-user)> (sqlite-open "mydb" SQLITE_OPEN_READONLY)
| ;;; <stdin>:2:0: warning: possibly unbound variable `SQLITE_OPEN_READONLY'
| <unnamed port>:1:0: In procedure #<procedure 9335250 at <current input>:2:0 
()>:
| <unnamed port>:1:0: In procedure module-lookup: Unbound variable: 
SQLITE_OPEN_READONLY
`----

Hm ok, so the constants seem not to be exported, right?

,----
| scheme@(guile-user)> (define db (sqlite-open "mydb" 1))
| <unnamed port>:0:0: In procedure #<procedure 9bf9690 at <current input>:1:0 
()>:
| <unnamed port>:0:0: Throw to key `sqlite-error' with args `(sqlite-open 14 
"Unable to open the database file")'.
`----

But that is strange, I'm sure I have this file.  So lets do an "strace
-e open guile" and see what guile accesses:

,----
| ....
| open("/usr/local/lib/guile/2.0/ccache/language/bytecode/spec.go", O_RDONLY) = 
91
| open("/opt/src/git/guile-sqlite3/tests/mydb\315\201", O_RDONLY|O_LARGEFILE) = 
-1 ENOENT (No such file or directory)
| <unnamed port>:0:0: In procedure #<procedure 8ce37d0 at <current input>:1:0 
()>:
| <unnamed port>:0:0: Throw to key `sqlite-error' with args `(sqlite-open 14 
"Unable to open the database file")'.
`----

Huh, what are those characters after "mydb"?  Funnily enough, if I use
filenames longer than 4 characters it works.  Can someone hit me with a
clue-stick please?

Thanks
  Detlev

[1] git://gitorious.org/guile-sqlite3/guile-sqlite3.git

-- 
I think that level of generalization is too abstract for useful thinking.
             -- Richard Stallman in <address@hidden>