Thursday, November 30, 2006

Apache Derby up and running

So we've got a Derby database up and running now, finally something to play with. Derby was quite interresting, especially since the syntax seemed real "old school" ( SQL-92). Now the work is concentrated on building a starter DAO so that plugins can communicate with the database through this DAO.

Plugins connect to the database using DAO, which in order uses the Derby EmbeddedDriver to connect to the database. This way the database system will be abstracted from the rest of the system.

Derby seems really smooth to work with, as it also generates a very small footprint. I've spent four weeks now reading Derby documentation, so I hope we won't have to throw it out the door in favour for another one :P

No comments: