I learned something new today about Postgres!
Laurenz Albe’s blog post on how you can break foreign keys in Postgres includes the tidbit that BEFORE triggers that return NULL can stop enforcement of foreign keys.
While I knew system triggers enforced referential integrity in Postgres, I had not considered the consequences of BEFORE triggers with that feature.
Learn more from Laurenz Albe here:
One valid use case for stored procedures in operational systems can be to reduce round trips to the database for some transactions. In (some) databases, it can also mean running compiled code close to the database.
Both are more efficient in some cases, but it can also be more difficult to debug stored procedures than normal code.
Quoted database object names are like getting dysentery on the Oregon Trail
... It’s not gonna end well.
Bob Seger released the song "Old Time Rock & Roll" on his 1978 album Stranger in Town. Over the last year, several articles have highlighted a resurgence in analog computing — a mode of computing that fell out of favor around the same time.
The Colossus, created 80 years ago for code-breaking during World War II, holds the distinction of being the first digital computer.
Adrien Nayrat has an excellent article that delves into what many have forgotten about the DBA (Database Administrator) role.
If you would rather not feed OpenAI or Google AI models after midnight …
Here is a good summary of how to use a robots.txt file to limit what OpenAI and Google will ingest from your website for training data.
Kudos to the authors for finding a valid use of the word gauche.
Read more here:
Voyager 1 and Voyager 2 were launched in 1977 and have been traveling farther from home each year.
Recently, work has been undertaken to update their software to correct bugs in the attitude articulation and control system (AACS) software for both.
A common question from people moving from other databases to Postgres is how can I learn more?
One of the great things about the Postgres community is the excellent documentation!
While I don’t have any affiliation, Postgres Weekly is a great way to learn something new and keep tabs on Postgres news.