Sunday, January 30, 2011

Choosing your DB

A free one!

To begin developing an application its not important to pick the db; whats important is to make sure it doesn't matter. If you are working in well financed organization you would be able to buy good DBMS; DBMS concern should be to facilitate storing, backing up, recovering, secure access and such. These concerns are important; however does not matter as far as application development is concerned.

To build in anti corruption layer and decouple DB we require two things;

1. Bid "Goodbye!" to SQL programming; no more stored procedure for you.
2. Pick an ORM which publishes APIs capable of interacting with db the way your application need.
3. Any good ORM would let you switch our DB type; make sure yours does.

No comments:

Post a Comment