Loading video...

Video Failed to Load

There was a problem loading this video. This could be due to a temporary network issue or the video might be unavailable.

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

alex shapalov

3,477 subscribers

45,013 views • 3 days ago •via X (Twitter)

Education Science & Technology

Anya Rossi• Live Now

Private livecam show

19 Comments

Remotely3 days ago

wow! 3d!

alex shapalov3 days ago

pi in 3d

ActiveRabbit3 days ago

Finally, Postgres internals you can actually see. 🐘

pgrun.dev3 days ago

Start with Disk → Memory → WAL.

alex shapalov3 days ago

Good road map!

alex shapalov3 days ago

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 Cesium3 days ago

I bet @convex is already working on something similar

alex shapalov3 days ago

@convex show me the link

Brinkin3 days ago

this feels like the future of realtime telemetry

alex shapalov3 days ago

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

al2 days ago

ooooooo Im going to use this...

alex shapalov2 days ago

sure! let's learn PG!

matthew3 days ago

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

alex shapalov3 days ago

This is how I present architecture and system design now.

Sujal2 days ago

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

alex shapalov2 days ago

Click on INSERT

Sujal2 days ago

ha, trying the INSERT one tonight

Brjan | AI Builder2 days ago

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

alex shapalov2 days ago

Yes, 🙌

Related Videos

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 🔥

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 views • 2 months ago

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

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 views • 6 months ago

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 ⬇️

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 views • 1 year ago

Fun interactive science app ideas | Part 10 Built an app for exploring different types of butterflies It's surprising how calm and peaceful the gentle wing movements feel Everything is generated with code. No 3D models Code Kimi K3

Fun interactive science app ideas | Part 10 Built an app for exploring different types of butterflies It's surprising how calm and peaceful the gentle wing movements feel Everything is generated with code. No 3D models Code Kimi K3

Dilum Sanjaya

64,313 views • 3 months ago

Introducing the NEW WaveSpeedAI The ultimate AI media platform Now with AI Generator: image · video · audio · avatars · 3D Everything you need to create in one place Built for creators, developers, and teams

Introducing the NEW WaveSpeedAI The ultimate AI media platform Now with AI Generator: image · video · audio · avatars · 3D Everything you need to create in one place Built for creators, developers, and teams

WaveSpeedAI

13,711 views • 6 months ago

Mapbox has a brand new 3D map style, still in beta! But it didn’t have a hackable live demo, so at Skydio we created one 😎 , try it out here: The updates include: - Hundreds of new 3D models for famous landmarks - New symbolic design that works hand in hand with the style - Day/night light shift built in! How does this help? Through more accurate 3D maps: - Data displayed on the map is more useful as it’s easier to understand where you are (our brains think in 3D) - More immersive 3D experiences are unlocked, not just navigation Looking forward to seeing where Mapbox takes this next

Alberto

43,945 views • 3 years ago

📢Exciting new feature in #Leafmap! 🌟 You can now visualize #EarthEngine data on a stunning 3D terrain with #MapLibre 🗺️ Browse the massive 100+ PB Earth Engine Data Catalog and overlay any dataset on an interactive 3D map. 🌍 This demo showcases the ESA global land cover dataset with 3D buildings on top 🌳 GitHub: Notebook: #geospatial #opensource #dataviz #python

📢Exciting new feature in #Leafmap! 🌟 You can now visualize #EarthEngine data on a stunning 3D terrain with #MapLibre 🗺️ Browse the massive 100+ PB Earth Engine Data Catalog and overlay any dataset on an interactive 3D map. 🌍 This demo showcases the ESA global land cover dataset with 3D buildings on top 🌳 GitHub: Notebook: #geospatial #opensource #dataviz #python

Qiusheng Wu

18,248 views • 2 years ago

OMG... this is 10/10 for creating beautiful software architecture diagrams. 🤯👌 FossFLOW is a free, open-source tool for creating clean 3D isometric diagrams with hundreds of built-in icons and symbols. You can use it to visualize software architecture, networks, infrastructure, and complex systems without starting from scratch. Perfect for engineers, designers, developers, and vibe coders to create stunning architecture diagrams with ease :) Follow me for more amazing AI, Coding & Web Dev insights 💎

