Re: Looking for in-memory database that can write to disk as well

In article <7t684c$k7f_at_chronicle.concentric.net>, "CHANGE username to westes" <junkmail_at_uscsw.com> wrote:
>I'm looking for vendors who sell a specialized kind of database. I need the
>database to be implemented in memory, but with the ability to flush changes
>in the database to disk as a background operation. This will be used to
>store temporary data that needs to be accessed from multiple machines, but
>which by its nature does not require saving to disk *as part of the
>transaction* that creates the data.
>

The best "shoe" for your spec is HypersonicSQL. Grab a copy from: http://www.lynx.ch/contacts/~/thomasm/hSqlDownload.html

>Ideally, the database would allow a transaction from a remote client, write
>the information to memory, then notify the client that the transaction is
>finished. Later, as time allows, the database would flush the transaction
>to disk for permanent storage, so it would be available the next time it
>starts up.
>

The writing of changes to disk will be on you part, but working with databases in memory is right up HSQL's alley. The most recent version is very nice.

--

• Sometimes, the BEST things in life really ARE free... *
• Get a FREE copy of NetRexx 1.150 for your next java project at: *
• http://www2.hursley.ibm.com/netrexx *

  ---

/----------------------------------------\
| From the desktop of: Jerome D. McBride |
|         mcbrides_at_erols.com             |
\----------------------------------------/

-- Received on Sat Oct 02 1999 - 20:17:46 CDT