Deepak PantSystem design interviewAcing the system design interview need right set of knowledge , a mindset shift and knowing the basics ofJan 18Jan 18
Deepak PantWhy and when Distributed Systems are used ?Distributed systems emerged from the need to scale computation and storage for large-scale data processing.Jan 18Jan 18
Deepak PantMy experience with timescaledb CompressionI took ~28 Million data points of stock price data and put it in postgres.Mar 6, 20211Mar 6, 20211
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…Mar 5, 2021Mar 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 extensionMar 5, 2021Mar 5, 2021
Deepak PantDesigning TwitterThink of 5 most important features a product have Just list themJan 26, 2020Jan 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…Jan 24, 2020Jan 24, 2020