good database

[gsslazslo]

Hi

What's a good database to help build a data-driven app like contacts w/ maybe 300 entries? I was thinking Access. Can I connect Laszlo
w/ Access using jdbc ...

Thanks.

GSS

[antun]

Personally, I would use mySQL, but that's just my preference.

Right now the LPS hasn't got any JDBC/ODBC connectors (although they are on the roadmap for the future) - you'd have to write a script (PHP/ASP/Perl etc.) that did the queries for you, and returned XML data.

-Antun

[hqm]

I always use Postgres. It installs in 10 minutes, and
is more featureful than MySQL. It supports real ANSI SQL (subselects, transactions, and tons of other
great stuff). I consider Postgres a good rival for
Oracle all the way up to midrange applications.

For your app, it might be overkill, but since it is so easy to install and so low maintenance, I would consider it, especially if you plan to do a more complex app in the future that requires SQL capability.

[vfunshteyn]

I highly recommend hsqldb (http://hsqldb.sourceforge.net). It's free, fast, easy to configure and it's pure Java. And you can easily deploy it by dropping a single JAR file into the WEB-INF/lib directory of your webapp, which will cause it to run in-process with your server container engine. In my opinion, this feature makes it the most natural choice for a small DB engine if you're going to implement your data source as a JSP.