Recommend me a database...
Hi,
I'm looking for a free database to use with a java application. Ideally the database would be widely hosted by cheaper web-hosting companies (it is largely for my own practice but I would like it to be able to grow if all goes well).
My ideal choice would be mySQL, which I had assumed was free, but from looking at their website, it does appear to require purchase - is there a legitimate free version?
I'm also intrigued by the Oracle 10g Express - does anyone have any opinions on this or any other recommendations?
Many thanks,
GM_UAM
[581 byte] By [
GM_UAMa] at [2007-11-27 4:46:43]
# 1
MySQL only requires a purchase if you distribute it or give direct access to it (I believe). AFAIK, you are able to freely use it as a backend.
PostGreSQL is another good choice, and, if you create it (and the access to it) as an application context item, you can even use the embedded Derby/JavaDB stuff (then you don't even need to worry about the WebHosting providing DB Access as it is embedded, you only need to worry about how much disk space you are using).
# 4
PostgreSQL is nice, but one disadvantage for use with JDBC is that it's JDBC driver does not support getGeneratedKeys(). You have to retrieve those autoincrement sequences manually.
MySQL is nice, but it has somewhat an unique subset of SQL commands and behaviours. You will risk big problems when you're planning to migrate to another (and "real") SQL servers, like DB2 or MSSQL, which does not understand those MySQL-specific SQL commands.
DB2 has also a freeware version, it is really worth to take a look for: http://www-306.ibm.com/software/data/db2/express
