Skip to content

Understanding SQL

Just have to port a phpkit database to something else. It seems, the phpkit ppl did not really understand what SQL is for.

The 'phpkit_config' table in this case contains 255(!) columns and a lot of this columns seems to be for extensions.

This is a very good example where you should use normalization: you don't add more and more columns to one table but you have a key/value table and for new entries you add a new key with a value. No need to change the table at all.

  • Twitter
  • Bookmark Understanding SQL at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg Understanding SQL
  • Bloglines Understanding SQL
  • Technorati Understanding SQL
  • Fark this: Understanding SQL
  • Bookmark Understanding SQL at YahooMyWeb
  • Bookmark Understanding SQL at Furl.net
  • Bookmark Understanding SQL at reddit.com
  • Bookmark Understanding SQL at blinklist.com
  • Bookmark Understanding SQL at Spurl.net
  • Bookmark Understanding SQL at Simpy.com
  • Bookmark Understanding SQL at blogmarks
  • Bookmark Understanding SQL with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

Trackbacks

No Trackbacks

Comments

Display comments as Linear | Threaded

No comments

Add Comment

Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.
To leave a comment you must approve it via e-mail, which will be sent to your address after submission.
Form options