Deepak PantSystem design interviewAcing the system design interview need right set of knowledge , a mindset shift and knowing the basics of2 min read·Jan 18, 2024----
Deepak PantWhy and when Distributed Systems are used ?Distributed systems emerged from the need to scale computation and storage for large-scale data processing.4 min read·Jan 18, 2024----
Deepak PantMy experience with timescaledb CompressionI took ~28 Million data points of stock price data and put it in postgres.2 min read·Mar 6, 2021--1--1
Deepak PantSummary of experience in writing trading app storage layerSystem setup. Windows 10 Home (host) + VM (Virtualbox 6.2) running ubuntu 20. 20 GB RAM and a I5 processor 12 threads. Both windows and VM…5 min read·Mar 5, 2021----
Deepak PantSetting up PostgreSQL + timescaledb (extension)This blog capture my efforts and lessons learned during the migration of stock trading data from sqlite3 → Postgres + timescaledb extension2 min read·Mar 5, 2021----
Deepak PantDesigning TwitterThink of 5 most important features a product have Just list them3 min read·Jan 26, 2020----
Deepak PantDesigning Online Game (System Design)It is crutial to recognize that multiplayer online game need synchronization of their states across various players with the following…4 min read·Jan 24, 2020----