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 <[email protected]> > > To: [email protected] > > 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 > > [email protected] > > http://lists.puredata.info/listinfo/pd-dev > > > > > > > _______________________________________________ > Pd-dev mailing list > [email protected] > http://lists.puredata.info/listinfo/pd-dev _______________________________________________ Pd-dev mailing list [email protected] http://lists.puredata.info/listinfo/pd-dev
