Postgres

PG Phriday: Redefining Postgres High Availability

What is High Availability to Postgres? I’ve staked my career on the answer to that question since I first presented an HA stack to Postgres Open in 2012, and I still don’t feel like there’s an acceptable answer. No matter how the HA techniques have advanced since then, there’s always been a nagging suspicion in my mind that something is missing. But I’m here to say that a bit of research has uncovered an approach that many different Postgres cloud vendors appear to be converging upon.

PG Phriday: Getting It Sorted

When it comes to reordering the items in a list, databases have long had a kind of Faustian Bargain to accomplish the task. Nobody really liked any of the more common solutions, least of all the poor database tasked with serving up the inevitable resulting hack.

Postgres is no different in this regard. Consider a list_item table like this, demonstrating five items in a to-do list:

Free Agentry

Potential layoffs are a persistent fixture in some industries, like some kind of Sword of Damocles looming over them in perpetuity. With the recent advances in AI and the weak economy battering industries of all description, the rate is only accelerating. Perhaps anecdotally, Tech is one of the worst affected in the current climate, with nearly 50k laid off already in 2024 alone, and over 250k in 2023 according to the Layoff Tracker.

Wondering What TODO

I’ve been thinking of adding a Kanban board to my site for a more advanced TODO list. So far I’ve looked at: Kanboard - Interesting and right now the main contender. It’s fast, easy to set up, and can use Postgres. It’s somewhat ugly, and the existing themes are few and far-between. It’s also PHP, which isn’t winning it any points. Also, every single theme breaks the code syntax highlighting in the hover tool-tip of the Board view.

PG Phriday: Community Edition

Postgres is one of those database engines that carves out a niche and garners adherents with various levels of religious zeal. The community, while relatively small when compared to that of something like MongoDB, is helpful almost to a fault. Members from the freshest minted newb to the most battle tested veteran will often trip over themselves to answer questions found in the various dedicated forums, mailing lists, and chat rooms.