title: Grails + sqlite
body: <p>Is there any way to use SQLite as a database storage for my Grails app?</p>
  
  <p>If I use a SQLite JDBC driver (<a href="http://www.zentus.com/sqlitejdbc/" rel="nofollow noreferrer">http://www.zentus.com/sqlitejdbc/</a>), my app fails to start with "Could not determine Hibernate dialect for database name [SQLite]"</p>
  
  <p>The only workaround I found was <a href="http://d.hatena.ne.jp/torutk/20090711/p3" rel="nofollow noreferrer">http://d.hatena.ne.jp/torutk/20090711/p3</a> (it's in Japanese, have it <a href="http://translate.google.com/translate?u=http%3A//d.hatena.ne.jp/torutk/20090711/p3&amp;hl=en&amp;langpair=auto|en&amp;tbb=1&amp;ie=EUC-JP" rel="nofollow noreferrer">google translated</a> if you want), but it does not make any help.</p>
  
  <p>Or, is the idea of using SQLite for web apps so terrible that nobody uses it?:)</p>
  
  <p>EDIT: Yes, I know, the default Grails HSQLDB support works just fine, but my web app is a part of a bigger system which uses solely SQLite, so we would prefer end up supporting only one database instead of both HSQLDB and SQLite.</p>