RSS LJ

June 27, 2007

Dear phpBB: ()

by fluffy at 7:35 PM
In the future, please put primary keys on all your tables. It makes it a lot easier to restore and convert the database without having to worry about duplicate rows.

Love,
fluffy

Comments

#9413 06/28/2007 08:56 am
ugh, it drives me nuts when people don't put primary keys in all tables, regardless of how simple it is or how a primary key can be inferred from a combination of columns. A straight pk column is just so much easier to deal with.
#9414 06/28/2007 09:08 am
Of course the most obnoxious one of these is the phpbb_search_wordmatch table which is the end result of a really badly-implemented search function.

Not that anything in phpBB is implemented particularly well.

I really need to get around to writing my own embeddable commenting engine.