[xwiki-devs] Which database engine should be the default for 3.0?

Hi devs, The default standalone distribution currently uses HSQLDB 1.8 as the database engine, wrapped by Hibernate 3.2.6 as the ORM engine. Both are a bit deprecated. One option is to use the 2.0 version of HSQLDB, which brings lots of improvements. Unfortunately, a direct replacement of the old jar with the new one doesn't work. It complains when trying to open an existing database, and even with a new database it complains when using boolean fields in queries, which means all searchDocuments calls will fail because of the "doc.hidden <> true" condition. Another option is to use H2, which is a reimplementation of HSQLDB, originally intended to be version 2 of HSQLDB. On their http://www.h2database.com/html/features.html#comparison feature comparison, H2 seems to have more meta-features than HSQLDB2. A third option which was already partially implemented is to use Derby. Personally I prefer H2, which seems to be more maintained than the others, with new releases every 2-3 weeks, and also has better performance and more features. -- Sergiu Dumitriu http://purl.org/net/sergiu/