Building sqlite

[Richard Hart]

AIX 5.3

Cloverleaf 5.4.1

I am looking at building SQLite on this platform and linking with Cloverleaf.

Has anybody built  this and is willing to share the gotchas.

Thanks.

Topic

[Charlie Bursell]

What OS?  We have it running on several.  I use sqlite a lot

[Richard Hart]

Charlie.

We are running on AIX 5.3.

I can build the SQLite core and it works with the Unix shell.  

I can, with a few Makefile tweeks, build the TEA , but this ‘core’ dumps when I try the tcl load

tcl>load ./libsqlite3.3.8.so

Segmentation fault(coredump)

Any ideas?

Thanks.

[Dean Basher]

Richard sent a email to support@quovadx.com and I wll see about getting a copy of sqlite for AIX

[Bala Pisupati]

Can anyone tell me how to import data from command line in sqlite table. ( I don’t want it through GUI).

[Bala Pisupati]

Ok I was able to put data from a file into a table. But, I couldn’t read the data by using select * from

;

can someone tell me why? or how to look at the data that I imported.

[Gary Atkinson]

Well, I’ll jump into this topic as well.  If anyone would be willing to chat about using sqlite on AIX 5.3 with cloverleaf 5.5, I’m am interested.  I would like to try using this to store some field data to be used later on.

gatkinson@bwmc.umms.org

410-787-6777

thanks,

Gary

[Charlie Bursell]

You can find all you need and more about SQLite on the web.

For Documentation: http://www.sqlite.org/docs.html

Wiki: http://www.sqlite.org/cvstrac/wiki

Mailing List: http://news.gmane.org/gmane.comp.db.sqlite.general

[Gary Atkinson]

Thanks for those links they do provide lots of information.  A few questions on package installs if I may. Is the shared object file (tclsqlite-3.5.3.so.gz) all I need in an AIX os?  Where is the best place to store the object file and pkgIndex file in cloverleaf?

Gary

[Charlie Bursell]

If it includes the .so file for your version of AIX, that is good.  In the past we have always had to compile it on Unix boxes.

Remember that Tcl will search your Tcl path and one level below when searching for packages.  To see your Tcl path echo $::auto_path from within Tcl (hcitcl).

If I want a package to be available to all sites in a root, I will usually put in under $HCIROOT/tcl/lib.  For example, you could crete a directory like: $HCIROOT/tcl/lib/sqlite

If you want it for a specific site, create a subdirectory under your site tclprocs directory.  For example, I usually do something like: $HCISITEDIR/tclprocs/lib.

Then your directory from above must have a pkgIndex.tcl file with reference to the .so file.  I would put the libsqlite3.so , or whatever name, in the same directory as the pkgIndex.tcl file.

You can build the pkgIndex.tcl file either by hand or with a script.  If you want one that just includes the sqlite library, simply edit a file named pkgIndex.tcl and put the following:

package ifneeded sqlite 3.3.8

]

Change name of .so file to match what you have.  Once complete, go to a hcitcl prompt anywhere in the site and execute:

    package require sqlite

It should return: 3.3.8

Good luck with it.  It is worth the effort!

[James Cobane]

Gary,

I’ve attached a document outlining what we did to get SQLite on our AIX box (I pretty much just downloaded the libsqlite3.3.8.so file and ran the mkpkgindex command).

[Chris Williams]

Has anyone built sqlite for HP-UX 11i? I found the source, but we don’t have an ANSI-C compiler on our box. The stripped-down version of cc that comes with HP-UX can’t handle it.

Thanks.

[James Cobane]

Richard,

For our AIX box, I pulled a compiled version from http://teapot.activestate.com/package/list.  There is a list of pre-compiled packages for various OS’s and I pulled ours from http://teapot.activestate.com/package/name/sqlite3/ver/3.3.8/arch/aix-powerpc/file.zip.  We installed it and it seems to function fine.  I had gotten this information from Quovadx Support; you may want to check/verify with them.

It looks like there are hp-unix versions, and you may be able to pull one down from http://teapot.activestate.com/package/name/sqlite3/ver/3.3.8/arch/hpux-parisc/file.zip

Hope this helps.

Jim Cobane

Henry Ford Health

[Tom Rioux]

AIX 5.3.6

Cloverleaf 5.6

I’m attempting to build my first sqlite interface.  It is very simple and have followed Jim’s instructions on here as well as help from Healthvision support in getting sqlite on my server.  However, I wrote a script based on Jim’s template on here, and on my first command:

sqlite DBCMD $dbName

I get an error that says “out of memory”.  This is a new test box with way more than enough memory to run anything.   Am I missing something?

Thanks…

Tom Rioux

[Tom Rioux]

AIX 5.3.6

Cloverleaf 5.6

I’m attempting to build my first sqlite interface.  It is very simple and have followed Jim’s instructions on here as well as help from Healthvision support in getting sqlite on my server.  However, I wrote a script based on Jim’s template on here, and on my first command:

sqlite DBCMD $dbName

I get an error that says “out of memory”.  This is a new test box with way more than enough memory to run anything.   Am I missing something?

Thanks…

Tom Rioux

[Rick Pritchett]

James,

Could i possibly look at the could used to populate the database with patient demographics.  We are starting to look at sqlite as a possible solution to one of our needs solution.

[John Mercogliano]

Just to let you know, I have successfully used sqllite from teapot for HP-UX 11.11 under QDX 5.6.  Regretfully, the version on teapot is only compatible with tcl 8.4 so it does not work on 5.2 which is our current production version.  Darn 🙁

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[Charlie Bursell]

The Tcl library for sqlite requires Tcl 8.4 regardless of where it is run.

I have successfully used sqlite on older versions of Cloverleaf running Tcl 8.3.  I simply install the command line version of sqlite in my path, e.g., $HCISITEDIR/bin.  Then simply exec it from a Tcl script like:

     

set rtn [exec sqlite ““]

You might want to put inside a catch statement just in case

[James Cobane]

Rickey,

I’ll dig-up the code and throw it up here (with all the usual disclaimers; i.e. “as is”, “use at your own risk”,  🙂  ).  Stay tuned.

Jim Cobane

Henry Ford Health

[James Cobane]

OK, here is the snippet of code.

Hope this helps.

Jim Cobane

Henry Ford Health

[Rick Pritchett]

Thank you for the example James.

[Rick Pritchett]

Can anyone give me some real world examples of where they are currently using sqlite.  I have been able to get it working for us and if is as good as everyone says would like to use it for more than replacing a few tables.

[Author]

Replies