2d ago · 5 min read · I started learning DevOps in January with zero cloud background. This week I deployed a production-ready full-stack bookstore to the internet. Three containers. Two isolated networks. A MySQL database
Join discussion
2d ago · 5 min read · Originally published at recca0120.github.io JOIN two tables on a nullable column and the rows disappear. Insert two NULLs into a UNIQUE column and neither insert fails. Both problems share the same root: SQL defines NULL as unknown, and unknown is ne...
Join discussion6d ago · 36 min read · TLDR: ACID is four orthogonal guarantees that every SQL transaction must provide. Atomicity says all-or-nothing: PostgreSQL implements it via WAL rollback; MySQL InnoDB via undo logs. Consistency says constraints always hold: the database rejects any...
Join discussion
Apr 14 · 6 min read · When working with MySQL or any other relational database, performance optimization is often associated with identifying and fixing "slow queries." These are queries that take too long to execute, typi
NNaif commented
Apr 8 · 9 min read · MySQL drives a huge range of applications, from lightweight projects to enterprise systems. As data and traffic scale, relying on reactive fixes – digging into logs or adjusting settings after slowdow
Join discussion
Apr 5 · 33 min read · A data engineering team at a fintech company built what they believed was a robust Change Data Capture pipeline: three source databases (PostgreSQL, MongoDB, and Cassandra), Debezium connectors wired to Kafka, and a downstream data warehouse receivin...
Join discussion