OMG... this is 10/10 for creating beautiful software architecture diagrams. 🤯👌 FossFLOW is a free, open-source tool for creating clean 3D isometric diagrams with hundreds of built-in icons and symbols. You can use it to visualize software architecture, networks, infrastructure, and complex systems without starting from scratch. Perfect for engineers, designers, developers, and vibe coders to create stunning architecture diagrams with ease :) Follow me for more amazing AI, Coding & Web Dev insights 💎

Ram Maheshwari

34,313 views • 2 months ago

Let Postgres own the Iceberg catalog and delegate analytics to DuckDB. The result => transactional lakehouse updates with fast analytical queries. This isn’t a concept. It’s exactly what pg_lake delivers today. pg_lake combines a set of extensions and components that let you query and modify Iceberg tables (and other lakehouse formats) directly from Postgres. DuckDB is used to accelerate analytical queries and runs in a sidecar process called pgduck_server, which communicates with Postgres during query execution. How it works (diagram below): 1. An application sends a query to Postgres to calculate unrealized PnL (Profit and Loss) for the Disney ticker. 2. Postgres parses the query and identifies the part that computes the average price from historical lakehouse data. 3. That part is forwarded to pgduck_server for accelerated execution. 4. pgduck_server delegates execution to DuckDB, which queries the lakehouse (reusing cached data if available). 5. DuckDB computes the average price and returns it to Postgres. 6. Postgres joins the result with local portfolio data and computes the unrealized PnL. 7. The final result is returned to the application.

Let Postgres own the Iceberg catalog and delegate analytics to DuckDB. The result => transactional lakehouse updates with fast analytical queries. This isn’t a concept. It’s exactly what pg_lake delivers today. pg_lake combines a set of extensions and components that let you query and modify Iceberg tables (and other lakehouse formats) directly from Postgres. DuckDB is used to accelerate analytical queries and runs in a sidecar process called pgduck_server, which communicates with Postgres during query execution. How it works (diagram below): 1. An application sends a query to Postgres to calculate unrealized PnL (Profit and Loss) for the Disney ticker. 2. Postgres parses the query and identifies the part that computes the average price from historical lakehouse data. 3. That part is forwarded to pgduck_server for accelerated execution. 4. pgduck_server delegates execution to DuckDB, which queries the lakehouse (reusing cached data if available). 5. DuckDB computes the average price and returns it to Postgres. 6. Postgres joins the result with local portfolio data and computes the unrealized PnL. 7. The final result is returned to the application.

Denis Magda

28,597 views • 8 months ago

“This took less than an hour." Interactive 3D is becoming essential across industries - but for a lot of teams, it’s still out of reach. That’s why we built Unity Studio - an intuitive, web-based, no-code editor that helps teams across industries, from manufacturing to retail, turn existing 3D assets into interactive experiences, straight from the browser. Check out what it looks like to go from a static 3D file to a fully interactive demo in under an hour. 🔗 Try it out yourself with a free 30 day Unity Studio trial:

“This took less than an hour." Interactive 3D is becoming essential across industries - but for a lot of teams, it’s still out of reach. That’s why we built Unity Studio - an intuitive, web-based, no-code editor that helps teams across industries, from manufacturing to retail, turn existing 3D assets into interactive experiences, straight from the browser. Check out what it looks like to go from a static 3D file to a fully interactive demo in under an hour. 🔗 Try it out yourself with a free 30 day Unity Studio trial:

Unity

10,408 views • 5 months ago

This AI created an interactive 3D textbook !! 💀 I didn't manually create any of these 3d models I built it using: 👉 GPT-6 Astra 👉 Hyper3D Rodin's MCP Hyper3D worked on the 3D Models And GPT-6 Astra made the website with the 3D Models integrated to the UI controls. It even added floating labels for the HEART !! This is what happens when an AI can actually CREATE 3D assets 👇

This AI created an interactive 3D textbook !! 💀 I didn't manually create any of these 3d models I built it using: 👉 GPT-6 Astra 👉 Hyper3D Rodin's MCP Hyper3D worked on the 3D Models And GPT-6 Astra made the website with the 3D Models integrated to the UI controls. It even added floating labels for the HEART !! This is what happens when an AI can actually CREATE 3D assets 👇

SARAH

135,934 views • 1 month ago

