// writing
Notes and write-ups
everything tagged databases
LaundryAlert - never forget your laundry again
Forgetful habits regarding completed laundry cycles led to the development of a custom monitoring system that triggers push notifications on mobile devices. By combining a light-sensitive sensor on a washing machine with a control board, a solution was created to detect status changes and alert users remotely. This project combines basic electronics with custom software to solve a frequent household annoyance.
Database locks, lost updates and idempotency
Distributed systems frequently face challenges with concurrency and duplicate requests that can lead to data loss or incorrect application states. This post explores practical strategies for maintaining data integrity, including leveraging HTTP headers for optimistic concurrency control and idempotency. It also examines how database-level transactions and row-level locking mechanisms can prevent race conditions in complex workflows.
Keeping track of database changes and when it can be useful
This article explores the concept of database replication and how it can be utilized to synchronize data between systems or feed external services. It covers the mechanics of write-ahead logging and logical decoding, which allow tracked changes to be exported in usable formats. The post also highlights necessary configuration steps for managed environments and potential pitfalls to monitor when implementing these techniques.