Загрузка видео...

Не удалось загрузить видео

На главную

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

46,606 просмотров • 10 дней назад •via X (Twitter)

ОбразованиеНаука и технологии
LIVE

Anya Rossi• Live Now

Private livecam show

Комментарии: 19

Фото профиля Remotely
Remotely10 дней назад

wow! 3d!

Фото профиля alex shapalov
alex shapalov10 дней назад

pi in 3d

Фото профиля ActiveRabbit
ActiveRabbit10 дней назад

Finally, Postgres internals you can actually see. 🐘

Фото профиля pgrun.dev
pgrun.dev10 дней назад

Start with Disk → Memory → WAL.

Фото профиля alex shapalov
alex shapalov10 дней назад

Good road map!

Фото профиля alex shapalov
alex shapalov10 дней назад

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
Gorka Cesium10 дней назад

I bet @convex is already working on something similar

Фото профиля alex shapalov
alex shapalov10 дней назад

@convex show me the link

Фото профиля Brinkin
Brinkin10 дней назад

this feels like the future of realtime telemetry

Фото профиля alex shapalov
alex shapalov10 дней назад

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

Фото профиля al
al10 дней назад

ooooooo Im going to use this...

Фото профиля alex shapalov
alex shapalov10 дней назад

sure! let's learn PG!

Фото профиля matthew
matthew10 дней назад

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

Фото профиля alex shapalov
alex shapalov10 дней назад

This is how I present architecture and system design now.

Фото профиля Sujal
Sujal10 дней назад

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

Фото профиля alex shapalov
alex shapalov10 дней назад

Click on INSERT

Фото профиля Sujal
Sujal10 дней назад

ha, trying the INSERT one tonight

Фото профиля Brjan | AI Builder
Brjan | AI Builder10 дней назад

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

Фото профиля alex shapalov
alex shapalov10 дней назад

Yes, 🙌

Похожие видео

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 просмотров • 1 год назад

🚀 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 просмотров • 1 месяц назад

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 просмотров • 4 месяцев назад

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 просмотров • 9 месяцев назад

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 просмотров • 1 год назад

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

Introducing dba: The Autonomous AI Agent for Postgres

Tembo

26,636 просмотров • 1 год назад

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 просмотров • 3 месяцев назад

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 просмотров • 1 год назад

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 просмотров • 26 дней назад

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 просмотров • 6 месяцев назад

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 просмотров • 5 месяцев назад

`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 просмотров • 8 месяцев назад

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 просмотров • 2 месяцев назад

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 просмотров • 1 год назад

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 просмотров • 2 лет назад

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 просмотров • 4 месяцев назад

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 просмотров • 4 месяцев назад

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 просмотров • 4 месяцев назад

it can actually. video calls with Postgres
1:29

it can actually. video calls with Postgres

Nick Van Wiggeren

134,401 просмотров • 8 месяцев назад

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 просмотров • 3 месяцев назад