Spent some time today going through the source code of PostgreSQL to understand its query parser ⚡ I compiled my learnings in a video along with a code walkthrough covering interesting internal details about what happens when a Postgres server receives a SQL query from the client, and how it parses the query to create the parse tree. give it a watch - youtu.be/m8PtOY3aWL0 ⚡ I keep writing and sharing my practical experience and learnings every day, so if you resonate then follow along. I keep it no fluff. youtube.com/c/ArpitBhayani #AsliEngineering #PostgreSQLInternals #DatabaseEngineering
Your posts are as always unique and at a different level. Kudos to you Arpit. You live up to your motto of "no fluff engineering".
Jayesh Tambe
8mo
Just watched Instagram's case study of DRF, uWSGI and solution using gc.set_threshold(0), atexit.register(os._exit,0) to get rid of GC and lower memory spike on process forking. That was good explanation. Not sure if I would have understood it as easily by simply reading their blog
Pavitra Gupta
8mo
Watched the video. Good explanation. The good thing about your video was that it gives the viewer a little confidence to open the open source github files.
Rajan Choudhary
8mo
Really good video Arpit Bhayani .thanks for it.
Amit Chaudhary
8mo
Always something new 😊
System Design for Beginners: https://arpitbhayani.me/sys-design System Design for Experienced: https://arpitbhayani.me/masterclass Redis Internals: https://arpitbhayani.me/redis-internals My knowledge base: https://arpitbhayani.me/knowledge-base Bookshelf: https://arpitbhayani.me/bookshelf Research Papers: https://arpitbhayani.me/papershelf