Daily edition · PostgreSQL
TILens turns technical updates into a focused daily brief: official releases, trusted reporting, and practitioner analysis, deduplicated and organized by topic.
9 articles · 3 sources ·
Top topics: PostgreSQL · JavaScript · AI
In nearly every conversation we have about data sovereignty, the first word out of someone’s mouth is residency. Where does the data physically sit? That’s the question executives are trained to ask, and it’s the wrong…
If your custom app needs to send orders or invoices to an ERP, don't call the ERP API from inside your request handler. Write each change to an outbox table in the same Postgres transaction as the business data. Then…
In the previous two posts you could see how to manage storage for create and drop and also to work with transactions. In this post you’ll learn how to handle TRUNCATE, which replaces the arena of a table with a new one.…
AwideLabs Tech Column: How we took PolarDB from a promising open-source project to production-ready Awide Polar.
Every durable database change in PolarDB passes through one place before it is safe: the write-ahead log. A replica is just a machine that stores that log and replays it. But how if a cluster need a pure copy of the WAL?
Every time PostgreSQL decides whether a row is visible to your query, it asks the same question: was the transaction that wrote this row already committed when my snapshot was taken?
If your code reads an API key through a variable starting with VITE_, NEXT_PUBLIC_ or REACT_APP_, that key is in your public JavaScript and anyone can copy it. An environment variable keeps it out of your Git repo, not…
Protect your disk from orphaned temporary files after a backend crash. (I consult on PostgreSQL through PGX Inc..)
You add "Sign in with Google" to your app, click the button, and Google shows one of these instead of the account picker: Error 400: redirect_uri_mismatch Access blocked: This app's request is invalid Unable to exchange…
