The GeekNarrator

The GeekNarrator

By Kaivalya ApteTechnology
Download on the App Store

The GeekNarrator episodes

  • Hosted PostgreSQL on bare metal and uni kernel

    The GeekNarrator memberships can be joined here: https://www.youtube.com/channel/UC_mGuY4g0mggeUGM6V1osdA/joinMembership will get you access to member only videos, exclusive notes and monthly 1:1 with me. Here you can see all the member only videos: https://www.youtube.com/playlist?list=UUMO_mGuY4g0mggeUGM6V1osdA------------------------------------------------------------------------------------------------------------------------------------------------------------------About this episode: ------------------------------------------------------------------------------------------------------------------------------------------------------------------In this episode, we talk to Søren Schmidt, Co-Founder and CEO of Prisma, discussing the evolution of Prisma from a backend as a service to a popular ORM and now to Prisma Postgres. He shares insights into the challenges faced during this journey, the importance of user feedback, and the innovative architecture of Prisma Postgres, which leverages micro VMs for performance optimization. The conversation also touches on the complexities of managing data centers and the strategies employed to ensure a seamless user experience. In this conversation, Søren Schmidt discusses the details about Postgres snapshots, their impact on performance, and the mechanisms for fault tolerance. He explains how Pulse change data capture works and how Prisma Postgres simplifies database management for users. Chapters00:00 Introduction to Prisma and Its Evolution03:00 The Journey from ORM to Prisma Postgres06:00 Simplifying Database Management09:01 Understanding Prisma Postgres Architecture12:12 The Role of Accelerate in Query Routing14:51 Optimizing Query Processing with Micro VMs18:12 Maintaining Postgres Integrity in a Micro VM Environment21:07 User Experience and Community Feedback23:57 Challenges of Data Center Management27:09 Cold Starts and Performance Optimization34:30 Understanding Snapshots in Postgres38:55 Snapshot Mechanisms and Fault Tolerance44:09 Change Data Capture with Pulse55:07 Transitioning to Prisma Postgres58:45 Community and Getting Started with Prisma PostgresSome blogs worth checking out:https://www.prisma.io/blog/prisma-postgres-the-future-of-serverless-databaseshttps://www.prisma.io/blog/cloudflare-unikernels-and-bare-metal-life-of-a-prisma-postgres-queryhttps://www.prisma.io/blog/announcing-prisma-postgres-early-accessPrisma Postgres relies heavily on the Unikraft project. There is a good introductory talk here: https://www.youtube.com/watch?v=n4wOyAuNhl0And some very technical papers here: https://unikraft.org/community/papersThe best way to get started with Prisma Postgres is to go straight to https://www.prisma.io/ ------------------------------------------------------------------------------------------------------------------------------------------------------------------Like building real stuff?------------------------------------------------------------------------------------------------------------------------------------------------------------------Try out CodeCrafters and build amazing real world systems like Redis, Kafka, Sqlite. Use the link below to signup and get 40% off on paid subscription.https://app.codecrafters.io/join?via=geeknarrator------------Database internals series: https://youtu.be/yV_Zp0Mi3xsPopular playlists:Realtime streaming systems: https://www.youtube.com/playlist?list=PLL7QpTxsA4se-mAKKoVOs3VcaP71X_LA-Software Engineering: https://www.youtube.com/playlist?list=PLL7QpTxsA4sf6By03bot5BhKoMgxDUU17Distributed systems and databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4sfLDUnjBJXJGFhhz94jDd_dModern databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4scSeZAsCUXijtnfW5ARlrsN

    1 hr 1 min
  • eBPF and continuous profiling with Frederic

    The GeekNarrator memberships can be joined here: https://www.youtube.com/channel/UC_mGuY4g0mggeUGM6V1osdA/joinMembership will get you access to member only videos, exclusive notes and monthly 1:1 with me. Here you can see all the member only videos: https://www.youtube.com/playlist?list=UUMO_mGuY4g0mggeUGM6V1osdA------------------------------------------------------------------------------------------------------------------------------------------------------------------About this episode: ------------------------------------------------------------------------------------------------------------------------------------------------------------------In this episode, Kaivalya Apte and Frederic Branczyk talk about observability, focusing on continuous profiling and the role of eBPF. They discuss the evolution of profiling techniques, the importance of systematic data collection, and the challenges faced in maintaining low overhead while gathering detailed performance metrics.Frederic shares insights from his extensive experience with Prometheus and Kubernetes, emphasizing the transformative impact of continuous profiling on software performance optimization. This conversation delves into the intricacies of eBPF (Extended Berkeley Packet Filter) and its applications in profiling and performance analysis. The discussion covers the capabilities of eBPF in extending the kernel safely, the mechanisms of user space profiling, and the handling of process terminations. It also explores memory and network profiling techniques, the challenges of profiling in different programming environments, and the limitations of eBPF in certain use cases. The conversation concludes with valuable resources for those interested in learning more about eBPF and profiling techniques.Chapters:00:00 Introduction to Observability and Profiling01:17 Frederic's Background and Expertise02:11 The Importance of Continuous Profiling06:46 The Value of Continuous Profiling11:20 Understanding Profiling Data19:09 Data Structures and Performance in Profiling32:35 The Role of eBPF in Profiling42:48 Introduction to eBPF and Its Capabilities48:32 User Space Profiling and Memory Management51:39 Handling Process Termination and Agent Recovery55:27 Memory and Network Profiling Techniques01:01:33 Profiling in Different Programming Environments01:11:47 Use Cases and Limitations of eBPF in Profiling01:13:54 Resources for Learning eBPF and Profiling Techniques------------------------------------------------------------------------------------------------------------------------------------------------------------------Like building real stuff?------------------------------------------------------------------------------------------------------------------------------------------------------------------Try out CodeCrafters and build amazing real world systems like Redis, Kafka, Sqlite. Use the link below to signup and get 40% off on paid subscription.https://app.codecrafters.io/join?via=geeknarrator------------------------------------------------------------------------------------------------------------------------------------------------------------------Link to other playlists. LIKE, SHARE and SUBSCRIBE------------------------------------------------------------------------------------------------------------------------------------------------------------------Database internals series: https://youtu.be/yV_Zp0Mi3xsPopular playlists:Realtime streaming systems: https://www.youtube.com/playlist?list=PLL7QpTxsA4se-mAKKoVOs3VcaP71X_LA-Software Engineering: https://www.youtube.com/playlist?list=PLL7QpTxsA4sf6By03bot5BhKoMgxDUU17Distributed systems and databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4sfLDUnjBJXJGFhhz94jDd_dModern databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4scSeZAsCUXijtnfW5ARlrsNStay Curios! Keep Learning!

    1 hr 18 min
  • Patterns of Distributed Systems with Unmesh Joshi

    The GeekNarrator memberships can be joined here: https://www.youtube.com/channel/UC_mGuY4g0mggeUGM6V1osdA/joinMembership will get you access to member only videos, exclusive notes and monthly 1:1 with me. Here you can see all the member only videos: https://www.youtube.com/playlist?list=UUMO_mGuY4g0mggeUGM6V1osdA------------------------------------------------------------------------------------------------------------------------------------------------------------------About this episode: ------------------------------------------------------------------------------------------------------------------------------------------------------------------In this conversation, Unmesh Joshi discusses the patterns of distributed systems. He emphasizes the importance of understanding the context in which patterns are applied, the need to read code to grasp their implementation, and the common pitfalls that developers face when applying patterns without a clear understanding of the underlying problems. Chapters00:00 Introduction to Distributed Systems and Patterns05:39 Understanding Patterns in Distributed Systems19:23 Bridging Theory and Practice in Distributed Systems28:56 The Role of Developers in Understanding Patterns31:58 Understanding Patterns in Software Development40:58 The Human Aspect of Software Design44:37 Iterative Development and Real-World Applications49:03 The Future of Patterns in Cloud-Native Systems55:07 Common Misunderstandings of Distributed PatternsInteresting quotes:"Patterns capture wisdom of generations.""Reading code is the best way to understand.""Patterns help you see beyond abstractions.""Understanding patterns helps bridge the gap.""Expert generalists can operate across verticals.""There are no simple systems in the cloud era.""Patterns can add complexity if misunderstood.""Patterns are always useful within a context.""Design and development are human activities.""The deconstruction of databases is happening.""Paxos is the most misunderstood pattern."Unmesh Joshi :https://in.linkedin.com/in/unmesh-joshi-9487635Catalog of Patterns: https://martinfowler.com/articles/patterns-of-distributed-systems/I hope you liked the episode, if you did please like, share and subscribe. ------------------------------------------------------------------------------------------------------------------------------------------------------------------Like building real stuff?------------------------------------------------------------------------------------------------------------------------------------------------------------------Try out CodeCrafters and build amazing real world systems like Redis, Kafka, Sqlite. Use the link below to signup and get 40% off on paid subscription.https://app.codecrafters.io/join?via=geeknarrator------------------------------------------------------------------------------------------------------------------------------------------------------------------Link to other playlists. LIKE, SHARE and SUBSCRIBE------------------------------------------------------------------------------------------------------------------------------------------------------------------If you like this episode, please hit the like button and share it with your network. Also please subscribe if you haven't yet.Database internals series: https://youtu.be/yV_Zp0Mi3xsPopular playlists:Realtime streaming systems: https://www.youtube.com/playlist?list=PLL7QpTxsA4se-mAKKoVOs3VcaP71X_LA-Software Engineering: https://www.youtube.com/playlist?list=PLL7QpTxsA4sf6By03bot5BhKoMgxDUU17Distributed systems and databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4sfLDUnjBJXJGFhhz94jDd_dModern databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4scSeZAsCUXijtnfW5ARlrsNStay Curios! Keep Learning!#distributedsystems #patterns #softwarearchitecture #consensus #algorithms #coding #patterns #softwaredevelopment #ThoughtWorks #softwareengineering #cloud #computing #software

    59 min
  • AWS Aurora Distributed SQL internals with Marc Brooker

    The GeekNarrator memberships can be joined here: https://www.youtube.com/channel/UC_mGuY4g0mggeUGM6V1osdA/join

    Membership will get you access to member only videos, exclusive notes and monthly 1:1 with me.
    Here you can see all the member only videos: https://www.youtube.com/playlist?list=UUMO_mGuY4g0mggeUGM6V1osdA
    ------------------------------------------------------------------------------------------------------------------------------------------------------------------
    About this episode:
    ------------------------------------------------------------------------------------------------------------------------------------------------------------------
    In this episode of the Geek Narrator podcast, host Kaivalya Apte interviews Marc Brooker, a distinguished engineer at AWS, about Aurora D-SQL. They discuss Marc's journey at AWS, the evolution of Aurora D-SQL, and the customer-centric approach that led to its development.
    Marc explains the choice of PostgreSQL as the foundation for DSQL, the architecture of the database, and the importance of snapshot isolation and concurrency control. The conversation goes into the technical aspects of DSQL, including the write process and how atomicity is maintained, providing listeners with a comprehensive understanding of this innovative database solution. This conversation also goes deep into the intricacies of database design, focusing on fault tolerance, replication strategies, and the role of Firecracker VMs in enhancing scalability. Marc Brooker discusses the architecture of Aurora D-SQL, emphasizing the importance of transaction management, the challenges of active-active deployments, and the trade-offs involved in database design. The discussion also highlights various use cases for Aurora DSQL, including its suitability for micro-services and serverless architectures, while addressing scenarios where it may not be the best fit.
    Chapters
    00:00 Introduction to Aurora DSQL and Marc Brooker's Journey
    03:38 The Evolution of Aurora DSQL at AWS
    09:24 Customer-Centric Development and Technological Enablers
    12:50 Why PostgreSQL? The Choice Behind DSQL
    16:39 High-Level Architecture of DSQL
    22:07 Understanding Snapshot Isolation and Concurrency Control
    28:45 The Write Process and Atomicity in DSQL
    38:50 Designing Fault Tolerance in Databases
    47:38 Replication and Transaction Commit Strategies
    54:35 Active-Active Deployment and Fault Tolerance
    01:00:14 Role of Firecracker VM in Scalability
    01:09:27 Use Cases and Trade-offs of Aurora D-SQL
    Marc's Blog: https://brooker.co.za/blog/
    Marc on Aurora DSQL : https://brooker.co.za/blog/2024/12/03/aurora-dsql.html
    AWS's documentation on Aurora DSQL : https://aws.amazon.com/rds/aurora/dsql/features/
    ------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Like building real stuff?
    ------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Try out CodeCrafters and build amazing real world systems like Redis, Kafka, Sqlite. Use the link below to signup and get 40% off on paid subscription.
    https://app.codecrafters.io/join?via=geeknarrator
    ------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Link to other playlists. LIKE, SHARE and SUBSCRIBE
    ------------------------------------------------------------------------------------------------------------------------------------------------------------------
    If you like this episode, please hit the like button and share it with your network.
    Also please subscribe if you haven't yet.
    Database internals series: https://youtu.be/yV_Zp0Mi3xs
    Popular playlists:
    Realtime streaming systems: https://www.youtube.com/playlist?list=PLL7QpTxsA4se-mAKKoVOs3VcaP71X_LA-
    Software Engineering: https://www.youtube.com/playlist?list=PLL7QpTxsA4sf6By03bot5BhKoMgxDUU17
    Distributed systems and databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4sfLDUnjBJXJGFhhz94jDd_d
    Modern databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4scSeZAsCUXijtnfW5ARlrsN
    Stay Curios! Keep Learning!
    #sql #postgres #databasesystems #aws #awsdevelopers #spanner #google #cockroachdb #yugabytedb #cap #scalability #WAL #DistributedSystems #Cloud #aurora

    1 hr 15 min
  • Power of #Duckdb with Postgres: pg_duckdb

    The GeekNarrator memberships can be joined here: https://www.youtube.com/channel/UC_mGuY4g0mggeUGM6V1osdA/join

    Membership will get you access to member only videos, exclusive notes and monthly 1:1 with me.
    Here you can see all the member only videos: https://www.youtube.com/playlist?list=UUMO_mGuY4g0mggeUGM6V1osdA
    ------------------------------------------------------------------------------------------------------------------------------------------------------------------
    About this episode:
    ------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Hey folks - In this episode we have Jelte with us, who is the main contributor to the pg_duckdb project, which is a postgres extension to add the #duckdb power to our beloved #postgresql.
    We will try to understand how it works? Why is it needed and what's the future of pg_duckdb?
    If you love #Postgres or #Duckdb or just understanding #database internals then this episode will give you pretty solid insights into Postgres query processing, Duckdb analytics, Postgres extension ecosystem and so on.
    Basics:
    pg_duckdb is a Postgres extension that embeds DuckDB's columnar-vectorized analytics engine and features into Postgres. We recommend using pg_duckdb to build high performance analytics and data-intensive applications.
    Chapters:
    00:00 Introduction to PG-DuckDB
    03:40 Understanding the Integration of DuckDB with Postgres
    06:23 Architecture of PG-DuckDB: Query Processing Explained
    10:02 Configuring DuckDB for Analytics Queries
    15:37 Managing Workloads: Transactional vs. Analytical
    21:02 Observability and Debugging in DuckDB
    25:58 Data Deletion and GDPR Compliance
    30:46 Schema Management and Migration Challenges
    33:14 Managing Schema Changes in Databases
    35:21 Upgrading Database Extensions
    36:33 Enhancing Data Reading Methods
    38:33 Future Features and Improvements
    45:54 Use Cases for PGDuckDB
    50:03 Challenges in Building the Extension
    55:25 Getting Involved with PGDuckDB
    Important links:
    The duckdb discord server, which has a pg_duckdb channel inside it: https://discord.duckdb.org/
    repo: https://github.com/duckdb/pg_duckdb
    good-first-issue issues: https://github.com/duckdb/pg_duckdb/issues?q=sort%3Aupdated-desc+is%3Aissue+is%3Aopen+label%3A%22good+first+issue%22
    ------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Like building real stuff?
    ------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Try out CodeCrafters and build amazing real world systems like Redis, Kafka, Sqlite. Use the link below to signup and get 40% off on paid subscription.
    https://app.codecrafters.io/join?via=geeknarrator
    ------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Link to other playlists. LIKE, SHARE and SUBSCRIBE
    ------------------------------------------------------------------------------------------------------------------------------------------------------------------
    If you like this episode, please hit the like button and share it with your network.
    Also please subscribe if you haven't yet.
    Database internals series: https://youtu.be/yV_Zp0Mi3xs
    Popular playlists:
    Realtime streaming systems: https://www.youtube.com/playlist?list=PLL7QpTxsA4se-mAKKoVOs3VcaP71X_LA-
    Software Engineering: https://www.youtube.com/playlist?list=PLL7QpTxsA4sf6By03bot5BhKoMgxDUU17
    Distributed systems and databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4sfLDUnjBJXJGFhhz94jDd_d
    Modern databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4scSeZAsCUXijtnfW5ARlrsN
    Stay Curios! Keep Learning!
    #sql #postgres #databasesystems

    1 hr 1 min
  • DBOS internals - Build reliable backends 10x faster

    The GeekNarrator memberships can be joined here: https://www.youtube.com/channel/UC_mGuY4g0mggeUGM6V1osdA/join

    Membership will get you access to member only videos, exclusive notes and monthly 1:1 with me.
    Here you can see all the member only videos: https://www.youtube.com/playlist?list=UUMO_mGuY4g0mggeUGM6V1osdA
    ------------------------------------------------------------------------------------------------------------------------------------------------------------------
    About this episode:
    ------------------------------------------------------------------------------------------------------------------------------------------------------------------
    In this episode we are talking to Peter and Qian, co-founders of DBOS. The conversation covers the challenges of creating fault-tolerant applications, the architecture of DBOS, and how it addresses reliability at multiple layers.
    Chapters:
    00:00 Introduction to the Geeknerder Podcast
    00:29 Meet the Co-Founders of DBOSS
    01:25 The Core Problem: Building Reliable Systems
    02:05 How DBOSS Solves Reliability Issues
    04:29 Understanding DBOSS Architecture
    06:09 Deep Dive into DBOSS Library
    08:36 Postgres and State Management
    18:31 Handling Parallel Steps and Performance Concerns
    26:00 Observability and Version Control
    30:18 Running Multiple Code Versions
    30:58 Managing Workflow Versions
    32:03 Surgery on Workflow States
    33:15 Library Annotations and Durable Execution
    34:24 Migrating to the Cloud Version
    37:23 Handling Email Workflows
    42:41 Transactional Guarantees with Postgres
    48:44 Technical Challenges and Multi-Tenancy
    54:12 Real-World Use Cases and Benefits
    59:45 Conclusion and Final Thoughts
    Some important links:
    - Main website: https://www.dbos.dev/
    - DBOS docs: https://docs.dbos.dev/
    - Open-source DBOS Transact libraries:
    - Python: https://github.com/dbos-inc/dbos-transact-py
    - TypeScript: https://github.com/dbos-inc/dbos-transact-ts
    ------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Like building real stuff?
    ------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Try out CodeCrafters and build amazing real world systems like Redis, Kafka, Sqlite. Use the link below to signup and get 40% off on paid subscription.
    https://app.codecrafters.io/join?via=geeknarrator
    ------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Link to other playlists. LIKE, SHARE and SUBSCRIBE
    ------------------------------------------------------------------------------------------------------------------------------------------------------------------
    If you like this episode, please hit the like button and share it with your network.
    Also please subscribe if you haven't yet.
    Database internals series: https://youtu.be/yV_Zp0Mi3xs
    Popular playlists:
    Realtime streaming systems: https://www.youtube.com/playlist?list=PLL7QpTxsA4se-mAKKoVOs3VcaP71X_LA-
    Software Engineering: https://www.youtube.com/playlist?list=PLL7QpTxsA4sf6By03bot5BhKoMgxDUU17
    Distributed systems and databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4sfLDUnjBJXJGFhhz94jDd_d
    Modern databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4scSeZAsCUXijtnfW5ARlrsN
    Stay Curios! Keep Learning!

    1 hr 2 min
  • Database Trends and More with Peter Zaitsev

    Deep Dive into Databases with Peter Zaitsev | The GeekNarrator Podcast

    Join host Kaivalya Apte and special guest Peter Zaitsev from Percona on this episode of the Geeknerder Podcast. They discuss Peter's fascinating journey into the world of databases, founding Percona, and the evolution of open source database solutions. Topics include the rise of PostgreSQL, the comparison between MySQL and PostgreSQL, database observability, the impact of cloud and Kubernetes on database management, licensing changes in popular databases like Redis, and career advice for database administrators and developers. Stay tuned for insights on the future of databases, observability strategies, and the role of AI in database management.
    00:00 Introduction and Guest Welcome
    00:14 Peter's Journey into Databases
    04:15 The Rise of PostgreSQL vs MySQL
    18:17 Challenges in Managing Database Clusters
    24:36 Common Developer Mistakes with Databases
    30:59 MongoDB's Success and Future
    34:53 Redis and Licensing Changes
    37:07 Elastic's License Change and Its Impact
    38:25 Redis Fork and Industry Collaboration
    40:27 Kubernetes and Cloud-Native Databases
    47:47 Challenges in Database Upgrades and Migrations
    54:58 Load Testing and Observability
    01:09:02 Future of Database Administration and Development
    01:15:13 Conclusion and Final Thoughts
    Become a member of The GeekNarrator to get access to member only videos, notes and monthly 1:1 with me.
    Like building stuff? Try out CodeCrafters and build amazing real world systems like Redis, Kafka, Sqlite. Use the link below to signup and get 40% off on paid subscription.
    https://app.codecrafters.io/join?via=geeknarrator
    If you like this episode, please hit the like button and share it with your network.
    Also please subscribe if you haven't yet.
    Database internals series: https://youtu.be/yV_Zp0Mi3xs
    Popular playlists:
    Realtime streaming systems: https://www.youtube.com/playlist?list=PLL7QpTxsA4se-mAKKoVOs3VcaP71X_LA-
    Software Engineering: https://www.youtube.com/playlist?list=PLL7QpTxsA4sf6By03bot5BhKoMgxDUU17
    Distributed systems and databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4sfLDUnjBJXJGFhhz94jDd_d
    Modern databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4scSeZAsCUXijtnfW5ARlrsN
    Stay Curios! Keep Learning!

    1 hr 5 min
  • How would you design a database on Object Storage?

    Join Kaivalya Apte and Simon Hørup Eskildsen from Turbopuffer as they talk about the complexities of building a database on top of object storage. Discover the key challenges, the nuances of various storage formats, and the critical trade-offs involved.

    Learn from Simon's rich experience, from his time at Shopify to creating Turbopuffer. This episode covers everything—from approaches to write-ahead logs to multi-tenancy and object storage advancements. Perfect for database enthusiasts and those keen on first-principles thinking!
    00:00 Introduction
    00:17 Simon's Background and Journey to TurboBuffer
    02:42 Challenges in Database Scalability
    04:21 Experimenting with Vector Databases
    05:02 Cost Implications of Vector Databases
    05:52 Architectural Considerations for Search Workloads
    07:39 Building a Database on Object Storage
    16:14 Designing a Simple Database on Object Storage
    26:01 Handling Multiple Writers and Consistency
    31:26 Trade-offs in Write Operations
    32:36 Optimizing MySQL Write Performance
    34:03 Batching Writes in Object Storage
    35:08 Time-Based vs Size-Based Batching
    36:32 Understanding Amplification in Databases
    42:26 Challenges with Cold Queries
    44:02 Building and Persisting B-Trees
    50:53 Separating Workloads in Databases
    56:07 Multi-Tenancy Challenges
    01:00:39 Choosing Storage Formats
    01:06:10 Key Innovations in Object Storage Databases
    Important links:
    - https://github.com/sirupsen/napkin-math (numbers)
    - https://turbopuffer.com/
    - https://turbopuffer.com/architecture
    - https://sirupsen.com/napkin/problem-10-mysql-transactions-per-second
    - https://sirupsen.com (my blog, napkin math)
    - https://sirupsen.com/subscribe (napkin math newsletter)
    - https://github.com/rkyv/rkyv rkyv rust
    Become a member of The GeekNarrator to get access to member only videos, notes and monthly 1:1 with me.
    Like building stuff? Try out CodeCrafters and build amazing real world systems like Redis, Kafka, Sqlite. Use the link below to signup and get 40% off on paid subscription.
    https://app.codecrafters.io/join?via=geeknarrator
    If you like this episode, please hit the like button and share it with your network.
    Also please subscribe if you haven't yet.
    Database internals series: https://youtu.be/yV_Zp0Mi3xs
    Popular playlists:
    Realtime streaming systems: https://www.youtube.com/playlist?list=PLL7QpTxsA4se-mAKKoVOs3VcaP71X_LA-
    Software Engineering: https://www.youtube.com/playlist?list=PLL7QpTxsA4sf6By03bot5BhKoMgxDUU17
    Distributed systems and databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4sfLDUnjBJXJGFhhz94jDd_d
    Modern databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4scSeZAsCUXijtnfW5ARlrsN
    Stay Curios! Keep Learning!

    1 hr 9 min
  • Practical Systems Learning & Verification with Jack Vanlightly

    Welcome to The GeekNarrator podcast! In this episode, host Kaivalya Apte goes deeper into the practical applications of formal methods with Jack Vanlightly, a principal technologist at Confluent. With years of experience in distributed systems, Jack discusses his journey and how formal methods have been instrumental in system design verification and bug detection. The conversation covers Jack's background, his process of using formal methods, the significance of modelling, verification, documentation, and systems learning, as well as the future evolution of tooling and its applications. Tune in to understand the intricacies of how formal methods can transform your approach to distributed systems!

    Chapters:
    00:00 Introduction to the episode
    00:37 Meet Jack VanLightly: Principal Technologist at Confluent
    02:17 Jack's Journey into Distributed Systems
    04:29 Discovering the Power of Formal Methods
    08:11 Modeling and Simulation in Formal Methods
    13:43 Verification and Safety Properties
    19:02 Documentation and Communication Challenges
    20:43 Formal Methods as a Systems Learning Tool
    24:26 Practical Applications and Case Studies
    56:38 Future of Formal Verification and Closing Thoughts
    Jack's Blog: https://jack-vanlightly.com/
    Become a member of The GeekNarrator to get access to member only videos, notes and monthly 1:1 with me.
    Like building stuff? Try out CodeCrafters and build amazing real world systems like Redis, Kafka, Sqlite. Use the link below to signup and get 40% off on paid subscription.
    https://app.codecrafters.io/join?via=geeknarrator
    If you like this episode, please hit the like button and share it with your network.
    Also please subscribe if you haven't yet.
    Database internals series: https://youtu.be/yV_Zp0Mi3xs
    Popular playlists:
    Realtime streaming systems: https://www.youtube.com/playlist?list=PLL7QpTxsA4se-mAKKoVOs3VcaP71X_LA-
    Software Engineering: https://www.youtube.com/playlist?list=PLL7QpTxsA4sf6By03bot5BhKoMgxDUU17
    Distributed systems and databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4sfLDUnjBJXJGFhhz94jDd_d
    Modern databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4scSeZAsCUXijtnfW5ARlrsN
    Stay Curios! Keep Learning!

    1 hr 2 min
  • Database Internals - NileDB Postgres re-engineered for multitenant apps

    Database Internals - NileDB: Postgres Re-engineered for Multitenant Apps with Gwen Shapira

    Join us in this episode as we dive deep into the intricacies of NileDB, a groundbreaking database re-engineered for multi-tenant applications. Our special guest, Gwen Shapira, co-founder of NileDB and a notable figure in the database field, shares her insights and technical know-how on solving the common challenges faced by multitenant SaaS applications. From the benefits of using Postgres as the underlying database to the unique tenant isolation features of NileDB, we cover it all. Don't miss out on learning about AI native capabilities, handling schema migrations, and ensuring zero downtime data migrations.
    Chapters:
    00:00 Introduction
    07:19 Challenges in Multi-Tenant Databases
    11:09 Tenant Isolation and NILDB's Approach
    34:16 Necessary Modifications for Tenant Data
    37:47 Zero Downtime Data Migrations
    44:32 Handling Schema Migrations
    59:11 AI Use Cases and Vector Embedding Storage
    59:51 Technical and Non-Technical Learnings from Building Nile
    01:05:03 Future Plans and Upcoming Features
    NileDB: https://www.thenile.dev/
    Blog: https://www.thenile.dev/blog
    Gwen's Linkedin: https://www.linkedin.com/in/gwenshapira
    Gwen's Twitter: https://twitter.com/gwenshap
    #postgres #sql #ai
    Become a member of The GeekNarrator to get access to member only videos, notes and monthly 1:1 with me.
    Like building stuff? Try out CodeCrafters and build amazing real world systems like Redis, Kafka, Sqlite. Use the link below to signup and get 40% off on paid subscription.
    https://app.codecrafters.io/join?via=geeknarrator
    If you like this episode, please hit the like button and share it with your network.
    Also please subscribe if you haven't yet.
    Database internals series: https://youtu.be/yV_Zp0Mi3xs
    Popular playlists:
    Realtime streaming systems: https://www.youtube.com/playlist?list=PLL7QpTxsA4se-mAKKoVOs3VcaP71X_LA-
    Software Engineering: https://www.youtube.com/playlist?list=PLL7QpTxsA4sf6By03bot5BhKoMgxDUU17
    Distributed systems and databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4sfLDUnjBJXJGFhhz94jDd_d
    Modern databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4scSeZAsCUXijtnfW5ARlrsN
    Stay Curios! Keep Learning!

    1 hr 7 min

About The GeekNarrator

From the publisher's feed

The GeekNarrator podcast is a show hosted by Kaivalya Apte who is a Software Engineer and loves to talk about Technology, Technical Interviews, Self Improvement, Best Practices and Hustle.