* guile-dbi and PostgreSQL
@ 2017-07-21 7:34 Christopher Baines
2017-07-21 9:44 ` Nala Ginrut
0 siblings, 1 reply; 5+ messages in thread
From: Christopher Baines @ 2017-07-21 7:34 UTC (permalink / raw)
To: guile-user
[-- Attachment #1: Type: text/plain, Size: 671 bytes --]
Hey,
I've been having a try getting guile-dbi talking to PostgreSQL. I'm
using Guix packages, adapted to use the sources from [1].
1: https://github.com/opencog/guile-dbi/releases
So far, I'm getting an error about a undefined symbol.
scheme@(guile-user)> (define db-obj (dbi-open "postgresql" "postgres"))
scheme@(guile-user)> (dbi-query "\\d")
scheme@(guile-user)> (dbi-query db-obj "\\d")
scheme@(guile-user)> (display db-obj) (newline)
#<guile-dbi close postgresql postgres
(1 . /gnu/store/w5g1gpxbqfpkv0qnryglh6m7g9hd90an-guile-dbi-2.1.6/lib/libguile-dbi.so.2:
undefined symbol: __postgresql_query_g_db_handle)>
Any ideas?
Thanks,
Chris
[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 963 bytes --]
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: guile-dbi and PostgreSQL
2017-07-21 7:34 guile-dbi and PostgreSQL Christopher Baines
@ 2017-07-21 9:44 ` Nala Ginrut
2017-07-21 18:05 ` Christopher Baines
0 siblings, 1 reply; 5+ messages in thread
From: Nala Ginrut @ 2017-07-21 9:44 UTC (permalink / raw)
To: Christopher Baines; +Cc: Guile User
Have you installed guile-dbd-postgresql?
On Fri, Jul 21, 2017 at 3:34 PM, Christopher Baines <mail@cbaines.net> wrote:
> Hey,
>
> I've been having a try getting guile-dbi talking to PostgreSQL. I'm
> using Guix packages, adapted to use the sources from [1].
>
> 1: https://github.com/opencog/guile-dbi/releases
>
> So far, I'm getting an error about a undefined symbol.
>
> scheme@(guile-user)> (define db-obj (dbi-open "postgresql" "postgres"))
> scheme@(guile-user)> (dbi-query "\\d")
> scheme@(guile-user)> (dbi-query db-obj "\\d")
> scheme@(guile-user)> (display db-obj) (newline)
> #<guile-dbi close postgresql postgres
> (1 . /gnu/store/w5g1gpxbqfpkv0qnryglh6m7g9hd90an-guile-dbi-2.1.6/lib/libguile-dbi.so.2:
> undefined symbol: __postgresql_query_g_db_handle)>
>
> Any ideas?
>
> Thanks,
>
> Chris
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: guile-dbi and PostgreSQL
2017-07-21 9:44 ` Nala Ginrut
@ 2017-07-21 18:05 ` Christopher Baines
[not found] ` <CAPjoZod_NcbCd=JVs1f9wVqgWF37zQKusB=JoHX9oj154JfDTg@mail.gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Christopher Baines @ 2017-07-21 18:05 UTC (permalink / raw)
To: Nala Ginrut; +Cc: Guile User
[-- Attachment #1: Type: text/plain, Size: 704 bytes --]
On Fri, 21 Jul 2017 17:44:15 +0800
Nala Ginrut <nalaginrut@gmail.com> wrote:
> Have you installed guile-dbd-postgresql?
I'm not quite sure what installed would mean in this case? I've copied
the guix guile-dbd-sqlite3 package, and adjusted it to be
guile-dbd-postgresql.
I'm then testing using:
guix environment --ad-hoc guile guile-dbi guile-dbd-postgresql
From looking at the code, I was guessing I'd get a different error if
the library wasn't found, as I though this [1] check might fail, but
I'm struggling to read the guile-dbi code, as I'm not familiar at all
with using Guile within C.
1:
https://github.com/opencog/guile-dbi/blob/master/guile-dbi/src/guile-dbi.c#L75
[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 963 bytes --]
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: guile-dbi and PostgreSQL
[not found] ` <CAPjoZoeaSnvwxDfEmB1nMTpUT=uX-FAxXPhBTPGVHm6GHiR03w@mail.gmail.com>
@ 2017-07-22 4:32 ` Nala Ginrut
2017-07-22 7:52 ` Christopher Baines
0 siblings, 1 reply; 5+ messages in thread
From: Nala Ginrut @ 2017-07-22 4:32 UTC (permalink / raw)
To: Christopher Baines; +Cc: Guile User
Why you modify dbd-sqlite3 for that? There's dbd-postgresql
2017年7月22日 02:05,"Christopher Baines" <mail@cbaines.net>写道:
On Fri, 21 Jul 2017 17:44:15 +0800
Nala Ginrut <nalaginrut@gmail.com> wrote:
> Have you installed guile-dbd-postgresql?
I'm not quite sure what installed would mean in this case? I've copied
the guix guile-dbd-sqlite3 package, and adjusted it to be
guile-dbd-postgresql.
I'm then testing using:
guix environment --ad-hoc guile guile-dbi guile-dbd-postgresql
From looking at the code, I was guessing I'd get a different error if
the library wasn't found, as I though this [1] check might fail, but
I'm struggling to read the guile-dbi code, as I'm not familiar at all
with using Guile within C.
1:
https://github.com/opencog/guile-dbi/blob/master/guile-
dbi/src/guile-dbi.c#L75
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: guile-dbi and PostgreSQL
2017-07-22 4:32 ` Nala Ginrut
@ 2017-07-22 7:52 ` Christopher Baines
0 siblings, 0 replies; 5+ messages in thread
From: Christopher Baines @ 2017-07-22 7:52 UTC (permalink / raw)
To: Nala Ginrut; +Cc: Guile User
[-- Attachment #1: Type: text/plain, Size: 303 bytes --]
On Sat, 22 Jul 2017 12:32:23 +0800
Nala Ginrut <nalaginrut@gmail.com> wrote:
> Why you modify dbd-sqlite3 for that? There's dbd-postgresql
As far as I can see, I don't have a Guix package for dbd-postgresql. I
didn't mean modify dbd-sqlite3 in terms of code, just the Guix package
definition.
[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 963 bytes --]
^ permalink raw reply [flat|nested] 5+ messages in thread
end of thread, other threads:[~2017-07-22 7:52 UTC | newest]
Thread overview: 5+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2017-07-21 7:34 guile-dbi and PostgreSQL Christopher Baines
2017-07-21 9:44 ` Nala Ginrut
2017-07-21 18:05 ` Christopher Baines
[not found] ` <CAPjoZod_NcbCd=JVs1f9wVqgWF37zQKusB=JoHX9oj154JfDTg@mail.gmail.com>
[not found] ` <CAPjoZoeaSnvwxDfEmB1nMTpUT=uX-FAxXPhBTPGVHm6GHiR03w@mail.gmail.com>
2017-07-22 4:32 ` Nala Ginrut
2017-07-22 7:52 ` Christopher Baines
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).