Don't parse SQL to make a query runner read-only
Say you're building a tool that lets people run ad-hoc SQL against a database, and you want a read-only by default mode — a safety net so a fat-finger…
Programming
⚑ Report a ProblemLatest Programming news from Tech News
All topics
AI
agents
ai
api
architecture
automation
aws
beginners
career
claude
database
devchallenge
devops
javascript
learning
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
react
rust
security
showdev
tutorial
typescript
webdev
pg-smart-search: Путь от 8 секунд до 40 мс — Часть 2. Масштабирование до миллиона строк и производственная архитектура
Привет, Хабр! В первой части мы разобрали архитектуру pg-smart-search изнутри: параллельный Promise.race , механизм Zombie Prevention через AbortSigna…
Scaling to a Billion Rows: PostgreSQL Partitioning in Laravel 🐘
The 100-Million Row Wall In enterprise B2B SaaS platforms at Smart Tech Devs, tracking historical data is a compliance requirement. Tables like audit_…
PostgreSQL on Kubernetes — Complete Setup Guide with CloudNativePG
Originally published on DevToolHub , where I keep this guide updated as CloudNativePG evolves. Running PostgreSQL in Kubernetes used to be a bad idea.…
CloudNativePG: Running PostgreSQL in Kubernetes Without the Pain
A CloudNativePG cluster that sits in Setting up primary forever, with zero error events on the Cluster resource and a perfectly healthy operator, is o…
MVCC без VACUUM: что нам дал UNDO-лог, какую цену мы заплатили и зачем нам 5 механизмов сборки мусора
Новая статья из цикла про нашу OLTP-СУБД на Rust. С самого начала мы выбрали MVCC на UNDO-логе вместо версионирования в heap, как в PostgreSQL. И года…
Your Postgres will die at 50 concurrent users, not 50,000. Here is the connection pooling guide nobody handed you.
Disclosure: I am a senior backend tech lead in Paris and I run HostingGuru, a small European PaaS for solo founders and small teams. This article ment…
Postgres or ClickHouse? Row vs Column Storage, and When Each Wins
PostgreSQL and ClickHouse both speak SQL, both call themselves databases, and both will happily store your data. That surface similarity gets teams in…
I turned the psql commands I keep forgetting into buttons
You know the command exists. You've run it a dozen times. But every single time you need to see what's actually running on your database, you end up t…
Stop Running 5 Databases: PostgreSQL Does It All in 2026
How a 35-year-old open-source database became the default choice for relational storage, full-text search, vector AI workloads, geospatial queries, an…
Optimistic concurrency is the whole design: event sourcing on Aurora DSQL
Quorum is an incident command plane built on Amazon Aurora DSQL. The failover story lives in another post. This one is about a narrower question that …
The Deep Mechanics of Online Bulk Deletion in PostgreSQL
MVCC, WAL, vacuum, and replication slots under sustained delete load - and how to delete billions of rows without your database noticing Most "how to …
Three PostgreSQL Master/Replica Discovery Problems — and How to Solve Them
When an application starts using multiple PostgreSQL hosts, the headaches begin: you need to dynamically find the master after a failover, pick a repl…
PostgreSQL 22P01 Error: Causes and Solutions Complete Guide
PostgreSQL Error 22P01: Floating Point Exception PostgreSQL error code 22P01 is raised when a floating-point operation produces an exceptional result …
I Built a Search Engine That Understands Meaning — in ~150 Lines, Zero API Keys
Type "animals that live in the ocean" into a normal search box and it hunts for the words animals , live , ocean . An article titled "Blue whale" that…
"Confluence Docs Lie. Tie Your Documentation to Code Instead."
Every team has that Confluence page. The one that was carefully written to explain what the service does, what the API looks like, what each DB column…
Why my first RAG layer starts in Postgres, not in a standalone vector database
When people say they are "adding RAG" to a workflow, the conversation often jumps too quickly to infrastructure choices. Should this use a vector data…
How I built a flash-sale engine that can't oversell
I created this piece of content for the purpose of entering the H0: Hack the Zero Stack hackathon. #H0Hackathon The problem (that's harder than it sou…
The Multi-Tenant Fortress: Bank-Grade Data Isolation in PostgreSQL
In a multi-tenant B2B platform, data leakage is an extinction-level event. If Property A logs into your dashboard and accidentally sees the guest data…
Indexes: Quickstart Using PostgreSQL (15 sec read)
Let's consider a table user . When we execute a query to find Emily , we are actually going through each record , looking whether the name column equa…
Не давайте ИИ-агенту прямой доступ к базе. Как я проектировал безопасный контур действий на FastAPI и PostgreSQL
Последнее время я всё чаще встречаю одну и ту же мысль: бизнес никогда не даст ИИ‑агенту доступ к базе клиентов, заявкам, платежам, CRM…
Designing an Expiring-Points System on an RDBMS (with Benchmarks)
This is an English rewrite of an article I originally published in Japanese. I've run the design on PostgreSQL 17 in Docker and folded the measured nu…
Linux Fundamentals for Data Engineering
Introduction As a data engineer, most of your work will happen on Linux servers. Whether you are managing databases, running data pipelines, or proces…
PostgreSQL 22003 Error: Causes and Solutions Complete Guide
PostgreSQL Error 22003: Numeric Value Out of Range PostgreSQL error code 22003 ( numeric_value_out_of_range ) is raised when you attempt to store or c…
Parse, Don’t Guess
Three days before going open source, I deleted my parser's smartest feature. 333 lines. 6 functions. 12 passing tests. All green, all clever, all gone…
How to see running queries in Postgres and kill them
Something is slow. Maybe a page takes forever to load, maybe a migration is hanging, maybe your Supabase dashboard just spins. You suspect a query is …
PostgreSQL 2200G Error: Causes and Solutions Complete Guide
PostgreSQL Error 2200G: Most Specific Type Mismatch PostgreSQL error code 2200G ( most_specific_type_mismatch ) is a SQL-standard data exception that …
Advice Needed: Best Way to Build a Hospital Medicine Tracking App as a Beginner
Hi Dev Community! I am a CS graduate. I want to build an industry-standard full-stack app for my portfolio on my own. Recently, I have learned the bas…
Defeating the OFFSET Penalty: Cursor Pagination in Laravel
The Hidden O(N) Pagination Trap When building data-heavy B2B SaaS platforms at Smart Tech Devs, rendering lists of invoices, logs, or user rosters is …
Build a Secure API with Rails 8 - Part-4: SSL, CSRF & Serialization
Hey folks 👋 Welcome back. In Part 3 we built all five auth endpoints, added Rack-Attack rate limiting, hardened the HTTP headers with secure_headers ,…