Re: [Springframework-developer] Demos

[William G. T. Jr. <wg...@rc...>]

+1 for HSQL.  I've used with Japple open source project for demo 
applications.  The uPortal project also uses it for their "quick-start" 
download.  It just works.

later.
Bill


Rod Johnson wrote:
> +1 for HSQL. I've been evaluating Kodo JDO at work, and their demo works
> very well with HSQL. No need to set it up: it just works. Very important for
> a demo.
> 
> Rod
> 
> ----- Original Message -----
> From: "Thomas Risberg" <tri...@tr...>
> To: <spr...@li...>
> Sent: Saturday, April 26, 2003 6:46 PM
> Subject: Re: [Springframework-developer] Demos
> 
> 
> 
>>Rod,
>>
>>Hypersonic is no longer in development - the source lives on though in
>>the HSQL Database Engine (HSQLDB) Project.
>>
>>This is from their web site
>>
>>*----------------------------------------------------------------
>> What is HSQLDB?
>>
>>    * It is an Open Source Java Database
>>    * It has standard SQL syntax and a JDBC interface
>>    * HSQLDB is FREE to use and re-distribute
>>    * It is compact
>>    * It is very fast
>>    * In-Memory, Standalone and Client/Server modes
>>    * It can be used also in Applets
>>
>>More Features:
>>
>>    * Indexes can be built and are used automatically
>>    * Transactions are supported
>>    * Joins between tables are possible
>>    * Referential Integrity
>>    * Java Stored Procedures and Functions are supported
>>    * Database can create SQL scripts
>>    * Security mechanism using users, passwords, access rights
>>    * Can be compiled for Java 1.1 and Java 2
>>
>>HSQLDB, based on HypersonicSQL, is a general purpose database. It is
>>very small and easy to install and use. It can be used in applets, for
>>testing, as a distributed application, and for production purposes.
>>*----------------------------------------------------------------
>>
>>I have used it a little bit, and I think it has most of the features
>>that we would require.  I think JBoss is still including some older
>>version of HSQLDB it in their install.
>>
>>The more I think about it, I think that this should be the default
>>target db.  Hopefully we can provide sample code for MySQL, Postgres and
>>Oracle as well.
>>
>>Thomas
>>
>>
>>
>>>What about Hypersonic? It seems well suited for demos as it's
> 
> potentially
> 
>>>zero configuration. But I don't know its capabilities.
>>
>>Transactionality is a
>>
>>>must.
>>>
>>>Rod