Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

HSQLDB users take note

 
Ernest Friedman-Hill
author and iconoclast
Marshal
Pie
Posts: 24208
35
Chrome Eclipse IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi folks --

If you've used, or are using HSQLDB (http://hsqldb.sourceforge.net/) I'd appreciate a brief description of what you did with it and what you think. I'm trying to get an idea of how much usage this software actually gets.
 
Sonny Gill
Ranch Hand
Posts: 1211
IntelliJ IDE Mac
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I used it for my university project once. It was a web application with JSP, Servlets and a bundled-in HSQL DB.
I think I will probabely use it again for writing sample applications etc.
 
Lasse Koskela
author
Sheriff
Posts: 11962
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I once used it for a in-memory database that was not persisted on disk at all.
 
Peter den Haan
author
Ranch Hand
Posts: 3252
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
We're using it in the automated integration tests for the Spring/Hibernate/Oracle project we've been working on for the last nine months. Can't say anything about its behaviour in a production situation, but it is happy enough to handle the sometimes hefty SQL statements Hibernate throws at it during the tests.

- Peter
 
Balaji Loganathan
author and deputy
Bartender
Posts: 3150
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Very tiny and efficient,
It helped me to shift my whole webapp application including database as a jar file. All the user have to do is install the jar in their application server.
 
Gregg Bolinger
GenRocket Founder
Ranch Hand
Posts: 15302
6
Chrome IntelliJ IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I used it to deliver an Access like Swing Application for someone that wanted to persist all his Star Wars crap. He had one in MS Access so I basically mirrored its functionallity and used HSQLDB so he didn't need anything extra to install.
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
We have previously used HSQLDB as a server for the very-early startup phases of projects, knowing that it would be replaced before the project got too serious. It's a bit hard to explain the decision process, it was a while ago. We tend to default to MySql now when the database is unspecified.

I also tend to plug a standalone instance into web apps when I'm just scratching out a thought.
 
steve souza
Ranch Hand
Posts: 862
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I use it in my demo application as an in-memory database that allows me to ship my war and require no installation of a separate database product like mySQL on the end users part.

If you go to http://ssouza.kgbinternet.com/fdsapi/demo.jsp any of the queries you issue go against hsqldb. This sample war is also available for download from http://www.fdsapi.com
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic