RE: Why is Hypersonic SQL still being integrated
I'm willing to take over maintenance/development on this. Are people interested in keeping it alive (I know I am)? Well I'm interested in it being kept alive for all the obvious reasons stated on the list - small, free, relatively fast (for small projects anyway by the sounds of it), portable etc. It badly needs a command-line admin utility ala Oracle's SQLPlus though as Unix servers typically won't have a graphical display for any graphical management tool to hook up to. The applet - although a nice feature - which was on the Hypersonic site before it died is really out of the question - certainly having to fire up a browser just to work on the DB is too darn painful! Someone in this thread mentioned that it isn't sensible to use Hypersonic in production environments - why not? What's so wrong with it that it wouldn't work, just out of curiousity? cheers Jules
Re: Why is Hypersonic SQL still being integrated
Hello Randy, Many people still find it useful to have a simple db preinstalled to play around with and not having to seperately download one and set it up. And considering hsql just adds about 170k, it's not a big issue to keep it there. Regards, Karl Avedal Kemp Randy-W18971 wrote: If HypersonicSQL is a dead project, why is it still being shipped with Orion?
RE: Why is Hypersonic SQL still being integrated
Why not? Really, as a simple test/example database, what shortcoming does it have? Just because nobody is fixing/adding new bugs to the code at the moment doesn't mean that the current incarnation is not perfectly adequate for its task. I don't think anyone in their right mind would run a production system with hsql, but for development I've never used anything so convenient. Having the sql spit out to the hypersonic console in server-mode is great! Jeff -Original Message- From: Kemp Randy-W18971 [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 6:36 AM To: Orion-Interest Subject: Why is Hypersonic SQL still being integrated If HypersonicSQL is a dead project, why is it still being shipped with Orion?
RE: Why is Hypersonic SQL still being integrated
It still works doesn't it? I'm willing to take over maintenance/development on this. Are people interested in keeping it alive (I know I am)?
RE: Why is Hypersonic SQL still being integrated
Just because it's dead, doesn't mean that it doesn't do the job. Keep in mind that for these new tings in J2EE to work (especially EJB), you need some kind of a repository/default container. That doesn't mean you can't use another database as an alternate datasource or connect to one. I believe the Orion developers have more to worry about than what the default datasource their product ships with is and its status. I believe the choice of Hypersonic/hsql had more to do with licensing (GPL) than what best-of-breed database to include. After all, Sun ships J2EE Beta 3 with Cloudscape. Also, keep in mind that hsql was NEVER adequate for any but devel projects. It is not going to be what anyone would go to production withBottom line: find a datasource you are comfortable with and adapt Orion to use that. Kdb (http://www.kx.com ), Instantdb (http://instantdb.enhydra.org/index.html ), Cloudscape (Informix, I believe) MSSQL Server, Oracle, Sybase ADA, IBM UDB and postgres are all fine candidates, or, roll your own! Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kemp Randy-W18971 Sent: Wednesday, March 14, 2001 8:36 AM To: Orion-Interest Subject: Why is Hypersonic SQL still being integrated If HypersonicSQL is a dead project, why is it still being shipped with Orion?
RE: Why is Hypersonic SQL still being integrated
InstantDB (for a Java database), which is actively developed by Enhydra (www.enhydra.org). -Original Message- From: Tim Endres [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 11:47 AM To: Orion-Interest Subject: Re: Why is Hypersonic SQL still being integrated If HypersonicSQL is a dead project, why is it still being shipped with Orion? What is the better alternative?
RE: Why is Hypersonic SQL still being integrated
Jeff: It has no shortcomings for now, but is not being actively worked on, which could introduce bugs with new Orion releases. A better alternative is instantDB by Enhydra, which is free and actively worked up (actually, both are shipped with Jboss). -Original Message- From: Jeff Schnitzer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 11:11 AM To: Orion-Interest Subject: RE: Why is Hypersonic SQL still being integrated Why not? Really, as a simple test/example database, what shortcoming does it have? Just because nobody is fixing/adding new bugs to the code at the moment doesn't mean that the current incarnation is not perfectly adequate for its task. I don't think anyone in their right mind would run a production system with hsql, but for development I've never used anything so convenient. Having the sql spit out to the hypersonic console in server-mode is great! Jeff -Original Message- From: Kemp Randy-W18971 [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 6:36 AM To: Orion-Interest Subject: Why is Hypersonic SQL still being integrated If HypersonicSQL is a dead project, why is it still being shipped with Orion?
RE: Why is Hypersonic SQL still being integrated
Karl: Thank you. On second thought, you are probably right. But I wonder if InstandDB could be added, like they do in Jboss? If not, no big deal. Randy -Original Message- From: Karl Avedal [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 10:57 AM To: Orion-Interest Subject: Re: Why is Hypersonic SQL still being integrated Hello Randy, Many people still find it useful to have a simple db preinstalled to play around with and not having to seperately download one and set it up. And considering hsql just adds about 170k, it's not a big issue to keep it there. Regards, Karl Avedal Kemp Randy-W18971 wrote: If HypersonicSQL is a dead project, why is it still being shipped with Orion?