If you like something that is widely used try SQLite http://www.sqlite.org/mostdeployed.html instead of MySQLzhaeon wrote:On the flipside, MySQL has marketshare.
SQLite is not a universal solution (don't use it for gigabytes+ of data), but if you need to quickly deploy a medium size data-driven website or use a local SQL file store, its performance and ease of use are difficult to beat - It also has native support by PHP 5 and Python. Downsides of SQLite are no GRANT/REVOKE (but would you use it on a simple web site?), VIEWS are not directly updateable (but can be done with triggers), triggers must be FOR EACH ROW, No FOREIGN KEYS (use triggers). You can probably tell that I am a fan Probably because I use C and Python.
You are right about Informix, I was involved in a large deployment on the MIPS platform in the 1980s - It was one of the most horrid jobs I have ever been given.