Building sqlite

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

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

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

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.

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

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

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

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!

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).

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.

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

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

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

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.

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 🙁

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

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

OK, here is the snippet of code.

Hope this helps.

Jim Cobane

Henry Ford Health

Thank you for the example James.

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.