Why PostgreSQL EXPLAIN ANALYZE Can Mislead You — and What to Use Instead
EXPLAIN ANALYZE is the standard tool for understanding how PostgreSQL runs a query. It shows the chosen plan, estimated and actual row counts, and exe…
Open Source
⚑ Report a ProblemLatest Open Source news from Tech News
All topics
AI
agents
ai
api
architecture
automation
aws
beginners
career
claude
database
devchallenge
devops
discuss
javascript
linux
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
rust
security
showdev
tutorial
typescript
webdev
How to Connect Power BI to Aiven PostgreSQL Using ODBC (Step-by-Step Guide)
Introduction I tried connecting Power BI directly to a PostgreSQL database on Aiven and run into this frustrating error: The remote certificate is inv…
PostgreSQL Row Level Security: A Complete Guide
Your application code knows which tenant owns which row. Your ORM always filters by WHERE tenant_id = $1 . Your team has reviewed the queries and they…
Deploy to PostgreSQL with drm-cli + Liquibase: A Step-by-Step Guide
Handling Failures and Retries Deployments fail. Network blips, permission issues, a bad changeset that passes review and breaks in production — it hap…
SQL Window Functions and CTEs
You can do quite a lot with some of the most popular SQL queries such as SELECT, WHERE, and JOIN. But there exists some question that you cannot answe…
Indexing Strategies for Faster Database Queries
TL;DR Indexes = direct lookups — milliseconds vs full table scans (seconds). B-tree for most queries — Supports = , < , > , BETWEEN , LIKE 'pref…
Mastering the SQL Analytical Toolkit
As a budding data professional, I recently completed an intensive SQL Week 2 Assignment that pushed me from basic queries into more powerful territory…
Location as the Anchor: Mapping Species, Geology, UFOs, and Bigfoot to 105,000 Coordinates
Part 2 of 5. Part 1 covered the RAM crashes and data ingestion nightmare. This part is about what happens after the data is in the database — and why …
Soft-deleting Postgres rows without losing the URL slug
Six lines of code that let you release a unique-constrained slug back into the namespace without dropping the constraint. I want soft-delete on my blo…
How I Used PostgreSQL to Diagnose an Ecommerce Revenue Decline
Ecommerce businesses rarely struggle because of one obvious problem. Revenue falls, and the first instinct is often to blame pricing, weak products, s…
ActiveForge - Active Record ORM
Table of Contents The Active Record Pattern Architecture Overview Entities — Record and IdentityRecord Field Types (TField System) DataConnection — Th…