My two cents about software development on the web


Lessons from the API giants

 Any company looking to utilize an API to expose its services – and every company should be looking at this – can stand on the shoulders of these giants:

  • Use your API as a new channel for your business like Salesforce
  • Align your API with your core value proposition like Amazon
  • Create a thriving community of developers that use your API like Twitter
  • Keep improving your API’s usability like Google

source: 5 lessons from API giants like Twitter and Google


Ten Common Database Design Mistakes

If database design is done right, then the development, deployment and subsequent performance in production will give little trouble. A well-designed database ‘just works’. There are a small number of mistakes in database design that causes subsequent misery to developers, managewrs, and DBAs alike. Here are the ten worst mistakes.

  1. Poor design/planning
  2. Ignoring normalization
  3. Poor naming standards
  4. Lack of documentation
  5. One table to hold all domain values
  6. Using identity/guid columns as your only key
  7. Not using SQL facilities to protect data integrity
  8. Not using stored procedures to access data
  9. Trying to build generic objects
  10. Lack of testing

source: Ten Common Database Design Mistakes