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

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

На главную

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

56,099 просмотров • 2 месяцев назад •via X (Twitter)

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

Нет доступных комментариев

Здесь появятся комментарии из оригинального поста

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

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

Build AI agents on a time-aware knowledge graph! Utopia is an open-source knowledge system that turns documents, databases, and connected sources into a temporal graph your agents can reason over. Most RAG systems are optimized for one question: what is relevant right now? That works until the underlying knowledge changes. A customer contract gets updated. A project owner changes. A policy is revised. A previous fact may no longer be true, but simply overwriting it means the system loses the history behind that change. Utopia handles this with a bitemporal knowledge graph. Each fact can track both when it was true in the real world and when the system learned about it. When something changes, the old fact is preserved instead of silently disappearing. That means an agent can reason about questions like: • What is true now? • What was true three months ago? • When did this information change? • What evidence was the conclusion based on? The graph is also ontology-aware, so documents are represented as entities, facts, and relationships instead of only chunks and embeddings. That gives the system more structure for reasoning across relationships, resolving entities, detecting conflicting facts, and deriving new information through explicit rules. Key capabilities: • Bitemporal knowledge graph for tracking how facts change over time • Provenance on facts so agents can trace where information came from • Conflict detection instead of silently overwriting contradictory information • Ontology-based reasoning across entities, relationships, and derived facts • Hybrid retrieval across full-text search, vector search, and graph traversal • MCP and agentic RAG support for exposing the knowledge layer directly to agents The interesting part is that this turns the knowledge base into more than a retrieval system. Instead of only finding relevant information, an agent can reason over what changed, what is still valid, how facts are connected, and where each conclusion came from. 100% open source. I've shared the GitHub repo in the comments!

Sumanth

16,653 просмотров • 1 месяц назад

you can legally steal any viral ugc, rewrite it for your product, and generate it with AI UGC. people are generating photorealistic AI actors that hold real products in their hands and reading scripts that convert like real UGC. Vodafone already ran a full TikTok campaign with AI influencers. same engagement, same conversions, fraction of the cost here's the ugc system anyone can run today: - find a product that hits an emotional pain point (aging skin, insecurity, frustration). one retinol serum video has 8M views and 300k likes with comments begging for the link - download the viral video, transcribe it with Gemini, then feed the transcript + your product + your audience into Claude. it spits out 3 scripts that sound like a friend talking, not an ad - build your actor in any ai ugc platform: filter by age, location, accessories, or generate one from a prompt. nano banana places your exact product in her hand with real lighting and shadows - create two versions of the same actor. no product for the problem hook, product in hand for the solution. that switch is what makes it feel like a real story - use the scenes feature to generate actual application footage: fingertips dabbing serum, circular motions, natural hand movement. not just a talking head - a UGC creator charges $200 to $600 for this exact video. it takes 2 minutes and you can make 10 variations tomorrow the brands winning right now aren't the ones with the biggest budgets. they're the ones testing fastest. reply "ugc" + RT and i'll send you the full video so you can build this too.

Sulfur

17,708 просмотров • 3 месяцев назад

Claude Code + Nano Banana 2 is f*cking cracked for advertorials 🤯 One prompt → a complete presell page with editorial copy, AI product photography, testimonials, and pricing — ready to paste into Shopify. Built 100% in Claude Code. Perfect for DTC brands and agencies running advertorials on Meta who need 5-10 different pages per month but can't keep paying $1,500 each. If you're briefing copywriters, waiting days for a draft, giving notes, waiting again, and still only getting one or two new pages per month... This system eliminates the entire loop: → Enter your brand, product, target customer, and unique mechanism → Pick a style preset (clinical editorial, news exposé, lifestyle magazine, warm and trustworthy) → Claude writes the full page — urgency banner to guarantee to final CTA → Nano Banana 2 generates product images and mechanism diagrams inline → Get back a complete HTML page following the same DR structure that's already scaling on Meta No copywriter back-and-forth. No designing from scratch. No starting from a blank page every time. What you get: → A production-ready HTML advertorial page you paste into Shopify → DR copy structure extracted from real pages scaling on Meta right now → AI-generated product photography and diagrams matched to your brand → 4 style presets that shift tone, colors, and authority framing per niche → A fully customizable system prompt — swap in your own templates and it follows those instead I built 3 complete advertorial pages for 3 different brands in under 5 minutes. Skincare, supplements, and pet products. All different styles, all production-ready. I put together a full playbook with the exact system prompt so you can get this running yourself. Want access for free? > Like this post > Comment "CLAUDE" And I'll send it over (must be following so I can DM)

Mike Futia

34,457 просмотров • 7 месяцев назад

girl humanoids are one dock away from brand deals ngl the question is not “can a girl humanoid make UGC” it is “how much of the creator is still a human on the other side of the dock” → what “forcing” her to shoot actually looks like right now the honest stack is not a free soul with a ring light it is cameras already on the face a soft body that can hold a bottle walk a kitchen and hit a mark plus teleop when the take needs a human wrist behind the curtain mount a phone script the shelf have her pick the product face the light pour the drink set it down you get lifestyle UGC without booking a girl for four hours and a parking spot neo-class home units already see the room through stereo eyes they already learn chores as motion UGC is just choreography with a caption and a brand brief on top → what she can do for real unboxings that stay in frame skincare shelves coffee counters laundry folds “day in my life” walks through a staged apartment hands-on demos where IP68 fingers rinse a glass and the soft suit sells the vibe what she cannot do yet without you taste timing jokes knowing which take feels expensive catching the weird brand-safety face mid-sentence true creator taste still lives in teleop chat and the edit → the quiet part brands care about nobody booked talent nobody flew a creator the ad still can ship if the dock operator hits the brief disclosure still matters “robot / AI-assisted” is not optional forever once the comments clock the gait battery is a shoot day clock 2 to 4 hours soft home duty then she is back on the charger like any tired creator soft suit still photographs like a girl the dock still photographs like the real producer → my take yes you can make her shoot UGC not by yelling “be viral” by treating her like a camera body with legs a script and a remote soul one dock one brief one soft walk through the kitchen and suddenly the brand deal does not need another booking link the creator economy did not die it just got a body that charges overnight so back

Luella

17,610 просмотров • 1 месяц назад