Video wird geladen...

Video konnte nicht geladen werden

Zur Startseite

🚀 Launching today: Postgres terminal written in Rust 🦀🐘 One terminal for all your Postgres databases. → Add any database in one command → Monitor health, queries, indexes & activity → Switch between databases instantly → Connect with pgbot for deeper diagnostics → Runs locally Free & open source...

51,465 Aufrufe • vor 1 Tag •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,627 Aufrufe • vor 7 Monaten

Goldman pays $27,000 per seat for a Bloomberg Terminal. I found 10 open source tools on GitHub that replicate almost all of it for free. Retail investors have never had this much firepower. Bookmark & Repost this one: 1. OpenBB Stocks, options, crypto, forex, and macro data in one research platform. Build your own dashboards, reports, and AI analysts on top of it. The OG of open source finance. 50K+ stars. 2. FinceptTerminal A full financial terminal: global market data, advanced charts, economic indicators, portfolio analysis, and AI research tools. Windows, Mac, and Linux. 3. Neuberg 516 drag-and-drop panels covering equities, bonds, commodities, currencies, credit, and macro. Even connects to Alpaca, Hyperliquid, and Polymarket so you can trade from the terminal itself. 4. Qlib (by Microsoft) An open source AI platform for quant investing. Train ML models, discover signals, backtest strategies, and build portfolios with the same workflow a quant desk uses. 5. FinRobot An AI equity research team on your laptop. Its agents read financial statements, build DCF valuations, debate bull vs bear cases, and generate full investment reports. 6. EdgarTools Turns the SEC database into something humans can actually use. Pull 10-Ks, 10-Qs, insider trades, executive pay, and hedge fund holdings going back to 1994. 7. LEAN (by QuantConnect) An institutional-grade engine for trading algorithms. Write strategies in Python or C#, backtest on decades of data, then connect to real brokers and go live. 8. FinanceToolkit 200+ financial ratios, valuation models, risk metrics, and economic indicators. Works on stocks, ETFs, options, currencies, commodities, and crypto from Python. 9. Ghostfolio A private wealth dashboard for stocks, ETFs, and crypto across all your accounts. Performance, allocation, diversification. Your data never leaves your machine. 10. OpenTerminalUI A self-hosted trading terminal: pro charts, screeners, options chains with live Greeks, portfolio optimization, backtesting, and an AI research agent. Runs entirely on your own hardware. Bloomberg spent 40 years building a $27,000/year moat. Open source is draining it one repo at a time. The software is free. Some live data feeds need your own API keys, but the barrier is now effort, not money. If you want the exact workflows we use to stack these tools with AI, join the AIBullss Discord:

AI Bulls

20,605 Aufrufe • vor 28 Tagen