Video wird geladen...

Video konnte nicht geladen werden

Zur Startseite

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

55,524 Aufrufe • vor 23 Tagen •via X (Twitter)

0 Kommentare

Keine Kommentare verfügbar

Kommentare vom Original-Post werden hier angezeigt

Ähnliche Videos

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

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

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

Jeff Bezos just described AI in three words that make most of the economy temporary. Bezos: “AI is real and it is going to change every industry. In fact it’s a very unusual technology in that regard in that it’s a horizontal enabling layer.” Horizontal enabling layer. Not a product. Not a platform. Not a feature. A layer. Underneath everything. Everyone is asking which AI company wins. Bezos is telling you that is the wrong question entirely. A horizontal layer does not produce winners. It produces a new floor. Everything standing on the old one either gets rebuilt or gets erased. This has happened exactly twice in modern history. Electricity. The internet. Both times the same pattern. The new layer appeared. The old economy kept running above it. Revenue held. Careers continued. Everything looked normal. Then quietly and permanently the entire structure reorganized around the new substrate. The people who did not move were not outcompeted. They were made structurally irrelevant. Not because they were wrong. Because the ground they stood on stopped being ground. Bezos is telling you it is happening a third time. Not with a product. Not with a platform. With intelligence itself becoming infrastructure. A horizontal layer does not compete with the expert. It makes expertise free. It hands a 22 year old with zero credentials the same cognitive output you spent a decade and a quarter million dollars learning to produce. For $20 a month. That is not disruption. Disruption replaces a product with a better product. This dissolves the scarcity your entire career was priced on. Not because the work disappeared. Because the wall around it did. Every profession that exists because knowledge is hard to acquire. Every company that profits because analysis takes time. Every industry that survives because complexity locks outsiders out. All of it rests on a single assumption. That cognition is scarce. AI does not challenge that assumption. It retires it. The people who understand this are already rebuilding. Quietly. Deliberately. While everyone else argues about whether the thing underneath them is real. Bezos did not give you a prediction. He gave you a position on a map. You are either above the new layer or beneath it.

Dustin

104,086 Aufrufe • vor 1 Monat

I just built a Claude skill that writes 20 Meta ad hooks in 60 seconds 🤯 Give it your product, your audience, and your best-performing angles → it writes hooks across 10 proven frameworks, each one targeted at a specific customer pain point. All inside Claude Cowork. Perfect for DTC brands and agencies who are still writing hooks from scratch every time they need new creative — staring at a blank doc, scrolling competitors for inspiration, and recycling the same 3 angles because you ran out of ideas two weeks ago. If you're launching Meta Ads and your hook writing process looks like this — open a Google Doc, try to remember what worked last time, write 5 hooks that all sound the same, run them, 4 flop, go back to the doc, repeat ... This skill replaces the entire process: → You give it your product name, key benefits, and target customer → It writes hooks across 10 frameworks: problem-solution, curiosity gap, bold claim, social proof, before/after, us vs them, question, contrarian, urgency, and storytelling → Each hook targets a specific pain point — not generic "Shop now" copy → Generates 2 variations per framework so you have options to test → Outputs everything organized by framework with notes on when to use each one → Takes about 60 seconds No blank page. No recycling the same 3 angles. No writing 5 hooks that all sound like the same ad. What you get: → 20 hooks across 10 proven frameworks, ready to drop into your ads → Each hook written for a specific customer pain point, not a generic audience → Framework labels so you know which hook type you're testing → A reusable skill — run it for every new product, every new campaign, every new angle sprint → Works from a product brief — no API connection, no CSV export, no setup beyond installing the skill One product brief. 20 hooks. 60 seconds. I put together the full skill file plus a playbook showing how to install it, customize the frameworks, and run your first hook sprint. Want it for free? > Like this post > Comment "HOOKS" And I'll send it over (must be following so I can DM)

Mike Futia

17,007 Aufrufe • vor 4 Monaten

