Search results
6 results
Article
Product Engineering
★ Featured
SQL Query Optimisation — Indexes, Execution Plans, and N+1
Practical techniques for making slow queries fast.
Article
Data & Platform
Trino (formerly PrestoSQL) — Federated SQL Across Data Sources
Architecture, connectors, query federation, and performance tuning.
Article
Data & Platform
Migrating from MySQL to PostgreSQL
Schema translation, data migration, and common incompatibilities to address.
Article
Data & Platform
Change Data Capture (CDC) — Debezium and Log-Based CDC
How CDC works, why it beats polling, and how to implement it with Debezium.
Article
Product Engineering
Implementing Search — From Basic SQL to Elasticsearch
Full-text search progression from LIKE queries to dedicated search engines.
Article
Product Engineering
Database Connection Patterns in PHP
PDO, prepared statements, connection pooling, and transaction management.