Articles tagged with: Development

Bulk Queries in MySQL vs PostgreSQL

Summary: In MySQL, it's more efficient to split large queries into smaller chunks to avoid lock contention and potential deadlocks, unlike other RDBMS where bulk queries are preferred.


Always send emails asynchronously

Summary: Advice against sending emails synchronously, suggesting instead to use asynchronous methods, such as enqueuing tasks or using event-based architecture, to improve efficiency and reduce complexity.


How different opensource storage systems replicate data

Summary: How various open-source storage systems, including MongoDB, MySQL, PostgreSQL, Redis, and Cassandra, handle data replication, concluding that most use a log of commands propagated to replicas.


Book Review: Two Scoops of Django 1.11

Summary: Review of the book 'Two Scoops of Django 1.11' by Daniel Greenfeld and Audrey Roy Greenfeld.


Self-Modifying code and avoiding conditionals

Summary: About the use of self-modifying code in the 1980s, and how it was used to overcome memory and CPU restrictions. It also explores modern alternatives to avoid conditionals.