Video wird geladen...

Video konnte nicht geladen werden

Beim Laden dieses Videos ist ein Problem aufgetreten. Dies könnte an einem vorübergehenden Netzwerkproblem liegen oder das Video ist möglicherweise nicht verfügbar.

🐘 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,642 subscribers

45,984 Aufrufe • vor 6 Tagen •via X (Twitter)

Bildung Wissenschaft & Technologie

Anya Rossi• Live Now

Private livecam show

19 Kommentare

Profilbild von Remotely

Remotelyvor 6 Tagen

wow! 3d!

Profilbild von alex shapalov

alex shapalovvor 6 Tagen

pi in 3d

Profilbild von ActiveRabbit

ActiveRabbitvor 6 Tagen

Finally, Postgres internals you can actually see. 🐘

Profilbild von pgrun.dev

pgrun.devvor 6 Tagen

Start with Disk → Memory → WAL.

Profilbild von alex shapalov

alex shapalovvor 6 Tagen

Good road map!

Profilbild von alex shapalov

alex shapalovvor 6 Tagen

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

Profilbild von Gorka Cesium

Gorka Cesiumvor 5 Tagen

I bet @convex is already working on something similar

Profilbild von alex shapalov

alex shapalovvor 5 Tagen

@convex show me the link

Profilbild von Brinkin

Brinkinvor 5 Tagen

this feels like the future of realtime telemetry

Profilbild von alex shapalov

alex shapalovvor 5 Tagen

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

Profilbild von al

alvor 5 Tagen

ooooooo Im going to use this...

Profilbild von alex shapalov

alex shapalovvor 5 Tagen

sure! let's learn PG!

Profilbild von matthew

matthewvor 5 Tagen

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

Profilbild von alex shapalov

alex shapalovvor 5 Tagen

This is how I present architecture and system design now.

Profilbild von Sujal

Sujalvor 5 Tagen

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

Profilbild von alex shapalov

alex shapalovvor 5 Tagen

Click on INSERT

Profilbild von Sujal

Sujalvor 5 Tagen

ha, trying the INSERT one tonight

Profilbild von Brjan | AI Builder

Brjan | AI Buildervor 5 Tagen

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

Profilbild von alex shapalov

alex shapalovvor 5 Tagen

Yes, 🙌

Ähnliche 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 Aufrufe • vor 2 Monaten

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 Aufrufe • vor 6 Monaten

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 Aufrufe • vor 1 Jahr

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,549 Aufrufe • vor 3 Monaten

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 Aufrufe • vor 6 Monaten

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 Aufrufe • vor 3 Jahren

📢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 Aufrufe • vor 2 Jahren

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 Aufrufe • vor 2 Monaten

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 Aufrufe • vor 8 Monaten

“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 Aufrufe • vor 5 Monaten

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 Aufrufe • vor 1 Monat

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 Aufrufe • vor 1 Jahr

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 Aufrufe • vor 4 Monaten

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 Aufrufe • vor 2 Jahren

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,850 Aufrufe • vor 12 Tagen

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 Aufrufe • vor 10 Monaten

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 Aufrufe • vor 9 Monaten

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 Aufrufe • vor 3 Monaten

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 Aufrufe • vor 5 Monaten

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 Aufrufe • vor 11 Monaten