DrProject 3.0 Schema
April 25, 2008 – 11:50 amOne of the ways I can tell that DrProject is getting better is that its database schema is getting cleaner. I’ve posted earlier versions from December 2006 (which was 1.0 something or other), Version 1.2 from early 2007, and the first Elixir-based version from July 2007. Today’s is much tidier, and I even know what most of the fields are for:

We have to add two or three new tables this summer, but I hope we’ll be able to keep things at least this clean.
3 Responses to “DrProject 3.0 Schema”
That’s good news! I have a concern, though. Will 3.0 still support SQLite? I’m runnung DrProject 1.2 on a server that already has MySQL, and for my small team I’d prefer not to run yet another SQL server. Also, for replicating the database to a testing machine, SQLite installation is soooo easy.
It would be a real pity if DrProject drops SQLite support, moreover now that is part of standard Python 2.5.
Anyway, we are very pleased with your work.
Thanks so much,
Ferran
By Ferran Jorba on May 7, 2008
Yes, we’ll continue to support SQLite—we use it for development.
By Greg Wilson on May 7, 2008
Thank you again! We’ll wait for 3.0 (the first stable release after 1.2, as I understand it).
By Ferran Jorba on May 7, 2008