Claude Code + ChatGPT Images 2.0 is f*cking cracked 🤯 I rebuilt my static ad system inside Claude Code on the new ChatGPT Images 2.0 model. One brand name + one URL = 40 production-ready static ads. All inside Claude Code. Perfect for DTC brands and agencies who need high-volume ad creative without briefing a designer or spending hours in Canva. If you're finding winning ad concepts on Meta and manually recreating them one at a time — copying prompts, pasting product details, tweaking aspect ratios, downloading, organizing... This system eliminates the entire loop: → Give Claude a brand name and URL → It researches the brand's fonts, colors, packaging, and photography style → Builds a Brand DNA document from scratch → Fills in 40 proven ad templates (headline, us vs them, testimonial, UGC, review cards, stat callouts) with brand-specific details → Fires every prompt to ChatGPT Images 2.0 with your product photos as reference → Downloads finished ads into organized folders with an HTML gallery No manual prompt filling. No Canva templates. No copy-pasting between tools. What you get: → 40 ad formats filled with your exact brand colors, fonts, and copy → Text that actually renders correctly (the new model handles dense copy, logos, and multi-language callouts cleanly) → Product photos passed as reference so the model matches your real packaging → A reusable system — new brand, new folder, same pipeline Built 100% in Claude Code with ChatGPT Images 2.0. I put together a DIY playbook showing the exact architecture so you can build this yourself in Claude Code. Want it for free? > Like this post > Comment "CHAT" And I'll send it over (must be following @learnwithella so I can DM)

Ismail Khan

19,829 Aufrufe • vor 3 Monaten

Claude Code + ChatGPT Images 2.0 is f*cking cracked 🤯 I rebuilt my static ad system inside Claude Code on the new ChatGPT Images 2.0 model. One brand name + one URL = 40 production-ready static ads. All inside Claude Code. Perfect for DTC brands and agencies who need high-volume ad creative without briefing a designer or spending hours in Canva. If you're finding winning ad concepts on Meta and manually recreating them one at a time — copying prompts, pasting product details, tweaking aspect ratios, downloading, organizing... This system eliminates the entire loop: → Give Claude a brand name and URL → It researches the brand's fonts, colors, packaging, and photography style → Builds a Brand DNA document from scratch → Fills in 40 proven ad templates (headline, us vs them, testimonial, UGC, review cards, stat callouts) with brand-specific details → Fires every prompt to ChatGPT Images 2.0 with your product photos as reference → Downloads finished ads into organized folders with an HTML gallery No manual prompt filling. No Canva templates. No copy-pasting between tools. What you get: → 40 ad formats filled with your exact brand colors, fonts, and copy → Text that actually renders correctly (the new model handles dense copy, logos, and multi-language callouts cleanly) → Product photos passed as reference so the model matches your real packaging → A reusable system — new brand, new folder, same pipeline Built 100% in Claude Code with ChatGPT Images 2.0. I put together a DIY playbook showing the exact architecture so you can build this yourself in Claude Code. Want it for free? > Like this post > Comment "CHAT" And I'll send it over (must be following so I can DM)

Mike Futia

189,607 Aufrufe • vor 4 Monaten

There’s a reason the LimeWire name still hits people instantly. If you were around in the early internet days, LimeWire was everywhere. Music discovery, file sharing, chaos, excitement. It shaped how a whole generation interacted with the web. That kind of brand memory doesn’t fade and LimeWire is proving it can be reused in a serious way. What’s different now is the foundation. LimeWire Network is the decentralized storage layer of LimeWire, built on BNB Chain. It is not a nostalgia project. It is infrastructure. Storage, transfers, and usage are happening on chain, designed to scale for real applications rather than demos. The growth backs that up. Looking at recent data on lmwrscan, LimeWire Network has already moved into tens of terabytes of stored data, with tens of thousands of uploads and consistent daily activity. Network usage keeps climbing, not spiking once and disappearing. That kind of curve usually shows real users, not incentive farming. And the economics are clear. The $LMWR token sits at the center of the system. Users pay in LMWR to use storage. Node operators earn LMWR for providing resources. Rewards and payments stay inside the ecosystem instead of leaking out to third parties. That loop matters. Most decentralized storage networks struggle because nobody knows they exist. LimeWire doesn’t have that problem. The brand alone opens doors, pulls attention, and lowers the friction for new users to try the product. When you combine that with live usage data and a functioning token economy, the upside starts to look asymmetric. Built on BNB Chain, LimeWire Network also gets the scalability needed if adoption keeps accelerating. That choice signals intent to grow, not just experiment. This feels like a rare case where nostalgia is not the product, it is the distribution layer. Curious how you see it. Are you watching LimeWire because of the brand comeback, the LimeWire Network growth, or the role of the LMWR token in the long run?

ryu 龙

25,416 Aufrufe • vor 6 Monaten