Need advice about Database..?

Question

The back-end would have around 25-50 tables, and some of them needs to hold scanned images (JPEG, TIFF, BMP etc).

I am in a situation, where I need more inputs to decide which database to choose from the following:

FireBird / SQLLite / H2 / any other, please suggest

One could guess from the above is, these database are free/low-cost setup.

TIA

Answer 1

Hi



Use MySQL and PHP they're open source and probably one of the best know and support. You can't store images in a database only there location.



I don't know much about the databases you mention, but be careful about learning a language that isn't widely recognized or support.



Hope that helps.

Andy

Web Design Devon

http://www.fourdegreeswest.co.uk/

Answer 2

You need a mature database management system (DBMS) to handle BLOBs (binary large objects) columns.



Take a look at MySQL (Community Edition runs 80% of the web), Oracle (not open source, but they have a free version), or PostgreSQL.



MySQL is my favorite. All of these will run on any operating system. MySQL and PostgreSQL are often already installed on cheap shared hosting plans.

Answer 3

I agree with MySQL. I don't agree with storing BLOBs in the database. Store the file path and name in the database and the image file on the disk - it's much more efficient.