SQL and Query Writing
Full-Text Search in Postgres Without Elasticsearch
Postgres tsvector and GIN indexes deliver full-text search power without external tools.
Daniel Kwiatkowski
Contributing Writer · · 12 min read
Saved Query — Page 2
JSON Query Patterns in Postgres With JSONB
Learn which Postgres JSON operators to use for fast queries and indexing.
Daniel Kwiatkowski
Writing Efficient Pagination Queries in Postgres
OFFSET pagination gets exponentially slower on large tables, while keyset pagination stays fast.
Daniel Kwiatkowski
Admin Panel Security Risks in Production Database Access
Overly broad database credentials put production data at risk through admin panels.
Priya Sundaram
Writing Safe UPDATE and DELETE Statements in Production
Learn the two-stage safety loop that prevents destructive SQL mistakes in production.
Priya Sundaram
Self-Hosting Metabase vs Using a Managed Admin Panel
Compliance laws and IT capacity, not cost alone, drive self-hosting decisions.
Marcus Oyelaran
Aggregation Patterns for Business Metrics in SQL
Learn seven SQL patterns that solve nearly every business metric question executives ask.
Daniel Kwiatkowski
Designing Internal Tools for Support Team Workflows
Building internal tools prevents support from becoming dependent on engineering.
Céleste Marchand