Home

Notes on server-side and client-side database cursors, their differences, pros and cons, and how to use them with PostgreSQL and Python.

An overview of TypeScript, its benefits, and how to get started with installation and modern JavaScript features.

A detailed exploration of database engines like MyISAM, InnoDB, Aria, LevelDB, RocksDB, SQLite, and more, covering their features, use cases, and how to switch engines in MySQL.

Exploring two database designs for a URL shortener, their trade-offs, and scaling strategies to balance speed, security, and scalability.

Exploring the challenges of designing a scalable Twitter-like system, covering authentication, database design, message queues, load balancing, and handling user follows.

Explores database replication types (Master-Slave vs. Multi-Master), synchronous vs. asynchronous modes, and a hands-on Postgres 13 demo.

Learn why using OFFSET for pagination harms performance and discover efficient alternatives like keyset pagination.

A deep dive into database sharding, consistent hashing, and their practical implementation using Postgres and NodeJS.