SQLite Support Complete in 0.9.32

SQLite is now completely support by DBvolution. Anything you can do with any other database, you can do with SQLite.

It was very surprising just how much work was required for SQLite. The developers claim it is the world's most installed database, yet it seems to be the least standard. Also, as far as I could tell, it has the worst JDBC support.

The large install base is due to the number of common applications that use SQLite as a storage system. Its major advantage is that it's easy to create a database programatically.

It does support a useful set of the SQL standards. Unfortunately that set is not large. What it lacks in native support it makes up for in User Defined Functions. However it was disappointing to have to go UDFs to implement what seemed like basic functions.

I feel bad at this point for grumbling about any open source project, I know full well how difficult it is, but I've also been working with other OS databases and they seem better. I recommend H2 for its speed and excellent standards support, and MySQL is well maintained and scalable.

On the upside, none of this really matters since I've completed the support. You can now use SQLite just like any other database and never notice its SQL quirks, limitations, or flaws.

I'm very pleased with the result and I hope you are too.