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.

Postgres 19 can query relationships like a GRAPH NOT with a long manual join chain. With a path: customer → bought → product product ← bought ← similar customer similar customer → follows → brand That is a recommendation system in one readable pattern. SQL/PGQ finds the relationship. COLUMNS... show more

alex shapalov

2,639 subscribers

56,099 views • 3 months ago •via X (Twitter)

Science & Technology

Anya Rossi• Live Now

Private livecam show

0 Comments

No comments available

Comments from the original post will appear here

Related Videos

What Postgres can’t do alone, it can tackle with DuckDB. The pg_duckdb extension shows how two databases can work hand in hand by querying analytical data with DuckDB and joining it with transactional data in Postgres. The extension embeds DuckDB directly into Postgres. DuckDB literally runs inside a Postgres process. How it works (see diagram): 1. An app sends a query to Postgres joining portfolio data (Postgres) with historical market data (lakehouse) 2. pg_duckdb detects lakehouse access and delegates execution to DuckDB 3. DuckDB pulls required market data from the lakehouse, queries Postgres tables, and performs the join 4. Postgres returns the final result to the app

What Postgres can’t do alone, it can tackle with DuckDB. The pg_duckdb extension shows how two databases can work hand in hand by querying analytical data with DuckDB and joining it with transactional data in Postgres. The extension embeds DuckDB directly into Postgres. DuckDB literally runs inside a Postgres process. How it works (see diagram): 1. An app sends a query to Postgres joining portfolio data (Postgres) with historical market data (lakehouse) 2. pg_duckdb detects lakehouse access and delegates execution to DuckDB 3. DuckDB pulls required market data from the lakehouse, queries Postgres tables, and performs the join 4. Postgres returns the final result to the app

Denis Magda

28,678 views • 9 months ago

We just launched product photography feature with Bestever AI 🎉 A big part of our current customer base is DTC brands. They love being capital efficient with small teams. Product photography is one of those things AI is *really* good at & is super relevant to our customer base. Now our customers can go from a plain jane photo to a killer ad all in one place. Enjoy!!

We just launched product photography feature with Bestever AI 🎉 A big part of our current customer base is DTC brands. They love being capital efficient with small teams. Product photography is one of those things AI is really good at & is super relevant to our customer base. Now our customers can go from a plain jane photo to a killer ad all in one place. Enjoy!!

Apoorva Govind

21,751 views • 2 years ago

CÉCRED has been sitting in a gold mine. I still maintain that nothing beats traditional word of mouth, especially for a brand like CÉCRED. You just need the right customer. Real customer testimonies > influencer marketing A product going viral cos people saw the results Shop now at (US and worldwide) Or at Ulta Beauty (US Only)

IChooseViolence

22,729 views • 5 months ago

pgrust is 300x faster than Postgres on analytics. 10x of that comes from our column format, pgrcolumnar. With it, we read 1/10th the data Postgres needs to answer an analytical query. We designed pgrcolumnar so types have the same on-disk representation as they do in Postgres

pgrust is 300x faster than Postgres on analytics. 10x of that comes from our column format, pgrcolumnar. With it, we read 1/10th the data Postgres needs to answer an analytical query. We designed pgrcolumnar so types have the same on-disk representation as they do in Postgres

Michael Malis

35,598 views • 2 months ago

Postgres Changes now supports AND filters and column selection. You can match on more than one column in a single subscription, and pick which columns come back in the payload.

Postgres Changes now supports AND filters and column selection. You can match on more than one column in a single subscription, and pick which columns come back in the payload.

Supabase

13,320 views • 3 months ago

Final quality control check before delivering the product to the customer

Final quality control check before delivering the product to the customer

The Best Viral Vids🔥

37,938 views • 3 months ago

2. ChatGPT prompt for cold personalized outbound email "Write a cold outbound email to a prospective customer for our product X (e.g., company, product, service, or organization)"

2. ChatGPT prompt for cold personalized outbound email "Write a cold outbound email to a prospective customer for our product X (e.g., company, product, service, or organization)"

Hamza | Social Media Growth

13,896 views • 3 years ago

bro is NOT a paying customer!

bro is NOT a paying customer!

Punch Cat

20,103 views • 2 years ago

Go from single-node Postgres to highly-available Postgres in one click 🐘 NOT production ready. Every time you use it in production, the Product Engineer who built it starts sweating Try it out and give us feedback

