Knowledge Base

 Results for "MySQL"

Articles, FAQs, project case studies, and service deep-dives.

Main site

Search results

6 results
Article Product Engineering ★ Featured

SQL Query Optimisation — Indexes, Execution Plans, and N+1

Practical techniques for making slow queries fast.

SQL query optimisation indexes N+1 EXPLAIN
2 views Mar 30, 2026
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.

CDC change data capture Debezium Kafka WAL
3 views Mar 30, 2026
Article Data & Platform

Migrating from MySQL to PostgreSQL

Schema translation, data migration, and common incompatibilities to address.

MySQL PostgreSQL migration pgloader schema translation
3 views Mar 30, 2026
Article Product Engineering

Implementing Search — From Basic SQL to Elasticsearch

Full-text search progression from LIKE queries to dedicated search engines.

search full-text search Elasticsearch PostgreSQL vector search
3 views Mar 30, 2026
Article Product Engineering

Database Connection Patterns in PHP

PDO, prepared statements, connection pooling, and transaction management.

PHP PDO prepared statements transactions database
2 views Mar 30, 2026
Article Data & Platform

Trino (formerly PrestoSQL) — Federated SQL Across Data Sources

Architecture, connectors, query federation, and performance tuning.

Trino Presto federated query SQL Iceberg
2 views Mar 30, 2026