When we spec'd out the Web2project Desktop Client, the Vision was to build a simple client that would retrieve a user's list of tasks, allow them to log time against any or all of them, and update the server with the time and comments. While the vast majority of the time the user would be online, there are times - either by choice or necessity - when the user may not be able to connect to their server. Therefore, we needed a simple local datastore.

While I could attempt to have mysql installed locally, that's a huge dependency that will scare away non-developers. Alternatively, some file-based XML monstrousity might work but then I'd have the fun of dealing with XML. Without a doubt, SQLite was the only logical choice, especially once I found out Flex has support built in.

If you've only worked with a "normal" database engine like MySQL or SQL Server, then you'll quickly realize that SQLite is whole other beast..

For those of you just tuning into the WordPress/Thesis battle, here is the current - as of 19 July 2010 - state of things:

As of 29 June 2010, web2project v2.0 is officially released! You can download it from SourceForge now.

Although this release had lots of bug fixes, the primary focus was on a few specific new features and major pieces of functionality. You can read the full v2.0 Release Notes, but in my opinion, the six most important items are:

A Project Importer update is available for web2project from the downloads page.

Version 4.0 marks a major update in the Project Importer module. While many changes are minor, there are some significant updates to performance and general reliability:

Release Notes:

As of 01 April 2010, v1.3 of web2project is live.

This release was focused almost entirely on bug fixing and preparation for the coming v2.0 release in June. Since the v1.2.2 release in January: