6 docs tagged with "sql"

A reproducible PostgreSQL benchmark comparing an integer array with a GIN index against a conventional bridge table.

Part of my go/vue/postgres project template, this function applies...

A personal reflection on how PostgreSQL became my go-to database — from early days dabbling with various db engines all the way to building Postgres from source and stepping through it with GDB.

The Timeline of a Backend Dev Who Grew Up in SQL

Coming from an MS SQL (BI/DE) background, I instinctively default to...

Discover various SQL tricks to enhance query efficiency, including using '1=1' in WHERE clauses and techniques for identifying duplicates.