Storing HL7 messages

There are lots of ways to do it:

– flat file using an identifier as part of the filename

– Sqlite database

– gdbm database

– global variable

Take your pick.

Using GDBM depends on the Cloverleaf version you are using.

GDMB is deprecated in Cloverleaf 5.8.1.0 or higher.

You need to migrate from GDBM to SQLite in 5.8.1.0 and there is an migration tool available for it. Have a look in the release notes of 5.8.1.0 for a description.

I would advice to use SQLite. We use SQLite quite often to solve issues.

Best regards

Have a look on http://www.sqlite.org/

There is also a chapter on their website about the TCL interface.

That’s the interface you need within Cloverleaf.

Building your SQLite Database file is possible with free SQLite

If you decide to use SQLite be sure to read the limitations carefully in the doc before you make any design decisions.

Also don’t forget to figure out how you will handle the administrative tasks – like finding stale messages which never had a partner come through to pick up the information.

You post this Jim and people think that sqlite cannot perform the full functionality of a relational database.   It definately can!

Other than not having controlled access, what limitations are you referring to?

Correct – you do not need ODBC to connect to SQLite. There are many examples in Clovertech of SQLite code in TCL.

One advantage of SQLite over SQL Server or Oracle is that it is on the same server as Cloverleaf and therefore highly available.

It does not support stored procedures, but this is a design choice. SQLite is meant to be lean and fast.