Hi,
I'm trying to connect to a sqlite3 database v.3.7.3 (amalgamation). Since sqlite3 doesn't come with mathematical functions like sqrt, I needed to extend it using extension-functions.c (available from http://sqlite.org/contrib). Before the extension, I was able to query the database with no problem. Now with the extension, I needed to add these lines to my code:
... error =sqlite3_enable_load_extension(x->db,1); ///Enable loading mathematical extensions if(error){ post("error enabling extension loading"); }
error=sqlite3_load_extension(x->db,"libsqlitefunctions.dylib",0,x->pzErrMsg); ...
The code compiles fine, but when I try to run it I have this error:
dlopen(PathToMyObj.pd_darwin, 10): Symbol not found: _sqlite3_enable_load_extension
I believe that's a linking error, but I don't know how to solve it, and I'm sorry but I can't include a minimal functioning example. But, I can tell you what I have: I'm using a Makefile posted here http://puredata.info/docs/developer/MakefileTemplate I'm in a MacBook Pro 10.6.4 I'm using Pd-Extended v. 0.42.5
I guess is something simple like adding a filename to the compiler, but I just can't figure it out, any help would be much appreciated.
Thank you in advance!
Julian Villegas, Ph.D. http://julovi.net
Me pregunto de un modo pensativo Que significa ser Colombiano? No se le respondi. Es un acto de fe JLB.
The problem was that sqlite3 was compiled for 64-bit, I fixed downloading the tar file of the amalgamation version, using
./configure CFLAGS=-m32 and proceeding as mentioned in the install file inside the tar. After that, compiling the PD object giving the
LDFLAGS = -L/usr/local/lib -lsqlite3
Julian Villegas, Ph.D. http://julovi.net
Me pregunto de un modo pensativo Que significa ser Colombiano? No se le respondi. Es un acto de fe JLB.
----- Original Message ----
From: Julian Villegas julovi@yahoo.com To: pd-dev@iem.at Sent: Mon, November 8, 2010 11:28:58 PM Subject: [PD-dev] connecting to an extended sqlite3 database
Hi,
I'm trying to connect to a sqlite3 database v.3.7.3 (amalgamation). Since sqlite3 doesn't come with mathematical functions like sqrt, I needed to extend
it using extension-functions.c (available from http://sqlite.org/contrib). Before the extension, I was able to query the database with no problem. Now with
the extension, I needed to add these lines to my code:
... error =sqlite3_enable_load_extension(x->db,1); ///Enable loading mathematical extensions if(error){ post("error enabling extension loading"); }
error=sqlite3_load_extension(x->db,"libsqlitefunctions.dylib",0,x->pzErrMsg); ...
The code compiles fine, but when I try to run it I have this error:
dlopen(PathToMyObj.pd_darwin, 10): Symbol not found: _sqlite3_enable_load_extension
I believe that's a linking error, but I don't know how to solve it, and I'm sorry but I can't include a minimal functioning example. But, I can tell you what I have: I'm using a Makefile posted here http://puredata.info/docs/developer/MakefileTemplate I'm in a MacBook Pro 10.6.4 I'm using Pd-Extended v. 0.42.5
I guess is something simple like adding a filename to the compiler, but I just
can't figure it out, any help would be much appreciated.
Thank you in advance!
Julian Villegas, Ph.D. http://julovi.net
Me pregunto de un modo pensativo Que significa ser Colombiano? No se le respondi. Es un acto de fe JLB.
Pd-dev mailing list Pd-dev@iem.at http://lists.puredata.info/listinfo/pd-dev
There was a SQlite library made a while back.
.hc
On Tue, 2010-11-09 at 09:32 -0800, Julian Villegas wrote:
The problem was that sqlite3 was compiled for 64-bit, I fixed downloading the tar file of the amalgamation version, using
./configure CFLAGS=-m32 and proceeding as mentioned in the install file inside the tar. After that, compiling the PD object giving the
LDFLAGS = -L/usr/local/lib -lsqlite3
Julian Villegas, Ph.D. http://julovi.net
Me pregunto de un modo pensativo Que significa ser Colombiano? No se le respondi. Es un acto de fe JLB.
----- Original Message ----
From: Julian Villegas julovi@yahoo.com To: pd-dev@iem.at Sent: Mon, November 8, 2010 11:28:58 PM Subject: [PD-dev] connecting to an extended sqlite3 database
Hi,
I'm trying to connect to a sqlite3 database v.3.7.3 (amalgamation). Since sqlite3 doesn't come with mathematical functions like sqrt, I needed to extend
it using extension-functions.c (available from http://sqlite.org/contrib). Before the extension, I was able to query the database with no problem. Now with
the extension, I needed to add these lines to my code:
... error =sqlite3_enable_load_extension(x->db,1); ///Enable loading mathematical extensions if(error){ post("error enabling extension loading"); }
error=sqlite3_load_extension(x->db,"libsqlitefunctions.dylib",0,x->pzErrMsg); ...
The code compiles fine, but when I try to run it I have this error:
dlopen(PathToMyObj.pd_darwin, 10): Symbol not found: _sqlite3_enable_load_extension
I believe that's a linking error, but I don't know how to solve it, and I'm sorry but I can't include a minimal functioning example. But, I can tell you what I have: I'm using a Makefile posted here http://puredata.info/docs/developer/MakefileTemplate I'm in a MacBook Pro 10.6.4 I'm using Pd-Extended v. 0.42.5
I guess is something simple like adding a filename to the compiler, but I just
can't figure it out, any help would be much appreciated.
Thank you in advance!
Julian Villegas, Ph.D. http://julovi.net
Me pregunto de un modo pensativo Que significa ser Colombiano? No se le respondi. Es un acto de fe JLB.
Pd-dev mailing list Pd-dev@iem.at http://lists.puredata.info/listinfo/pd-dev
Pd-dev mailing list Pd-dev@iem.at http://lists.puredata.info/listinfo/pd-dev
-
Hans-Christoph Steiner -
Julian Villegas