InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors

This is a reply that Peter Hearty made in response to a similar
question...
"The main difference between the two is in the way data is made
persistent. InstantDB uses  fixed length records to save each row
of a table to its own file on disk. Transaction  recovery takes place
via a disk based journal file. I think Hypersonic is primarily memory
based and uses sql scripts and compressed memory images for backup
(but it would be  better to get Hypersonic's author to give a fuller
description of this). Both have some  features that the other doesn't
have. InstantDB has more transaction and table locking  support,
simultaneous thread access, hooks for plug in triggers, encryption
and user defined  functions. Hypersonic has multiple usernames and
priviliges and foreign key support which are missing in InstantDB.
Both provide the usual wide choice of data types and both occupy
only a couple of hundred kbytes of space."

James Shipley wrote:

> Hi All,
>
> I am new to InstantDB, but have used another All-Java database called
> HypersonicSQL (http://hsql.oron.ch). Does anyone have experience with both
> InstantDB and HypersonicSQL so as to give me a comparison of the two? Any
> info would be appreciated.
>
> James
> jamesshipley@hotmail.com
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> -----------------------------------------------------------------------------
> To unsubscribe from this mailing list, send email to majordomo@enhydra.org
> with the text "unsubscribe instantdb" in the body of the email.
> If you have other questions regarding this mailing list, send email to
> the list admin at owner-instantdb@enhydra.org.

--
David H. Young, Chief Evangelist
Lutris Technologies, Inc.
1200 Pacific Avenue, Suite 300
Santa Cruz, CA 95060 USA
http://www.lutris.com
http://www.enhydra.org
831.460.7310


-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.