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 feedbackshow more

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 appshow more

Every single upgrade in the SCAR Next Gen came... from real user feedback. Here's to you: the community that made it happen. This product is available exclusively to U.S. commercial customers.show more

This is how long it takes to load data... from your Prisma Postgres Postgres DB using Accelerate Stay tuned, video drops tomorrow!show more

Need a temporary production-grade Postgres DB to quickly test... something? 🚀 Run `npx create-db@latest` and get a connection string, no login needed! Bonus: You can keep the DB beyond 24 hours if you need it, just claim it 😉 👉show more

Tripo P1.0 is live. Introducing Smart Mesh in Tripo... Studio — generate structured 3D meshes in ~2 seconds. ⚡ ~2s generation 🧠 Smart topology 🛠 Production-ready assets 🌍 Built for game pipelines, real-time rendering, web 3D tools, and scalable content production From prompt to usable mesh — almost instantly. Try it: #3DAI #3DCG #3dart #Triposhow more

Nolan McLean is asked about holding the lowest ERA... through six starts in Mets franchise history: "I'm not a huge stat guy. I try to just go out there and give my team the best chance to win every single time."show more

The new UI is officially ready for testing! ✅... Available now on Android 🍎 Coming soon to iOS We’d love to hear your feedback. Try it out and let us know what you think!show more

Reanimated 4.2.0 is here, and it brings gifts! 🔥... 🎁 Long-awaited Shared Element Transitions 🎉 Not production-ready yet, so they’re behind a feature flag. Please, test it out and give us feedback! 🎁 Experimental performance fixes, inspired by real apps. 🎁 Other improvements like: string values introduced to useAnimatedStyle to animate transform & filter. Read our blog below for more details, test the SETs out, and let us know what you think! 👇show more

First try with Vercel's new Postgres database! Was so... quick to set up 🤯 here I've got a collaborative form built with Liveblocks, and I'm having it automatically sync data to the database. More info 🧵show more

Insane 1,000 hours of team work we put into... this new Neon Postgres home page (Design, Development, Motion). Do you like it? Every single graphic designed fully in Figma. Interactive animations made in Rive. Stay tuned for behind-the-scenes design stories.show more

ad agencies are in serious trouble it generates studio... level product ad with one click.. you can use 8 reference image to keep character, product, outfit, bg and any props consistent on Invideo here's how to do it:show more

Draining the pool and refilling it every single time... you use it is optimal (we get a kickback from the water company for making these)show more

bolt․new can create beautiful, production ready multi-page apps with... backends and DBs like @Supabase. ...and deploy them to prod, in one click. That's because every chat can run a prod build & deploy it to Netlify (and Cloudflare 🔜) — no login required: 🤯show more

Today, we are open sourcing the KittyCAD Modeling App... (KCMA) a hybrid CAD modeling app that combines traditional point-and-click and code modeling. This is an alpha release and we would love for you to try it out and give us feedback!show more

🧪 In Testing Grounds you can tweak your operator's... armor and speed! Give it a try this weekend and share your feedback using the QR code in-game 📱 🎟️AVAILABLE ON ALL PLATFORMS🎟️show more

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

Talking with someone the other day that estimated they... had about 25,000 idle connections to Postgres. My actual response to them: "holy shit". They double checked, it was only about 12,000 Same day had a conversation with someone saying they didn't need pgbouncer because of activerecord's connection pooling. Let's dig into connection pooling in Postgres. Prior to Postgres 14 every connection to the database consumed memory, roughly 10MB, it may be slightly less but it still wasn't free. Even beyond Postgres 14 there is still various contention that happens when Postgres starts to use a connection. An application pooler maintains a set of connections and hands them out when needed on the application side. These are idle and real connections against the database that indeed do impact performance negatively. In contrast pgbouncer speaks the wire protocol, waits for the begin part of the transaction and then uses a connection. It more strictly manages how many idle ones it's having instead of per web server you're running. pgbouncer up until recently really needed to be run in transaction mode (which meant disabling prepared statements in your application framework). prepared_statement support in pgbouncer was added recently, and now you don't have to disable. Even when running with an older version of pgbouncer with prepared_statements disabled you'd still see a big performance gain. A quick check to know if you'd benefit from pgbouncer, run this query: SELECT count(*), state FROM pg_stat_activity GROUP BY 2; If you're idle account is high (yes this is dependent on your view, but to me if it's above 25-30 range, and especially if active is until half that) then you'd already start to benefit from pgbouncer. If it's at 10,000 then post haste get pgbouncer in place. Finally, you don't have to not use a framework pooler, they're fine, but don't think it replaces a native Postgres connection pooler.show more