We have the opportunity to expand upon the database options found in SQL Fiddle. Which database (including version) would be the most useful for the community? Some thoughts I've had:
- DB/2 Express-C (1911)
- Firebird (680)
- Ingres (34)
- MariaDB (52)
- Drizzle (4)
- Derby (550)
- HyperSQL (622)
- H2 (414)
- Informix Innovator-C (602)
Other's ideas: Teradata (215), GemStone (7), Greenplum (30), Sybase (1062), Sap MaxDB (?).
Numbers next to each option is the number of questions related to each on StackOverflow, as of 9/12/2012
Also, consider older versions of current offerings, such as SQL Server 2005 Express, Oracle 10g XE, MySQL 4, etc...
The constraints on offerings is that there has to be a no-cost edition available for production use. Also, there has to be a JDBC driver. I would guess that most RDBMS that are worth much can create new databases and users with SQL over a JDBC connection, but I may as well mention that I need to be able to do that as well. There must also be reasonably strong permission mechanisms available, so that users can be granted permission to a specific database (without exposing operating system functions as well).
Good transaction support would be ideal, otherwise I might have to resort to limiting the query functionality to SELECT statements (just like MySQL is currently limited). Also, some means of getting the execution plan for each query would be very nice.
I was thinking that, to answer this question, people could throw out the one option they'd most like to see implemented. Then, other people could vote it up if they agree. This would allow me to see the list of databases the community would most like to see, in order of preference. I should mention that I'm probably going to be proceeding with DB/2 regardless of this poll, so probably just take that as a given and consider the others. Thanks!