Video yükleniyor...

Video Yüklenemedi

Ana Sayfaya Dön

🐘 Introducing Postgres Internals in 3D. 🌟 Stop reading boring diagrams. Start exploring PostgreSQL. An interactive 3D map to understand how Postgres actually works. 100% free. Built for developers.

alxshp's profile picture

alex shapalov

3,749 subscribers

46,514 görüntüleme • 10 gün önce •via X (Twitter)

EğitimBilim & Teknoloji
LIVE

Anya Rossi• Live Now

Private livecam show

19 Yorum

Remotely profil fotoğrafı
Remotely10 gün önce

wow! 3d!

alex shapalov profil fotoğrafı
alex shapalov10 gün önce

pi in 3d

ActiveRabbit profil fotoğrafı
ActiveRabbit10 gün önce

Finally, Postgres internals you can actually see. 🐘

pgrun.dev profil fotoğrafı
pgrun.dev10 gün önce

Start with Disk → Memory → WAL.

alex shapalov profil fotoğrafı
alex shapalov10 gün önce

Good road map!

alex shapalov profil fotoğrafı
alex shapalov10 gün önce

I just spent an hour exploring this 3D map of PostgreSQL internals. Surprisingly addictive and inspiring! Now you’ll finally understand what the Postmaster actually does. 🐘

Gorka Cesium profil fotoğrafı
Gorka Cesium9 gün önce

I bet @convex is already working on something similar

alex shapalov profil fotoğrafı
alex shapalov9 gün önce

@convex show me the link

Brinkin profil fotoğrafı
Brinkin9 gün önce

this feels like the future of realtime telemetry

alex shapalov profil fotoğrafı
alex shapalov9 gün önce

Exactly! Telemetry should be something you explore, not just dashboards you stare at)

al profil fotoğrafı
al9 gün önce

ooooooo Im going to use this...

alex shapalov profil fotoğrafı
alex shapalov9 gün önce

sure! let's learn PG!

matthew profil fotoğrafı
matthew9 gün önce

This is how is present architecture and system design now. UML and ADR are dead.

alex shapalov profil fotoğrafı
alex shapalov9 gün önce

This is how I present architecture and system design now.

Sujal profil fotoğrafı
Sujal9 gün önce

Can you click into a single query and watch it go through the planner?

alex shapalov profil fotoğrafı
alex shapalov9 gün önce

Click on INSERT

Sujal profil fotoğrafı
Sujal9 gün önce

ha, trying the INSERT one tonight

Brjan | AI Builder profil fotoğrafı
Brjan | AI Builder9 gün önce

interactive 3D maps could make complex concepts way more digestible for devs

alex shapalov profil fotoğrafı
alex shapalov9 gün önce

Yes, 🙌

Benzer Videolar

Finish the week with a Postgres video 🌟 All about using JSON in Postgres: - when you should use it - how to use it efficiently - how JSONs actually get stored in postgres.
21:29

Finish the week with a Postgres video 🌟 All about using JSON in Postgres: - when you should use it - how to use it efficiently - how JSONs actually get stored in postgres.

Gwen (Chen) Shapira

27,633 görüntüleme • 1 yıl önce

🚀 launched today: 🐘 Postgres branches for every AI agent. → build a Postgres branch in ~3 seconds → production-like data → isolated database for every agent → sensitive data automatically masked → branch → work → delete Already ~100 Postgres branches/week before public launch. Now we're building the Postgres runtime for agents.
0:24

🚀 launched today: 🐘 Postgres branches for every AI agent. → build a Postgres branch in ~3 seconds → production-like data → isolated database for every agent → sensitive data automatically masked → branch → work → delete Already ~100 Postgres branches/week before public launch. Now we're building the Postgres runtime for agents.

alex shapalov

113,130 görüntüleme • 1 ay önce

Introducing the latest in Postgres for agentic workloads. Agents can now branch or wake your Postgres database instantly.
2:47

Introducing the latest in Postgres for agentic workloads. Agents can now branch or wake your Postgres database instantly.

Xata 🦋

355,711 görüntüleme • 4 ay önce

Introducing pg_strict for Postgres. Our new extension adds a safety net to Postgres, catching dangerous queries before they run.
3:38

Introducing pg_strict for Postgres. Our new extension adds a safety net to Postgres, catching dangerous queries before they run.

PlanetScale

114,704 görüntüleme • 9 ay önce

How Postgres 17 improves IN queries In prior releases, postgres would loop and do multiple "primitive" index scans as many as your IN elements. In Postgres 17 it takes an array and eliminates the need for multiple scans. This only applies for constant values
3:39

How Postgres 17 improves IN queries In prior releases, postgres would loop and do multiple "primitive" index scans as many as your IN elements. In Postgres 17 it takes an array and eliminates the need for multiple scans. This only applies for constant values

Hussein Nasser

143,703 görüntüleme • 1 yıl önce

Introducing dba: The Autonomous AI Agent for Postgres
1:00

Introducing dba: The Autonomous AI Agent for Postgres

Tembo

26,636 görüntüleme • 1 yıl önce

Seems like an interactive 2D & 3D museum is being built for Juice WRLD's upcoming album "The Outsiders" 👀 "2D/3D interactive virtual world building similar to the Legends Never Die digital museum..." We actually getting the album 🔥
0:34

Seems like an interactive 2D & 3D museum is being built for Juice WRLD's upcoming album "The Outsiders" 👀 "2D/3D interactive virtual world building similar to the Legends Never Die digital museum..." We actually getting the album 🔥

RileyTaugor 🏴

22,525 görüntüleme • 3 ay önce

Textbooks haven't changed in 100 years. Until now... Smart Biology's LIFE 3D Animated Textbooks replace flat diagrams with immersive 3D models, narration, and interactive quizzes. It's the textbook reimagined. #biology #science #3D #animations #EdTech
0:20

Textbooks haven't changed in 100 years. Until now... Smart Biology's LIFE 3D Animated Textbooks replace flat diagrams with immersive 3D models, narration, and interactive quizzes. It's the textbook reimagined. #biology #science #3D #animations #EdTech

Smart Biology

70,821 görüntüleme • 1 yıl önce

Computer can create interactive 3D diagrams to help you visualize things like furniture assembly.
1:36

Computer can create interactive 3D diagrams to help you visualize things like furniture assembly.

Computer

48,966 görüntüleme • 25 gün önce

Your Postgres is 100x slower than traditional OLAP engines. A deceptively simple OSS extension fixes this. Here's an interview where we dive into the deep engineering around how this is achieved. Joining me (and leading the conversation) is Marco Slot: an engineer with an EXTENSIVE and impressive career history around PostgreSQL: 👉 Created pg_cron in 2017 (3.7k stars) - a tool to run cron-jobs in Postgres 👉 Built pg_incremental - fast, reliable, incremental batch processing inside PostgreSQL itself 👉 co-created pg_lake (after working on Crunchy Data's Warehouse, and getting acquired into Snowflake) 👉 Helped get pg_documentdb (MongoDB-on-Postgres) off the ground Marco Slot is a world-class expert in Postgres extensions. He seriously impressed me with his knowledge over the course of a private LinkedIn conversation, and now that I type out his resume - I understand where it came from. He should be on everyone's radar. So I brought him on the pod. In our full 2-hour deep-dive, we went over: • 🔥 how pg_lake makes analytics 100x faster (literally) • 🔥 perf internals like vectorized execution & CPU branching • 🤔 practical differences between OLTP and OLAP database development (and the age-old mission in uniting both) • 🤔 how (and why) pg_lake intercepts query plans and delegates parts of the query tree to DuckDB • 💡 why Postgres is architecturally terrible at analytical queries (and how vectorized execution fixes this) • 💡 Marco's hard-won experience through a decade+ career in Postgres • 🏆 Iceberg's role as the TCP/IP for tables • 🏆 what the real moat of PostgreSQL is Developments like pg_lake are a real reason why "Just Use Postgres" is much more than a meme, and it'll continue to dominate discourse. I promise you will learn a lot from this episode. Timestamps: (0:02) What is pg_lake? (2:23) Postgres' 100x slower problem and columnar storage experiments they had to make Postgres fast for analytics (6:00) practical examples and internals (16:20) perf internals - vectorized execution & CPU optimization (23:00) pg_lake architecture (why DuckDB isn't embedded) and the connection-per-process issue (29:16) how pg_lake intercepts the query plan tree and delegates parts to DuckDB (41:09) Iceberg catalogs (48:24) postgres to iceberg ingestion patterns (and pg_incremental) (53:40) Marco's (long) career: early AWS, Citus, Microsoft, Crunchy Data & Snowflake (1:04:20) Marco's observations around the merging between OLTP and OLAP (and the subtle dev differences there) (1:15:30) reverse ETL (1:33:08) Iceberg as the TCP/IP for tables (1:35:00) Marco's thoughts on the "Just Use Postgres" fever
1:39:30

Your Postgres is 100x slower than traditional OLAP engines. A deceptively simple OSS extension fixes this. Here's an interview where we dive into the deep engineering around how this is achieved. Joining me (and leading the conversation) is Marco Slot: an engineer with an EXTENSIVE and impressive career history around PostgreSQL: 👉 Created pg_cron in 2017 (3.7k stars) - a tool to run cron-jobs in Postgres 👉 Built pg_incremental - fast, reliable, incremental batch processing inside PostgreSQL itself 👉 co-created pg_lake (after working on Crunchy Data's Warehouse, and getting acquired into Snowflake) 👉 Helped get pg_documentdb (MongoDB-on-Postgres) off the ground Marco Slot is a world-class expert in Postgres extensions. He seriously impressed me with his knowledge over the course of a private LinkedIn conversation, and now that I type out his resume - I understand where it came from. He should be on everyone's radar. So I brought him on the pod. In our full 2-hour deep-dive, we went over: • 🔥 how pg_lake makes analytics 100x faster (literally) • 🔥 perf internals like vectorized execution & CPU branching • 🤔 practical differences between OLTP and OLAP database development (and the age-old mission in uniting both) • 🤔 how (and why) pg_lake intercepts query plans and delegates parts of the query tree to DuckDB • 💡 why Postgres is architecturally terrible at analytical queries (and how vectorized execution fixes this) • 💡 Marco's hard-won experience through a decade+ career in Postgres • 🏆 Iceberg's role as the TCP/IP for tables • 🏆 what the real moat of PostgreSQL is Developments like pg_lake are a real reason why "Just Use Postgres" is much more than a meme, and it'll continue to dominate discourse. I promise you will learn a lot from this episode. Timestamps: (0:02) What is pg_lake? (2:23) Postgres' 100x slower problem and columnar storage experiments they had to make Postgres fast for analytics (6:00) practical examples and internals (16:20) perf internals - vectorized execution & CPU optimization (23:00) pg_lake architecture (why DuckDB isn't embedded) and the connection-per-process issue (29:16) how pg_lake intercepts the query plan tree and delegates parts to DuckDB (41:09) Iceberg catalogs (48:24) postgres to iceberg ingestion patterns (and pg_incremental) (53:40) Marco's (long) career: early AWS, Citus, Microsoft, Crunchy Data & Snowflake (1:04:20) Marco's observations around the merging between OLTP and OLAP (and the subtle dev differences there) (1:15:30) reverse ETL (1:33:08) Iceberg as the TCP/IP for tables (1:35:00) Marco's thoughts on the "Just Use Postgres" fever

Stanislav Kozlovski

