Sunday, May 6, 2007

Database Choice

After looking at Firebird, MySQL, MSSQL Server Express 2005, and a few others, I've concluded that the best default database for Employee Scheduling Pro is SQLite. I found a SQLite ADO.NET Provider, which seems to work quite well. SQLite will provide a very light-weight default database, but still allow for multiple users. Employee Scheduling Pro will still be designed in such a way that adding support for additional databases will not be a huge chore. SQLite will decrease the distribution size, memory footprint, installation complexity, etc. versus the alternatives mentioned above, yet still provide all the functionality needed for Employee Scheduling Pro, both present and future.

No comments: