Experimental Support for SQLite in 1.5.2

[Lukas Eder]

Apart from developers tightly coupling their Java code to their database, also mobile developers (e.g. Android, etc) are among the targetted audience for jOOQ. This is why I'm proud to announce, that jOOQ will start supporting the SQLite database as of version 1.5.2. SQLite support will be experimental at first, as SQLite's "type affinity concept" is not a good match yet with jOOQ. jOOQ expects types to be known at code-generation time, but those can change later on within the SQLite database. Also, SQLite is missing out on many SQL99 standard functions, such as POSITION(), and many others.

With SQLite being the 7th database supported by jOOQ, it becomes obvious that some jOOQ concepts must be re-engineered in version 1.6.0. The main goals will be:

• Closer coupling with underlying database by creating new OracleFactory, DB2Factory, etc classes
  https://sourceforge.net/apps/trac/jooq/ticket/178

• Provide DSL support for very advanced, vendor-specific concepts such as the Oracle analytic functions
  https://sourceforge.net/apps/trac/jooq/ticket/148

• Improve type system in jOOQ itself, allowing for more flexibility as seen in SQLite
  

Experience has to be gathered first, before

Cheers
Lukas

Read more about SQLite's type affinity concept:
http://www.sqlite.org/datatype3.html