Posted by: horizonguy | July 5, 2008

Best practice checklist – Database Principles

Database Principles:

  • Make use of and enforce conventions and standards
  • Perform database testing (Database persistence code)
  • Make database scripts ( clearing out test data, common queries )
  • Make sure to backup database schema for each release (text file)
  • Make schema upgrade scripts (rather than manual updates)
  • Make it easy to store reference data
  • Make use of ORM libraries where appropriate ( NHibernate.NET, IBatis )
  • Make sure to apply indexes where appropriate
  • Make use of database paging if neccessary
  • Make sure to use functions
  • Make sure to prevent sql injection

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s


%d bloggers like this: