Articles tagged with: Databases

Book Review: System Design Interview

Summary: A review of the book 'System Design Interview - An Insider's Guide' by Alex Xu.


Type inference complex scenarios - A BigQuery example

Summary: A bug encountered while using Google BigQuery, specifically with type inference in complex scenarios involving arrays of structs. Plus a solution, and insights on BigQuery's behavior.


ACID, BASE and CALM

Summary: The article discusses the ACID, BASE, and CALM acronyms related to database transactions, their implications for distributed systems, and the challenges of implementing them, particularly CALM, in imperative languages.


Course Review: Data Analytics on Google Cloud (Pluralsight)

Summary: A review of the course 'Data Analytics on Google Cloud' by Pluralsight.


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.