Tag Archives: mysql
Why I don’t use enum columns in MySQL database design
I used to be a fan of ENUM columns in MySQL databases. They’re lighter-weight than explicit lookup tables and, I presumed, led to less expensive operations than foreign key checks on a lookup table. But I’ve changed my mind: Changes … Continue reading
Posted in Geek, Technologies
Tagged Databases, Enumerated type, Lookup table, mysql, SQL
Leave a comment
Stored Procedures: Good or Bad?
A project team rewriting one of our web products has made the decision to jump ship from SQL Server to the open-source MySQL database and, at the same time, to place a greater emphasis on the use of stored procedures. … Continue reading