Three Ways to Set Up CDC from Postgres to ClickHouse
You cannot run analytical queries on the same Postgres primary that serves your application without paying for it in CPU and connections. A read repli…
Latest News
⚑ Report a ProblemTech news from the best sources
All topics
- игры
AI
Gear
News
Tech
agents
ai
api
architecture
automation
beginners
career
claude
devchallenge
devops
javascript
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
react
security
showdev
tutorial
typescript
webdev
YouTube Backend: How Database & Data Management Actually Work
If you've ever wondered what happens the moment you hit "upload" on a YouTube video, you're asking one of the most interesting questions in modern sof…
BSON and OSON: documents are designed to be nested, not flat
I like vendors benchmarks as they are often good illustrations of worst practice. Rather than focusing on real implementation trade-offs, they pick an…
Benchmarking time-series databases for ecommerce infrastructure monitoring
Time-series database performance under ecommerce load: real benchmark results Your monitoring stack becomes your worst enemy during traffic spikes if …
Day 19 - Relational Database Service
Latest applications rely heavily on databases. Whether you're building: E-commerce platforms Banking applications SaaS products Mobile apps Enterprise…
SQL Pattern Series #1: The Presence Pattern
Thinking in terms of existence instead of lists SQL Pattern Series #1 of 21 A collection of practical SQL patterns that help developers recognize comm…
DuckDB 1.5.3 Iceberg updates, PostgreSQL TDE extension & AI index tuning
DuckDB 1.5.3 Iceberg updates, PostgreSQL TDE extension & AI index tuning Today's Highlights Today's highlights include DuckDB's enhanced Iceberg i…
$exists and non-sparse indexes in MongoDB and in other DocumentDB
In SQL databases, NULL represents an unknown value — not the absence of a value. When a value is simply non-applicable for a given entity, the correct…
SurrealDB 3.x by the numbers
Author: Tobie Morgan Hitchcock One engine, multi-workloads, full durability. You can explore the full results, methodology, and per-database breakdown…
One Practical SQL Trigger Example You Can Actually Use
One UPDATE statement. One trigger. One automatic audit record — no extra code required. Triggers are one of those SQL features that can seem a little …
How a 2.8ms Network Delta Nearly Broke Our 7 TB Oracle to Amazon RDS Migration
Cross-posted from my infrastructure postmortem series at pavanbhatia.hashnode.dev . At 1:40 AM on Sunday, our 7 TB Oracle-to-Amazon RDS migration was …
MongoDB `$facet` Explained: One Query, Multiple Results
Sometimes one MongoDB aggregation needs to return more than one result. For example, from the same payments collection, you may want revenue by paymen…
A-Z Database Glossary
A comprehensive reference of database terms from A to Z written for beginners and anyone learning how data is stored, managed, and retrieved. Each ter…
Most Teams Don't Move to Amazon RDS for Performance
You’ve decided to move your applications from on-premises to AWS and are looking at the cloud services that best meet your needs. When moving an appli…
The "Audit Trail" Pattern: Architecture for Immutable Sustainability Data
In standard CRUD apps, if a user updates their profile name, you overwrite the database row. No big deal. But in CSRD (Corporate Sustainability Report…
SQL Injection Protection in Flask: A Practical Guide. Part 5 of e2ee chat series
The Problem Most developers think their database is safe. It's not. SQL injection attacks can destroy everything. What is SQL Injection? If you write …
Oracle ORA-00022 오류 원인과 해결 방법 완벽 가이드
ORA-00022 invalid session ID 는? ORA-00022 에러는 Oracle 데이터베이스에서 세션 ID가 유효하지 않을 때 발생하는 오류입니다. 주로 DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION , ALTER SYSTEM KILL…
The hidden cost of cloud GPU training: egress, idle time, and lock-in
The GPU hourly rate is the number everyone compares. It is also the number that tells you the least about what a training run actually costs. The stic…
Before SQL, We Had to Tell Computers Everything. Then One Idea Changed That Forever.
Here's something most SQL tutorials skip entirely: SQL wasn't just a new syntax. It was a new way of thinking . Before SQL existed, most systems were …
How to Prepare for a Technical Data Engineer Interview
Data Engineering landscape in Kenya Data engineering has become one of the most important technical roles in modern organizations. Every company wants…
I had to restore an entire database just to recover one deleted row
Let me vent for a second, because last week broke me a little. I've been doing SRE / database ops for about 5 years, and I keep relearning the same pa…
I Built a Lightweight Python RAG Orchestrator That Works with SQLite, PGVector and Qdrant
Most RAG frameworks today assume: a huge dependency graph mandatory LLM orchestration opinionated pipelines complex configuration But many real-world …
Redis — The Engine of Instant Gratification
Let’s get one thing straight right out of the gate: if you hang around engineering forums, you’ve probably seen the dramatic headlines or Reddit threa…
Beyond the Cheat Sheets: How to Actually Reason About Partitioning VS Sharding in System Design Interview
You are mid-way through a system design interview, confidently whiteboarding your database architecture. You casually drop the word: “…and then we’ll …
How to Optimize MongoDB on Bare Metal Servers: SRE Playbook
The explosion of artificial intelligence retrieval applications has transformed the way enterprises deploy document databases. However, transitioning …
🚀 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…
How to Correctly Read a PostgreSQL EXPLAIN ANALYZE Output
A slow query lands in your lap. You run EXPLAIN ANALYZE and get back a wall of indented text that looks like someone fed a query plan through a blende…
1 Minute SQL Tips with WoWSQL — 28 May 2026
1 Minute PostgreSQL Tip: Indexing JSONB for Faster Lookups 🚀 Ever struggled with slow queries on your JSONB columns? You're not alone. Many developers…
Read-Modify-Write isolation in NoSQL: the distributed-lock hell.
In part 1 , the single-document case was easy. In part 2 , two documents brought Write Skew, and we saw that even a native ACID transaction — snapshot…
Why Does Using an ORM Decrease Database Performance? An Experience...
Why Does Using an ORM Decrease Database Performance? While trying to optimize the shipping module in a production ERP, I noticed that database queries…