RTRohan Tiwariinrabindranath-tiwari.com.np·Mar 22 · 2 min readUnderstanding HTTP MIME TypesThe internet hosts many kinds of resources, so each resource needs a label to tell clients how to handle it. MIME (Multipurpose Internet Mail Extensions) was originally developed to solve problems mov00
RTRohan Tiwariinrabindranath-tiwari.com.np·Mar 20 · 6 min readCentralized Cache Key Management In RedisIn modern web applications, efficient data access is essential for performance and user experience. Redis, a blazing-fast in-memory store used for caching, messaging, and short-lived persistence, depe00
RTRohan Tiwariinrabindranath-tiwari.com.np·Feb 19 · 6 min readPostgres Multi Version Concurrency Control - MVCCIn 1986 database researcher named Michael Stonebraker was working on a problem that has plauged databases since their inception. how do you let many people read and write to the data simultaneously wi00
RTRohan Tiwariinrabindranath-tiwari.com.np·Feb 19 · 4 min readPostgreSQL TOAST Storage ModelsThe main problem TOAST solves is fundamental : postgres pages are of 8kb, and tuple must fit within that page. so what happens if you try to insert 1MB of text field ? Without toast you would get an error: "Row too big". With toast PostgreSQL handles...00
RTRohan Tiwariinrabindranath-tiwari.com.np·Feb 18 · 5 min readTuple LayoutWhen you insert a new row into a table, postgreSQL creates a tuple, a contiguous chunk of memory bytes that contains both system metadata and your actual data. A tuple starts with a 23 byte header. Every single tuple in every table has this same head...00
