Databases: SQLite, PostgreSQL, and More
-
Robert Haas ☛ Robert Haas: PostgreSQL Hacking Workshop - November 2024
Next month, I'll be hosting a discussion of a talk by Andy Pavlo, given for his Intro to Database Systems course at CMU. The title of the talk is "Memory & Disk I/O Management and the video link is https://www.youtube.com/watch?v=aoewwZwVmv4. As usual, we have will have three sessions, and you can sign up to participate in one of them using this form.
-
PostgreSQL ☛ Prague PostgreSQL Developer Day 2025 / Call for Papers & Sponsors
Prague PostgreSQL Developer Day 2025 (P2D2 2025) will be held on January 28-29 in Prague, Czech Republic. The conference focuses on topics for PostgreSQL users and developers.
-
Evan Hahn ☛ How does SQLite's "changes" API handle no-op UPDATEs?
SQLite has an API to count the number of rows modified by an INSERT, UPDATE, or DELETE. For example, if you delete 10 rows, SELECT changes() will return 10.
I recently had a question: what happens if you do an UPDATE on some rows that don’t actually change?