I've found that it's pretty hard to beat Hypersonic for development.
The only caveat is that you need to run it in "server mode" in order to
get concurrent access to the database; otherwise the database files are
locked by Orion and you can't see what's going on.
As far as Interbase goes, there is some discussion of it in the list
archives:
http://www.mail-archive.com/cgi-bin/htsearch?method=and&format=short&con
fig=orion-interest_orionserver_com&restrict=&exclude=&words=interbase+sc
hema
Random cool thing: I highly recommend ISQL-Viewer as a query tool.
http://web.tampabay.rr.com/mkobold/isql/index.html
Sometimes I wish I had a text version, though. Does anyone know of one?
Jeff
>-----Original Message-----
>From: Chris Bartling [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, January 25, 2001 6:10 PM
>To: Orion-Interest
>Subject: RE: interbase database schema
>
>
>What about MySQL? Works under both Windows and Linux and is
>open source.
>Doesn't do everything a DB2 or Oracle does (subselects
>instantly come to
>mind), but it does work well. Plus, O'Reilly has a great book
>out on MySQL,
>so documentation is not a problem. JDBC drivers are readily
>available. All
>of this can be found at http://www.mysql.com. I've been using
>MySQL and
>Orion together on Windows 2000 without a problem.
>
>
>-- chris --
>
>
>
>-----Original Message-----
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED]]On Behalf Of Magnus Rydin
>Sent: Thursday, January 25, 2001 3:35 AM
>To: Orion-Interest
>Subject: SV: interbase database schema
>
>
>hSQL (java based) that is shipped with Orion is very neat for
>development,
>but probably not the best choice for a production environment.
>In production I would recommend DB2 or Oracle.. Not open source, but
>trustworthy.
>WR
>> -----Ursprungligt meddelande-----
>> Från: H.Bakker [mailto:[EMAIL PROTECTED]]
>> Skickat: den 25 januari 2001 00:46
>> Till: Orion-Interest
>> Ämne: interbase database schema
>>
>>
>> Good morning.
>>
>> We are doing some experiments with Orion, and it looks very good.
>>
>> We are looking for a (preferable open source) database with
>> will work in a
>> production environment under Linux, but can also be used
>> under Windows in a
>> development environment because not all developers we have,
>> use Linux as
>> their development environment.
>>
>> We already use Interbase from Borland, but I could not find
>a database
>> scheme in 1.45
>> Does anybody already have a schema or a other suggestion for
>> a database?
>>
>> thanks in advance,
>>
>> Regards
>>
>> Hans Bakker
>> A-Net Internet Services
>> www.a-net.nl/english
>> partner of www.ejbprovider.com
>>
>>
>
>
>
