MENU

Fun & Interesting

Bare Metal PostgreSQL? - @PrismaData

The Geek Narrator 604 lượt xem 2 months ago
Video Not Working? Fix It Now

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 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.

Chapters

00:00 Introduction to Prisma and Its Evolution
03:00 The Journey from ORM to Prisma Postgres
06:00 Simplifying Database Management
09:01 Understanding Prisma Postgres Architecture
12:12 The Role of Accelerate in Query Routing
14:51 Optimizing Query Processing with Micro VMs
18:12 Maintaining Postgres Integrity in a Micro VM Environment
21:07 User Experience and Community Feedback
23:57 Challenges of Data Center Management
27:09 Cold Starts and Performance Optimization
34:30 Understanding Snapshots in Postgres
38:55 Snapshot Mechanisms and Fault Tolerance
44:09 Change Data Capture with Pulse
55:07 Transitioning to Prisma Postgres
58:45 Community and Getting Started with Prisma Postgres

Some blogs worth checking out:
https://www.prisma.io/blog/prisma-postgres-the-future-of-serverless-databases
https://www.prisma.io/blog/cloudflare-unikernels-and-bare-metal-life-of-a-prisma-postgres-query
https://www.prisma.io/blog/announcing-prisma-postgres-early-access

Prisma Postgres relies heavily on the Unikraft project. There is a good introductory talk here: https://www.youtube.com/watch?v=n4wOyAuNhl0

And some very technical papers here: https://unikraft.org/community/papers

The 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

------------------------------------------------------------------------------------------------------------------------------------------------------------------
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!

#postgresql #databasesystems #SQL #distributedsystems #cloudcomputing #aws #prisma

Comment