Rohit SharmaNov 6, 20224 min readThe story of Publisher/Subscriber pattern....Hello Folks, After a long time, we are back with another engineering topic: publisher/subscriber. So now the first question arises why do...
Rohit SharmaJul 17, 20224 min readUntold Story of Connection Pooling..!Hello Folks, After a long time, we are back with another DB concept: connection pooling! First, let's understand the meaning of...
rohit sharmaFeb 19, 202211 min readPostgreSQL Advanced QueriesHello Folks, Hope you all are doing well! After a long time, I m again back with one more interesting topic which is "Advanced Queries in...
Rohit SharmaJan 1, 20224 min readDatabase Cursors with a practical approachHello Folks, Hope you are doing well and wish you a very happy new year! Today I m here with another interesting topic which is "Database...
Rohit SharmaOct 17, 20217 min readDatabase Partitioning with practical approach! Hello Readers, Hope you all are doing well! Today I m here with another interesting topic in the database i.e.; Partitioning. What is...
Rohit SharmaOct 15, 20216 min readUnderstanding how database indexes work and how to use them efficiently !Hello Readers, Hope you are doing well! Today I m here with another interesting topic related to databases indexes. We all know like we...
Rohit SharmaSep 19, 20213 min readIs using OFFSET is good or bad in SQL query?Hello Readers, Hope you all are doing well! Today I m here with another topic. As we all backend developers very frequently use the OFFSET...
Rohit SharmaSep 18, 20217 min readHow Database stores Tables in HDD and SSD?Hello Readers, Hope you are all doing well! Today I m here with another interesting topic. As we all store data in the tables but how...
Rohit SharmaSep 11, 20219 min readIn-Depth Explanation about Indexing in Databases (B-Tree v/s B+-Tree with examples)Hello Readers, Hope you all are doing well! Today we are again here with the most common topic indexes you must use and read about this a...
Rohit SharmaSep 10, 20218 min readIsolation Levels(Read Committed, Repeatable Read, Serializable)Hello EveryOne, Hope you all are doing well! So today I m here with another interesting topic which is Isolation level but before jumping...
Rohit SharmaSep 6, 20213 min readMVCC (Multi Version Concurrency Control)Hello Readers, Hope you all are doing well! we are back with another interesting topic in the database which is MVCC. most of the backend...
Rohit SharmaSep 6, 20213 min readCompound Unique Indexes in DatabasesHello guys we are going to publish some technical knowledge related to backend engineering. We are also awaiting your response so that we...
