Abhishek Bhardwaj’s Post

I recently started digging deep into PostgreSQL Internals and am compiling my learnings on YouTube; I covered some super interesting nuances like 1. how it creates a new process every time a client connects to it 2. how it parses the query to create a parse tree 3. how joins are executed by the database 4. how it creates query execution plans databases are fascinating and are one of my favorite topics to deep dive into. give it a watch if you find databases interesting. youtu.be/o7qLKfILuD8 ps: There are 180+ deep tech real engineering videos on my channel covering system design, microservices, research paper dissections, database internals, and engineering. all no-fluff; ⚡ Admissions for my System Design June 2024 cohort are open, if you are an experienced engineer looking to build a rock-solid intuition to design any and every system, check out arpitbhayani.me/course #AsliEngineering #SystemDesign #DatabaseInternals

🌟 Achievement Unlocked! 🌟 I'm thrilled to share that I've completed an extensive Database Engineering course as part of my preparation for a Backend Engineering role. 📚💻 This course covered a comprehensive range of topics, including:  - ACID Properties  - Database Internals and Indexing  - B-Tree vs B+Tree  - Database Partitioning and Sharding  - Concurrency Control  - Replication and System Design  - Database Engines and Cursors  - SQL vs NoSQL Architecture  - Database Security  - Homomorphic Encryption  - WAL, Redo, and Undo logs  - Data Storage mechanisms  - Hash Tables and Consistent Hashing  - Indexing comparisons in PostgreSQL vs MySQL  - Understanding Write Amplification in SSDs These modules have equipped me with deep insights and practical skills crucial for backend development and optimizing database performance. I'm excited to apply these skills in real-world projects, driving efficiency and innovation. #DatabaseEngineering #BackendDevelopment #ContinuousLearning #TechSkills #Achievement #Database #ComputerScience #Udemy

Hello, LinkedIn connections!🚀 I'm excited to share my recent journey in learning System Design under the guidance of my mentor, Gladden Rumao. I've explored foundational principles like DRY, KISS, SOLID and CUPID, and delved into key topics such as the Singleton Pattern, Client-Server Model, Network Protocols, Latency, Caching, Databases (SQL and NoSQL), Monolithic,Microservices, Hashing, Monitoring, Logging, and many more. This deep dive into system design has been incredibly enriching and fascinating, broadening my understanding and skills. I look forward to applying these insights to real-world projects and continuing my growth in this field. #SystemDesign #LearningJourney #SoftwareEngineering #ProfessionalDevelopment

A bit latepost, I'm curious how does log aggregating process work with ELK stack. So I tried to explore and this is the writing about my exploration to discover how does logs in server can be exported to Elasticsearch with the help of ELK stack. https://lnkd.in/gMFmYNmz

If you ever need to review distributed computing concepts and you don't have much time, I highly recommend the "Distributed Systems for fun and profit: online book: https://lnkd.in/dzVjxBXe If you happen to actually have the time to dive deeper, one of the most comprehensive textbooks is "Designing data intensive applications": https://lnkd.in/djscEDG3 Finally, if you prefer watching lectures, I also encourage you to watch MIT's 6.824 series: https://lnkd.in/dy3FPudS #distributedsystems #distributedcomputing #systemdesign

The learning journey at Datacamp continues.

https://lnkd.in/e9Msu8ts Very few things are as nice as seeing someone who is passionate about a topic (and knows a lot about it) explaining it. Throughout my career, I was presented with multiple challenges in the domain of distributed systems (Kafka, yeah you, I'm looking at you) and my life would have been easier if I had this book before. If you're interested in things like distributed data management or communication patterns, this is an invaluable resource!

My master's student, Michael Issac Assad, presented his thesis presentation today "Service-Level Byzantine and Exception Fault Injection in Databases within Microservice Applications" this morning. Truly excellent work, Michael was responsible for the major push behind Filibuster 2.0 and adding support for injecting faults for applications that use Cassandra, Redis, Postgres, Cockroach, and DynamoDB. These faults are not just limited to connection errors, timeouts, inducing latency, but he also observes values from good executions to generate faulty executions to provoke error handlers associated with (de)serialization code and RPC fallbacks that are executed when caches fail. This work extends the existing system so you can inject GRPC faults at the time time you are injecting faults in, for example, Redis calls. This was highly technical work that required handling database drivers with async APIs, how to instrument drivers properly, and how to integrate them into the Filibuster framework. It improves on the state of the art (e.g., Gremlin ALFI, Chaos Mesh, Litmus) by allowing applications that use databases to be tested for correctness, exhaustively given a set of faults specified by the developer. Congratulations, Michael! 🎉 #ChaosEngineering #Microservices

How to Execute Postgres Stored procedures in Spark | Hands on Guid Exercise Labs https://lnkd.in/eGWUxFrs Video guides https://lnkd.in/eyGPJXga