正在加载视频...

视频加载失败

加载此视频时出现问题。这可能是由于临时网络问题，或视频可能不可用。

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 次观看 • 3 个月前 •via X (Twitter)

Anya Rossi• Live Now

Private livecam show

0 条评论

暂无评论

原始帖子的评论将显示在这里

相关视频

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 次观看 • 9 个月前

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 次观看 • 2 年前

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 次观看 • 5 个月前

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 次观看 • 2 个月前

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 次观看 • 3 个月前

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🔥

38,459 次观看 • 3 个月前

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 次观看 • 8 个月前

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 次观看 • 2 个月前

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 次观看 • 3 年前

bro is NOT a paying customer!

bro is NOT a paying customer!

Punch Cat

20,103 次观看 • 2 年前

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

175,166 次观看 • 9 天前

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 次观看 • 2 个月前

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 次观看 • 2 个月前

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,320 次观看 • 5 个月前

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,662 次观看 • 1 个月前

Big moment for Postgres! Search has always been Postgres' weak spot, and everyone just accepted it. If you needed a real relevance-ranked keyword search, the default answer was to spin up Elasticsearch or add Algolia and deal with the data sync headaches forever. The problem isn't that Postgres can't do text search. It can. But the built-in `ts_rank` function uses a basic term frequency algorithm that doesn't come close to what modern search engines deliver. So teams end up: - Running a separate Elasticsearch cluster just for search - Building sync pipelines that inevitably drift out of consistency - Paying for managed search services that charge per query - Accepting mediocre search relevance because "good enough" ships faster But this is actually a solvable problem. You can realistically bring industry-standard search ranking directly into Postgres, which eliminates the need for external infra entirely. This exact solution is now available with the newly open-sourced pg_textsearch by Tiger Data - Creators of TimescaleDB, a Postgres extension that brings true BM25 relevance ranking into the database. BM25 is the algorithm behind Elasticsearch, Lucene, and most modern search engines. Now it runs natively in Postgres. Here's what pg_textsearch enables: - True BM25 ranking with configurable parameters (the same algorithm powering production search systems) - Simple SQL syntax: `ORDER BY content 'search terms'` - Works with Postgres text search configurations for multiple languages - Pairs naturally with pgvector for hybrid keyword + semantic search That last point matters a lot for RAG apps. The video below shows this in action, and I worked with the team to put this together. You can now do hybrid retrieval (combining keyword matching with vector similarity) in a single database, without stitching together multiple systems. The syntax is clean enough that you can add relevance-ranked search to existing queries in minutes. pg_textsearch is fully open-source under the PostgreSQL license. You can find a link to their GitHub repo in the next tweet.

Big moment for Postgres! Search has always been Postgres' weak spot, and everyone just accepted it. If you needed a real relevance-ranked keyword search, the default answer was to spin up Elasticsearch or add Algolia and deal with the data sync headaches forever. The problem isn't that Postgres can't do text search. It can. But the built-in `ts_rank` function uses a basic term frequency algorithm that doesn't come close to what modern search engines deliver. So teams end up: - Running a separate Elasticsearch cluster just for search - Building sync pipelines that inevitably drift out of consistency - Paying for managed search services that charge per query - Accepting mediocre search relevance because "good enough" ships faster But this is actually a solvable problem. You can realistically bring industry-standard search ranking directly into Postgres, which eliminates the need for external infra entirely. This exact solution is now available with the newly open-sourced pg_textsearch by Tiger Data - Creators of TimescaleDB, a Postgres extension that brings true BM25 relevance ranking into the database. BM25 is the algorithm behind Elasticsearch, Lucene, and most modern search engines. Now it runs natively in Postgres. Here's what pg_textsearch enables: - True BM25 ranking with configurable parameters (the same algorithm powering production search systems) - Simple SQL syntax: `ORDER BY content 'search terms'` - Works with Postgres text search configurations for multiple languages - Pairs naturally with pgvector for hybrid keyword + semantic search That last point matters a lot for RAG apps. The video below shows this in action, and I worked with the team to put this together. You can now do hybrid retrieval (combining keyword matching with vector similarity) in a single database, without stitching together multiple systems. The syntax is clean enough that you can add relevance-ranked search to existing queries in minutes. pg_textsearch is fully open-source under the PostgreSQL license. You can find a link to their GitHub repo in the next tweet.

Akshay 🚀

215,868 次观看 • 9 个月前

>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 次观看 • 8 个月前

🐰: 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 次观看 • 4 个月前