The most important database feature you hope to never... need: Backups. What Postgres does under the hood is far more interesting than a simple data copy. We're diving deep into the process in our latest article.show more

more important than what you do is the conviction... in what you’re doing $TRUST the process🙏show 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

Why we need more contributing validators in the space... in my latest opinion article in BeInCrypto, I am diving into why I think we should have more validators with public brands and that are actively contributing to the ecosystem that they are securing. this is what we aim to do with Lunar Labs Capital as an contributing validator to leading ecosystemsshow more

Tonight we played with energy, passion and soul. This... early in the process, that is the most important thing I can ask. Travelling Potters, we appreciate you more than you know! 🔴⚪️show more

Have you ever wanted to take your C.A.M.P. Pet... out into the wasteland to travel and fight alongside you? The latest #Fallout76 Public Test Server is live and we're testing our World Pets feature which is planned to release later this year!show more

How do you back up 100TB in the same... time it takes to back up 1TB? Massively parallel backups, powered by sharding.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

❔ A Question for Our Community 👇 What’s more... important in crypto today: speed, security, or simplicity? 🤔 As crypto tools become more advanced, users face a quiet trade-off. Lightning-fast transactions can sacrifice safety. Ultra-secure platforms might overwhelm with complexity. And simple, sleek interfaces? Sometimes they hide the real power under the hood. Each direction shapes how we interact with Web3—how we trade, store, and trust. But if you had to lean into just one today… what truly matters most? Drop your thoughts in the comments! 💬show more

Your liver does more than one hundred functions in... the body, and here is a SIMPLE way to start healing it.show more

Q. what values do you consider most important in... life? 🦌 i think the most important thing is to just give it a try. i think the idea of taking that first step is one of the most important things in life. #EVANshow more

Les images The images coming out of Paris look... more like a civil war than a victory celebration. This is beyond madness. What we're witnessing bears little resemblance to football festivities and far more to scenes of urban unrest. What is the government doing?show more

GPT-4 is the new data scientist 🤯 With the... new OpenAI code interpreter model, you just have to upload the data and provide instructions in simple english. The model does everything from cleaning data to generating insightful visualizations on autopilot!!show more

NEWSMAX: You're going to pursue more charges against Hunter... Biden? COMER: We're going to see what the new Trump Department of Justice wants to do. The most important thing for me is holding people in the government accountable.show more

Lighting in the workshop is important, but the correct... lighting in the right place is more important. So sometimes simple things like closing the door can make a huge difference to those working inside.show more

cursor can now more accurately answer questions about itself... and guide you through various features and capabilities! under the hood, it'll spawn a subagent to fetch the latest docs and updatesshow more

You can now scrape any website by just writing... a prompt. Using 's /extract feature, just describe what you want to get the web data you need. This is ChatGPT for web scraping 🤯show more