Check for missing indexes during development using constraint programming - pganalyze/lint

so many "Our Database Was Fucked and Here’s How We Unfucked It" posts should really be "How We Saved $5,000 in Consulting Time by Spending $500,000 in Developer Time" -- heed this warning https://about.sourcegraph.com/blog/introducing-migrator-service

New edition of SQL standard is out. It is just 1715 pages, should not be hard to follow 😄 https://t.co/eMuYwVEpX3 #sql

In this series of posts, we'll be discussing some "unique" behaviors of the Snowflake analytical base, which you won't find in the documentation. ☝🏽

Let's start with virtual (computed/calculated/derived/generated) columns. In the documentation, virtual columns…

This post is about building an FPGA based networked key-value-store in the functional hardware description language Clash. I’ll describe my FPGA-tailored hashtable design, the testing framework I built for it, and its performance and resource usage.

NOT NULL constraints are a ubiquitous tool for upholding data integrity. However, their performance benefits are less obvious. In this post we'll examine a few of these optimizations that transform query plans involving foreign key relationships.

I'm excited to announce that @neondatabase crossed 100,000 databases under management. Up from under 9,000 on January 1st this year. This growth wouldn't be possible without our partners @vercel, @Replit, @HasuraHQ and over a dozen more and counting. 1/N

A Language Server for Postgres. Contribute to supabase-community/postgres-language-server development by creating an account on GitHub.

Цель Запустить Doom на PostgreSQL и познакомимся с основами написания нативных расширений для PostgreSQL. Попробовать Исходный код тут: https://github.com/DreamNik/pg_doom . Для удобства весь процесс...

Supavisor is a scalable, cloud-native Postgres connection pooler. We connected a million clients to it to see how it performs.