16,889 görüntüleme • 6 ay önce

Built an interactive 3D microbial visualisation web app exploring bacteria structures through procedural organic shaders, detailed organism simulations and microscopy-inspired visuals.
0:25

Built an interactive 3D microbial visualisation web app exploring bacteria structures through procedural organic shaders, detailed organism simulations and microscopy-inspired visuals.

Techartist

20,282 görüntüleme • 5 ay önce

`bunx pg-here` global one-liner to run a standalone postgres instance with all data within the current folder throw-away postgres anytime anywhere. cli args for version/user/pass/db configs. docs: stop using docker just to launch a postgres!!
0:33

`bunx pg-here` global one-liner to run a standalone postgres instance with all data within the current folder throw-away postgres anytime anywhere. cli args for version/user/pass/db configs. docs: stop using docker just to launch a postgres!!

murat 🍥

50,537 görüntüleme • 8 ay önce

Scale PostgreSQL reads the easy way. In #AzureFriday, Scott Hanselman 🌮 and Paula Berenguel show how PostgreSQL on Azure uses read replicas and virtual endpoints to handle heavy read workloads, just like OpenAI powers ChatGPT on Postgres. Watch now:
0:39

Scale PostgreSQL reads the easy way. In #AzureFriday, Scott Hanselman 🌮 and Paula Berenguel show how PostgreSQL on Azure uses read replicas and virtual endpoints to handle heavy read workloads, just like OpenAI powers ChatGPT on Postgres. Watch now:

Microsoft Azure

31,180 görüntüleme • 2 ay önce

Go beyond the docs. Agglayer just got visual. Introducing the Agglayer Visualizer: a 3D interactive tool for exploring how unified bridging and crosschain settlement actually work under the hood. If you’re a visual learner, you’ll want to check this out ⬇️
0:24

Go beyond the docs. Agglayer just got visual. Introducing the Agglayer Visualizer: a 3D interactive tool for exploring how unified bridging and crosschain settlement actually work under the hood. If you’re a visual learner, you’ll want to check this out ⬇️

Agglayer

63,739 görüntüleme • 1 yıl önce

Replit Agent (launched today) built a startup landing page with waitlist and postgres db from start to finish in <4 mins
2:10

Replit Agent (launched today) built a startup landing page with waitlist and postgres db from start to finish in <4 mins

aman

237,308 görüntüleme • 2 yıl önce

Napkin sketch to interactive 3D rendering! Antigravity is the agentic development platform for developers to turn hand-drawn sketches into fully functional 3D learning modules.
1:03

Napkin sketch to interactive 3D rendering! Antigravity is the agentic development platform for developers to turn hand-drawn sketches into fully functional 3D learning modules.

Google Antigravity

67,113 görüntüleme • 4 ay önce

I built a post-run recap design studio in SwiftUI Live animated map, 2D and 3D rendering, full customization. Here's how everything works 👇
0:27

I built a post-run recap design studio in SwiftUI Live animated map, 2D and 3D rendering, full customization. Here's how everything works 👇

JC Builds

37,931 görüntüleme • 4 ay önce

This is how gravity actually works in reality in the 3D universe.
0:53

This is how gravity actually works in reality in the 3D universe.

Science Simplified

19,675 görüntüleme • 4 ay önce

it can actually. video calls with Postgres
1:29

it can actually. video calls with Postgres

Nick Van Wiggeren

134,401 görüntüleme • 8 ay önce

Introducing (open-source) A Supabase-compatible backend in a single binary - real Postgres with RLS, no docker (with ~36mb install footprint)! It's like PocketBase, but with Postgres instead of SQLite!
4:18

Introducing (open-source) A Supabase-compatible backend in a single binary - real Postgres with RLS, no docker (with ~36mb install footprint)! It's like PocketBase, but with Postgres instead of SQLite!

Sanket Sahu

46,008 görüntüleme • 3 ay önce