[PD-dev] connecting to an extended sqlite3 database

[Hans-Christoph Steiner]

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 at yahoo.com>
> > To: pd-dev at 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 at iem.at
> > http://lists.puredata.info/listinfo/pd-dev
> > 
> 
> 
>       
> 
> _______________________________________________
> Pd-dev mailing list
> Pd-dev at iem.at
> http://lists.puredata.info/listinfo/pd-dev