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
Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Categories

%d bloggers like this: