/PostgreSQL

Best PostgreSQL GUIs in 2021

- Angel D'az tl;dr: Our team of developers researched the best PostgreSQL GUIs in 2021 so you don’t have to. We'll break down the best GUIs for querying, visualizing and analyzing your Postgres data, as well as remotely accessing and navigating database servers.

featured in #263

Psycopg 3.0 Released

- Daniele Varrazzo tl;dr: Leverages more modern PostgreSQL and Python features, such as asynchronous support, server-side parameters binding, prepared statements, and more.

featured in #260

Herding Elephants: Lessons Learned From Sharding Postgres At Notion

- Garrett Fidalgo tl;dr: The inflection point was when the Postgres VACUUM process began to stall consistently, preventing the database from reclaiming disk space. Garrett discusses 3 key decisions the team made and lessons learned: (1) shard earlier. (2) Aim for a zero-downtime migration. (3) Introduce a combined primary key instead of a separate partition key.

featured in #258

PostgreSQL 14 Released!

tl;dr: "This latest release adds to PostgreSQL's trend on improving high performance and distributed data workloads, with advances in connection concurrency, high-write workloads, query parallelism and logical replication."

featured in #256

Postgres 14: It's The Little Things

- Craig Kerstiens tl;dr: "A lot of years Postgres will have some big pillar or theme to the release." However, Craig wants to highlight how the little things are improving too highlighting improvements in JSON syntax, read only roles, psgl and query pipelining.

featured in #254

In Praise Of PostgreSQL

- Drew DeVault tl;dr: "Postgres stands today as one of the most significant pillars of profound achievement in free software, alongside the likes of Linux and Firefox. PostgreSQL has taken a complex problem and solved it to such an effective degree that all of its competitors are essentially obsolete, perhaps with the exception of SQLite."

featured in #243

Better JSON In Postgres With PostgreSQL 14

- Craig Kerstiens tl;dr: "Postgres 14 makes JSON even more user friendly than before. While I wouldn't recommend simply using the subscript format everywhere in your application due to it not always leveraging indexes, for casual querying it proves to be a big win."

featured in #233

PostgreSQL 13 Released!

tl;dr: "Includes significant improvements to its indexing and lookup system that benefit large databases, including space savings and performance gains for indexes, faster response times for queries that use aggregates or partitions, better query planning when using enhanced statistics, and more."

featured in #207

Building A Recommendation Engine Inside Postgres With Python And Pandas

- Craig Kerstiens tl;dr: Craig guides us through his experimental recommendation engine - with "SciPy, NumPy and Pandas there is a lot of interesting potential here."

featured in #200

How To Implement Search By Color When All You Have Is A Good Coffee

- Mike Alche tl;dr: How search was implemented on a Next.JS app using PostgreSQL and third party library called "color thief."

featured in #188