Как ораклист сертификацию по Postgres сдавал
Однажды я захотел узнать что-то новое по СУБД Postgres и структурировать уже имеющиеся знания. На помощь пришла программа сертификации. Рассказываю ка…
Latest Testing & QA news from Tech News
Однажды я захотел узнать что-то новое по СУБД Postgres и структурировать уже имеющиеся знания. На помощь пришла программа сертификации. Рассказываю ка…
Originally published on DevToolHub , where I keep this guide updated as CloudNativePG evolves. Running PostgreSQL in Kubernetes used to be a bad idea.…
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…
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…
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…
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…
Планы выполнения формируются на основе команды, статистики, собранной по объектам и параметрам конфигурации. Основной способ сбора статистики - команд…
Планы выполнения формируются на основе команды, статистики, собранной по объектам и параметрам конфигурации. Основной способ сбора статистики - команд…
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 While developing a production ERP, when I saw query times suddenly double, I realized that…
Database index selection, in my nearly 20 years of experience, has often been a critical topic that is either overlooked or misunderstood. Many develo…
Introduction: Bridging the Gap Between Postgres and JavaScript with ParadeDB The ParadeDB NPM package emerges as a targeted solution to a growing pain…
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…
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 Connection pooling sounds boring until your Saa…
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…
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 TL;DR: Composite primary keys, partial unique indexes, cr…
TypeScript passed it clean. The code reviewer approved it. It shipped to production. Three months later, a penetration tester sent a report. The vulne…
Originally published at spectredev.xyz . Cross-posted here for the Dev.to community. Database sharding explained without the hype. Learn what it actua…
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 …
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…
TL;DR Built a PostgreSQL extension that creates UUIDs looking like random v4 but containing hidden timestamps. Result: 50% smaller indexes with perfec…
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? While managing a production ERP system, I encountered an unexpected situation wh…
Testing FastAPI + SQLAlchemy with Real PostgreSQL Fixtures: No More Mocking Misery I spent three months debugging why a query worked in tests but fail…
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…
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…
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 …
TL;DR I run a small dev-shop. Every product I ship needs an LLM call somewhere — content generation, security analysis, classification, summaries. The…