Datestamps, please.

Here is a tip for those aspiring web developers who think that they know it all after they have managed to create a ‘database-driven’ web application:

Always add a field to important tables that shows when specific items (or rows) were inserted or created. Call it date_created or something. At least it gives you a reference when something was created. Helps if you need to audit and verify data too.

To my surprise I saw that there’s no date/timestamp for WordPress’s *_links table. It has a ‘updated’ timestamp field, that gets updated each time you change the link. Which gets pretty unusable.

This entry was posted in SQL. Bookmark the permalink.