Last Updated Columns With Postgres
Read OriginalThis technical article details a method for automatically tracking record creation and last update timestamps in PostgreSQL. It explains why using application code can cause issues and contrasts PostgreSQL's approach with MySQL's ON UPDATE clause. The core solution demonstrates how to use `updated_at = DEFAULT` in UPDATE statements as a cleaner alternative to defining triggers for every table.
0 comments
Comments
No comments yet
Be the first to share your thoughts!
Browser Extension
Get instant access to AllDevBlogs from your browser
Top of the Week
1
Introducing GPT-5.1 for developers
Simon Willison
•
6 votes
2
A simple explanation of the big idea behind public key cryptography
Richard Gendal Brown
•
1 votes
3
Google Antigravity Exfiltrates Data
Simon Willison
•
1 votes
4
5
Fix “This video format is not supported” on YouTube TV
David Walsh
•
1 votes
6
Tooltip Components Should Not Exist
TkDodo Dominik Dorfmeister
•
1 votes
7
llm-anthropic 0.22
Simon Willison
•
1 votes
8
GPT-5.1 Instant and GPT-5.1 Thinking System Card Addendum
Simon Willison
•
1 votes
9
Nano Banana can be prompt engineered for extremely nuanced AI image generation
Simon Willison
•
1 votes