Blog

Articles and updates

clickhouse (17)mongodb (7)postgresql (3)cloud (2)couchbase (2)kafka (2)mariadb (2)mysql (2)

MongoDB Indexes: How to Actually Read and Fix Slow Queries

MongoDB indexes are powerful, but they are not magic. explain tells you the truth — as long as you know where to look. The biggest mistake is seeing IXSCAN and moving on thinking "okay, it is fast." The real story is hidden in those three numbers and in timeReadingMicros.

Can SayinAugust 14, 202611 min read

mongodb

Running MongoDB Atlas Vector Search From Your Application Code – Python, JavaScript & Ruby

The mechanical part of vector search is genuinely small: declare an index, put $vectorSearch first in a pipeline, keep filters inside the stage, and project the score so you can see what the engine is thinking.

Can SayinAugust 10, 20268 min read

cloud mongodb

A Tiny, Zero-Dependency Benchmark for ClickHouse

The whole thing is a single Python file with no dependencies — just the standard library. No clickhouse-driver, no requests, no pip install. It talks to ClickHouse over the HTTP interface (port 8123), so you can drop it on any box that can reach the server and run it.

Can SayinJuly 1, 202611 min read

clickhouse

Your Code Has Branches. Why Doesn’t Your Data? ClickHouse Branching Tool

A branch is a full, writable, isolated copy of a production table — created in seconds, without duplicating the data.

Can SayinJune 27, 20265 min read

clickhouse

Nobody Buys a Database for the Audit Trail. Then the Auditor Shows Up.

Auditing ClickHouse ! That's the layer BlancoByte ClickHouse Console is built around. Here's what it actually looks like.

Can SayinJune 25, 20266 min read

clickhouse

ClickHouse Is Blazing Fast — Until It Isn’t. Here’s How to See It Coming.

ClickHouse exposes all of that — through dozens of system tables. It just doesn't give you a single place to actually see it.That gap is exactly what BlancoByte ClickHouse Console was built to close.

Can SayinJune 24, 20266 min read

clickhouse