Hi,

For the moment it seems that Pharo + SQLite3 + JSON1 will not be needed. NeoJSON is making an excellent work for querying the JSON file. By the way, I was testing with Punqlite and the installation process is very friendly. It even load the unqlite.so and puts it in the proper location (but I'm using NeoJSON just fine).

Cheers,

Offray

Hi all,

I have finished my dummy data mock ups as you can see below (or in [1][2] )

[1] https://www.list.inf.unibe.ch/pipermail/moose-dev/2016-June/025799.html

[2] https://offray.withknown.com/2016/data-selfie-dummy

Now I'm ready to start injecting real data into them. Because data comes from a JSON dump, I would like to use the JSON1 extension of SQLite, [3][4], which means compiling it by myself from SQLite amalgamation and putting the binary in a place where UDBCSQLite3 is aware of it. I'm on a Linux 64 bits machine and I have sqlite2 32 bits binary from the distro repositories. When I linked the distro provided binary to the image location, UDBCSQLite3 works fine (but precompiled binary doesn't have JSON1 extension enabled), but when I put there my compiled binary with JSON1 support instead, UDBC complains about "external module not found". How can I made UDBCSQLite3 aware of my compiled binary ?

[3] https://www.sqlite.org/json1.html

[4] http://www.samadhiweb.com/blog/2016.04.24.sqlite.json.html

Thanks,

Offray