Understanding SQL

Posted by ads' corner on Sunday, 2008-01-13
Posted in [Externes][Other-Dbs][Software][Sql]

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.

Categories: [Externes] [Other-Dbs] [Software] [Sql]
Tags: [Php] [Sql]