Go from single-node Postgres to highly-available Postgres in one click 🐘 NOT production ready. Every time you use it in production, the Product Engineer who built it starts sweating Try it out and give us feedback

Mahmoud

24,976 views • 8 months ago

Big tables in Postgres can be a real pain. This is true of many databases, but the reasons for this are very different in MySQL vs Postgres vs YOUR_FAVORITE_DB. This article by simeonGriggs beautifully covers all the common issues, and how to solve with partitioning and sharding. Combined with all the excellent visuals, a must-read for anyone using Postgres.

Big tables in Postgres can be a real pain. This is true of many databases, but the reasons for this are very different in MySQL vs Postgres vs YOUR_FAVORITE_DB. This article by simeonGriggs beautifully covers all the common issues, and how to solve with partitioning and sharding. Combined with all the excellent visuals, a must-read for anyone using Postgres.

Ben Dicken

44,107 views • 2 months ago

When you're running a small business, you're the creative director, camera operator, editor… and probably the person answering customer messages too. So I like finding ways to make product content more interesting without turning editing into a full-time job. This time, I made the product the target of a spy mission with CapCut PC: ➪ #capcutpc #capcutblackfriday

When you're running a small business, you're the creative director, camera operator, editor… and probably the person answering customer messages too. So I like finding ways to make product content more interesting without turning editing into a full-time job. This time, I made the product the target of a spy mission with CapCut PC: ➪ #capcutpc #capcutblackfriday

Nora

174,484 views • 5 days ago

Only in Zhoushan, Zhejiang: a swimming crab latte served right in the shell, complete with latte art. One customer said it “tastes like the sea.”

Only in Zhoushan, Zhejiang: a swimming crab latte served right in the shell, complete with latte art. One customer said it “tastes like the sea.”

Shanghai Daily

88,755 views • 2 months ago

Mythos / Fable is unbelievable. Was on a customer call today and had Claude transcribing in the background. As they were telling me about the features they wish their current software had, Claude was building the features in real time. By the end of the call I was able to show a fully working product, with the exact workflow they mentioned 15 minutes earlier. Autonomous looped building triggered from a customer call. 🤯

Mythos / Fable is unbelievable. Was on a customer call today and had Claude transcribing in the background. As they were telling me about the features they wish their current software had, Claude was building the features in real time. By the end of the call I was able to show a fully working product, with the exact workflow they mentioned 15 minutes earlier. Autonomous looped building triggered from a customer call. 🤯

Todd Saunders

2,094,198 views • 5 months ago

A training cluster is one machine. When thousands of GPUs finish a phase together, a campus can drop 300MW in moments and ramp straight back. Grids weren’t designed for a customer that behaves like a fault on a schedule 🧵

A training cluster is one machine. When thousands of GPUs finish a phase together, a campus can drop 300MW in moments and ramp straight back. Grids weren’t designed for a customer that behaves like a fault on a schedule 🧵

Aethir

17,965 views • 2 months ago

How can you not want such a cute customer to come back often? 😊😊

How can you not want such a cute customer to come back often? 😊😊

BB

60,579 views • 1 month ago

>Bought a new charger >Was impressed with the performance >Decided to make a cool product animation of it #Blender3D

>Bought a new charger >Was impressed with the performance >Decided to make a cool product animation of it #Blender3D

Nanla Othniel

11,866 views • 8 months ago

🐰: The customer passing by, are you perhaps interested in K-Swiss? Oh there's a car coming! THERE'S A CAR COMING DEAR CUSTOMER! BE CAREFUL! BE CAREFUL!!! (Then forces the customer into the shop) 🤣

🐰: The customer passing by, are you perhaps interested in K-Swiss? Oh there's a car coming! THERE'S A CAR COMING DEAR CUSTOMER! BE CAREFUL! BE CAREFUL!!! (Then forces the customer into the shop) 🤣

Ponyo 🍀🍊

72,110 views • 4 months ago

As a product guy, I’m impressed by the efficiency and accuracy of Budbee ‘s deliveries. As a customer, not so much. Thanks Arlo Smart Home for capturing last night’s shenanigans. 😂 #fridaypost #deliveryfail

As a product guy, I’m impressed by the efficiency and accuracy of Budbee ‘s deliveries. As a customer, not so much. Thanks Arlo Smart Home for capturing last night’s shenanigans. 😂 #fridaypost #deliveryfail

Rasmus Järborg

21,917 views • 2 years ago