Introducing Fancy Components: a collection full of fancy, fun, edgy and useless React components! — Built with react, ts, Tailwind CSS and Motion — Each comp. includes examples and docs to help you understand how it works and is built — 100% free & open-source! link↴

Introducing Fancy Components: a collection full of fancy, fun, edgy and useless React components! — Built with react, ts, Tailwind CSS and Motion — Each comp. includes examples and docs to help you understand how it works and is built — 100% free & open-source! link↴

daniel petho

188,966 views • 1 year ago

Stop building diagrams the slow way. I gave EdrawMax’s AI Agent ONE sentence and it built an entire editable diagram in seconds. Whether you need floor plans, flowcharts, or SWOT analyses, this tool is a total game changer for work and school. Get started here: The 2D to 3D floor plan conversion is actually wild. #WorkSmartwithEdrawMax #EdrawMax #aidiagramsoftware #WondershareEdrawMax

Stop building diagrams the slow way. I gave EdrawMax’s AI Agent ONE sentence and it built an entire editable diagram in seconds. Whether you need floor plans, flowcharts, or SWOT analyses, this tool is a total game changer for work and school. Get started here: The 2D to 3D floor plan conversion is actually wild. #WorkSmartwithEdrawMax #EdrawMax #aidiagramsoftware #WondershareEdrawMax

KATE

109,153 views • 4 months ago

Introducing Move One, an easy way to capture and create 3D animations with just a phone #MadeWithMove 🎥 Capture motion anywhere with a single camera ⚡️ Get your data back in minutes 🤖 Animate 3D characters Try for free👇

Introducing Move One, an easy way to capture and create 3D animations with just a phone #MadeWithMove 🎥 Capture motion anywhere with a single camera ⚡️ Get your data back in minutes 🤖 Animate 3D characters Try for free👇

Move AI

67,569 views • 2 years ago

1/2 Yesterday, Taiz was completely encircled, and despite its importance, it has been somehow ignored. Encircling Taiz is just as egregious as taking Bab al-Mandab because it consolidates Houthi control and complicates the battlefield. I built an interactive 3D map of southwestern Yemen to show how this terrain works and why it matters. This is a quick walk-through.

1/2 Yesterday, Taiz was completely encircled, and despite its importance, it has been somehow ignored. Encircling Taiz is just as egregious as taking Bab al-Mandab because it consolidates Houthi control and complicates the battlefield. I built an interactive 3D map of southwestern Yemen to show how this terrain works and why it matters. This is a quick walk-through.

Fatima Alasrar

23,060 views • 9 days ago

gemini 3 flash is so crazy.. it can generate code for an interactive 3d car racing game in ~1 min, control speed and direction with hands, no need code, just text prompts its 100% free & a lot faster than 3 pro how to improve this, anyone?

gemini 3 flash is so crazy.. it can generate code for an interactive 3d car racing game in ~1 min, control speed and direction with hands, no need code, just text prompts its 100% free & a lot faster than 3 pro how to improve this, anyone?

el.cine

114,398 views • 10 months ago

Big moment for Postgres! AI coding tools have been surprisingly bad at writing Postgres code. Not because the models are dumb, but because of how they learned SQL in the first place. LLMs are trained on the internet, which is full of outdated Stack Overflow answers and quick-fix tutorials. So when you ask an AI to generate a schema, it gives you something that technically runs but misses decades of Postgres evolution, like: - No GENERATED ALWAYS AS IDENTITY (added in PG10) - No expression or partial indexes - No NULLS NOT DISTINCT (PG15) - Missing CHECK constraints and proper foreign keys - Generic naming that tells you nothing But this is actually a solvable problem. You can teach AI tools to write better Postgres by giving them access to the right documentation at inference time. This exact solution is actually implemented in the newly released pg-aiguide by Tiger Data - Creators of TimescaleDB, which is an open-source MCP server that provides coding tools access to 35 years of Postgres expertise. In a gist, the MCP server enables: - Semantic search over the official PostgreSQL manual (version-aware, so it knows PG14 vs PG17 differences) - Curated skills with opinionated best practices for schema design, indexing, and constraints. I ran an experiment with Claude Code to see how well this works, and worked with the team to put this together. Prompt: "Generate a schema for an e-commerce site twice, one with the MCP server disabled, one with it enabled. Finally, run an assessment to compare the generated schemas." The run with the MCP server led to: - 420% more indexes (including partial and expression indexes) - 235% more constraints - 60% more tables (proper normalization) - 11 automation functions and triggers - Modern PG17 patterns throughout The MCP-assisted schema had proper data integrity, performance optimizations baked in, and followed naming conventions that actually make sense in production. pg-aiguide works with Claude Code, Cursor, VS Code, and any MCP-compatible tool. It's free and fully open source. I have shared the repo in the replies!

