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 denoscription 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.

Pure Rust implementation of SQLite. Contribute to kawasin73/prsqlite development by creating an account on GitHub.

from bun's discord

importing a Rust function in TypeScript via Bun plugin (tr1ckydev)

Have you seen this legendary SQL iceberg meme? Let's talk about it while wearing our PostgreSQL hat!