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
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
Database Connection Patterns in PHP
PDO, prepared statements, connection pooling, and transaction management.
Article
Data & Platform
Migrating from MySQL to PostgreSQL
Schema translation, data migration, and common incompatibilities to address.
Article
Product Engineering
Implementing Search — From Basic SQL to Elasticsearch
Full-text search progression from LIKE queries to dedicated search engines.