Big moment for Postgres! AI coding tools have been surprisingly bad at writing Postgres code. Not because the models are dumb, but because of how they learned SQL in the first place. LLMs are trained on the internet, which is full of outdated Stack Overflow answers and quick-fix tutorials. So when you ask an AI to generate a schema, it gives you something that technically runs but misses decades of Postgres evolution, like: - No GENERATED ALWAYS AS IDENTITY (added in PG10) - No expression or partial indexes - No NULLS NOT DISTINCT (PG15) - Missing CHECK constraints and proper foreign keys - Generic naming that tells you nothing But this is actually a solvable problem. You can teach AI tools to write better Postgres by giving them access to the right documentation at inference time. This exact solution is actually implemented in the newly released pg-aiguide by Tiger Data - Creators of TimescaleDB, which is an open-source MCP server that provides coding tools access to 35 years of Postgres expertise. In a gist, the MCP server enables: - Semantic search over the official PostgreSQL manual (version-aware, so it knows PG14 vs PG17 differences) - Curated skills with opinionated best practices for schema design, indexing, and constraints. I ran an experiment with Claude Code to see how well this works, and worked with the team to put this together. Prompt: "Generate a schema for an e-commerce site twice, one with the MCP server disabled, one with it enabled. Finally, run an assessment to compare the generated schemas." The run with the MCP server led to: - 420% more indexes (including partial and expression indexes) - 235% more constraints - 60% more tables (proper normalization) - 11 automation functions and triggers - Modern PG17 patterns throughout The MCP-assisted schema had proper data integrity, performance optimizations baked in, and followed naming conventions that actually make sense in production. pg-aiguide works with Claude Code, Cursor, VS Code, and any MCP-compatible tool. It's free and fully open source. I have shared the repo in the replies!

Avi Chawla

187,280 views • 9 months ago

We built an interactive 3D model of our solar system to teach kids about space. Based on NASA's JPL data to within 1/60 of a degree. It runs in real time. Made for Marble App.

We built an interactive 3D model of our solar system to teach kids about space. Based on NASA's JPL data to within 1/60 of a degree. It runs in real time. Made for Marble App.

Lionel Mora

21,056 views • 3 months ago

The training code for Hunyuan World 1.1 (WorldMirror) is released now!🔥🔥🔥 This release provides researchers and developers the full stack for customization and fine-tuning: 📷 Your video to 3D worlds in 1 second. 🪄ANY input (image, video, 3D prior) to ANY output (3DGS, depth, cameras, normal, points) Start customizing your model and exploring the demo! Online demo: Code:

The training code for Hunyuan World 1.1 (WorldMirror) is released now!🔥🔥🔥 This release provides researchers and developers the full stack for customization and fine-tuning: 📷 Your video to 3D worlds in 1 second. 🪄ANY input (image, video, 3D prior) to ANY output (3DGS, depth, cameras, normal, points) Start customizing your model and exploring the demo! Online demo: Code:

Tencent Hy

67,976 views • 11 months ago

Introducing Fight Anyone 3D🥊A 3D party fighter, probably the most satisfying game to play at work. Upload anyone's photo → a playable 3D fighter with a voice, a personality + signature moves, built by Viggle's own game engine + model. 100% free in beta + 20 gift cards to give away. Play more, win more! Fight your colleague. Fight your friends. Fight anyone. Link + tutorial + more in the thread ↓

Introducing Fight Anyone 3D🥊A 3D party fighter, probably the most satisfying game to play at work. Upload anyone's photo → a playable 3D fighter with a voice, a personality + signature moves, built by Viggle's own game engine + model. 100% free in beta + 20 gift cards to give away. Play more, win more! Fight your colleague. Fight your friends. Fight anyone. Link + tutorial + more in the thread ↓

ViggleAI

11,849 views • 5 months ago