Database Optimization: Six Strategies That Cut Query Time by 60%
Profiling, indexes, ORM refactors, materialized views, connection pooling, and cache — a practical PostgreSQL and MySQL guide.
Yevhen Stuzhuk - Personal Portfolio
I am a Senior Software Engineer
← All posts
Tag
Databases
All blog posts with this tag.
A PostgreSQL-backed job queue in Go: the Swig example
Jobs table, row locks, JSONB payloads, LISTEN/NOTIFY, and goroutine workers — no Redis if Postgres is already in your stack.
SQLite Is All You Need for Durable Workflows
DBOS and Obelisk: local SQLite plus Litestream to S3 for workflow state; Postgres when you need HA and shared scale.
Semantic layer between storage and BI: why AI analytics needs it
Metrics Layer / Headless BI as an executable contract for metrics—not a data catalog—and why LLMs should not invent SQL on their own.
Python vector databases: what breaks after the notebook
Chroma, Pinecone, Qdrant, Weaviate—not QPS charts, but packaging, API stability, and the path from dev to production.
Shrinking a 3 GB SQLite dictionary to ~10 MB with an FST
The tsk case: finite state transducers in Rust, shared Finnish suffixes, and why SQLite FTS was only a stepping stone.