Как ораклист сертификацию по Postgres сдавал
Однажды я захотел узнать что-то новое по СУБД Postgres и структурировать уже имеющиеся знания. На помощь пришла программа сертификации. Рассказываю ка…
Testing & QA
⚑ Report a ProblemLatest Testing & QA news from Tech News
All topics
agents
ai
api
architecture
automation
aws
beginners
career
claude
cybersecurity
database
devchallenge
devops
discuss
javascript
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
security
showdev
softwareengineering
testing
tutorial
typescript
webdev
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…
"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…
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…
Build a URL shortener with Fitz: HTTP + Postgres + auth in 30 minutes
A step-by-step tutorial through Fitz. We start from fitz new , finish with a native binary running in Docker. No external dependencies. No pip install…
[Перевод] Как подсунуть PostgreSQL чужую статистику. Переносим планы выполнения из продакшн
Планы выполнения формируются на основе команды, статистики, собранной по объектам и параметрам конфигурации. Основной способ сбора статистики - команд…
[Перевод] Как подсунуть PostgreSQL чужую статистику. Переносим планы выполнения из продакшн
Планы выполнения формируются на основе команды, статистики, собранной по объектам и параметрам конфигурации. Основной способ сбора статистики - команд…
Building Hybrid Search with PostgreSQL, pgvector, and Citus
Search looks simple from the outside. A user types something like: short-range copper module and expects the system to return the right product, maybe…
Database Index Anatomy: Performance and Resource Management
Database Index Anatomy: Performance and Resource Management While developing a production ERP, when I saw query times suddenly double, I realized that…
How to Choose Database Indexes in 3 Steps
Database index selection, in my nearly 20 years of experience, has often been a critical topic that is either overlooked or misunderstood. Many develo…
ParadeDB NPM Package Seeks Feedback on Simplifying Postgres Integration with JavaScript via Drizzle ORM
Introduction: Bridging the Gap Between Postgres and JavaScript with ParadeDB The ParadeDB NPM package emerges as a targeted solution to a growing pain…
I got tired of writing the same history table boilerplate, so I built a Postgres extension
There's this problem I kept running into - first during my internship, then again on a freelance project I picked up afterward. Both of them used Post…
How I Cut 769 Database Queries With One Window Function
From Grafana to Real Performance Gains I noticed in the Grafana dashboard that GET /api/v1/dokter/public/jadwal-dokter was on average taking 1 second …
PostgreSQL Connection Pooling in FastAPI: PgBouncer vs. SQLAlchemy QueuePool vs. Render's Native Pools
PostgreSQL Connection Pooling in FastAPI: PgBouncer vs. SQLAlchemy QueuePool vs. Render's Native Pools Connection pooling sounds boring until your Saa…
Building LifeFast: A Solo Founder's Deep Dive into Fasting App Architecture
There's a specific kind of frustration that comes from using a health app that feels like it was built by engineers who've never actually used it. The…
I built DBeast: a PostgreSQL MCP server that gives AI assistants DBA-level tools
AI assistants can write SQL. But writing SQL is only a small part of working with a real database. Most database work is investigation: What tables ex…
Your Test Data Is Type-Correct and Still Invalid: 6 Postgres Schema Features Generators Skip
Your Test Data Is Type-Correct and Still Invalid: 6 Postgres Schema Features Generators Skip TL;DR: Composite primary keys, partial unique indexes, cr…
Three SQL Injection Patterns That Still Ship in Node.js — And the ESLint Rule That Catches Them
TypeScript passed it clean. The code reviewer approved it. It shipped to production. Three months later, a penetration tester sent a report. The vulne…
What Is Database Sharding — and When Does Your Startup Actually Need It
Originally published at spectredev.xyz . Cross-posted here for the Dev.to community. Database sharding explained without the hype. Learn what it actua…
Not All Open Source Is Equal: Choosing a PostgreSQL Operator for Kubernetes in 2026
Choosing an open source PostgreSQL operator for Kubernetes used to be a question about features and community size. In 2026, it has become a question …
How to set up PostgreSQL permissions for AI coding tools (Cursor, Claude, Copilot)
Most developers I talk to connect Cursor or Claude directly to their databases using a full admin connection string. Wether it's a local Docker databa…
🚀 I Built UUIDs That Look Random But Sort Like Timestamps (50% Smaller Indexes!)
TL;DR Built a PostgreSQL extension that creates UUIDs looking like random v4 but containing hidden timestamps. Result: 50% smaller indexes with perfec…
Stop Using UUIDs: Why B2B SaaS Needs ULIDs in Laravel 🐘
The Problem with Auto-Incrementing IDs When building a B2B SaaS platform at Smart Tech Devs, using standard auto-incrementing integers (1, 2, 3) for y…
PostgreSQL WAL Bloat: Why Automatic Management Is Often Insufficient?
PostgreSQL WAL Bloat: Why Automatic Management Is Often Insufficient? While managing a production ERP system, I encountered an unexpected situation wh…
Testing FastAPI + SQLAlchemy with Real PostgreSQL Fixtures: No More Mocking Misery
Testing FastAPI + SQLAlchemy with Real PostgreSQL Fixtures: No More Mocking Misery I spent three months debugging why a query worked in tests but fail…
Load PostgreSQL into Apache Iceberg with Sling
Introduction Apache Iceberg is the table format that turns a pile of Parquet files in object storage into something that behaves like a warehouse tabl…
Indexing Solana Programs in Rust: Notes From a Python Backend Engineer
TL;DR I built a small Solana program activity indexer in Rust to pressure-test the patterns I rely on every day in Python — cursor-based syncs, idempo…
Maintaining an Agent-Searchable Profile: Public Impressions, Semantic Tags, and Real-Time Refresh
AI agents are becoming a new interface not only for finding people, but also for maintaining the profile that other agents search. Instead of opening …
I built a $0 fault-tolerant AI pipeline (Groq 5 DeepSeek Vertex template)
TL;DR I run a small dev-shop. Every product I ship needs an LLM call somewhere — content generation, security analysis, classification, summaries. The…