For the past few months, I've been working on teaching AI coding tools to write better Postgres code. It's a passion project born from frustration.

I’ve been thinking about why LLMs are bad at text-to-sql. Short answer: no context 🧵 Compared to developers, LLMs are more handicapped without context: - They can’t read the application code. - They can’t ask around. - They don’t know where the docs are.

I wish people would analyze benchmarks with this kind of depth and insight more often.

Alexander Reelsen@spinscale.bsky.social · last yr.

An analysis of Search Benchmark, the Game Adrien decided to run an own blog. This shares an overview over a well known search benchmark maintained by the fine folks at Tantivy and breaks down different benchmarks and their implementations & tradeoffs.

🚫 Stop treating embedding generation like ETL. ✅ It’s indexing. One of the most common misconceptions in the world of AI and LLMs: 👉 Vector embedding generation = ETL. Nope. It’s much more like building an index. Conceptually, it's just like creating a full-text index on your data.

🐘PGAI VECTORIZER NOW WORKS WITH ANY POSTGRES DATABASE (incl Timescale Cloud, Amazon RDS, Supabase, Azure PostgreSQL, and more) www.timescale.com/blog/pgai-ve...

Pgai Vectorizer Now Works With Any Postgres Database

By popular demand, pgai Vectorizer is now a Python library and CLI that works with any self-hosted or managed Postgres database. See how we built it.

timescale.com

Listening to our CTO Michael Freedman talk about the evolution from data lakes (unstructured) and data warehouses (structured) into unified data lakehouses, I had a thought...

𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗗𝗢𝗖𝗨𝗠𝗘𝗡𝗧 𝗘𝗠𝗕𝗘𝗗𝗗𝗜𝗡𝗚𝗦 𝗪𝗜𝗧𝗛 𝗣𝗚𝗔𝗜 𝗩𝗘𝗖𝗧𝗢𝗥𝗜𝗭𝗘𝗥: 𝗣𝗼𝘀𝘁𝗴𝗿𝗲𝘀 + 𝗔𝗺𝗮𝘇𝗼𝗻 𝗦𝟯 We've expanded pgai Vectorizer to automatically create searchable vector embeddings in Postgres from documents stored in S3 while keeping the original files in place.

PGVECTOR VS QDRANT: You don’t need a specialized vector database for large scale. Postgres is all you need.

New database benchmarks for real-time analytics by Timescale. Blog: tsdb.co/benchmark-rta Github: github.com/timescale/rt...

Not All Analytics Are Equal: Benchmarking Databases for Real-Time Analytics Applications

Not all analytics are equal—neither are benchmarks. Meet RTABench and compare different databases—from PostgreSQL to ClickHouse—using real-world query patterns.

timescale.com

We just released a new database analytics benchmark. RTABench is geared to talking about real-time analytic /applications/ (that is how it differs from ClickBench).

Our goal: make working with vector data and LLMs as easy as possible with the developer tool you know and love. 🐍 SQLAlchemy + pgai Vectorizer: Seamless Vector Search in Python 🐍 www.timescale.com/blog/pgai-ve...

Pgai Vectorizer Meets Python: Integrating SQLAlchemy and Alembic

You can now seamlessly integrate pgai Vectorizer and Python using SQLAlchemy and Alembic to automate embedding creation and management. Learn how.

timescale.com

LGBTQIA minors make up 40% of the endangered minor runaway population. They are 120% more likely to be unhoused. They are also uniquely at risk for exploitation and trafficking. This is breathtakingly evil.

Marisa Kabas@marisakabas.bsky.social · 2y ago

New — The National Center for Missing & Exploited Children (NCMEC) was told this week by DOJ that they'd lose their funding if the org didn't remove any mentions of LGBTQIA+ issues from their public materials, I've learned. Staff were told they need to deadname trans kids in their reports to comply.

Vasily Grossman's "The Road" (the story, somewhat confusingly published in "The Road" collection of essays) may be the single best description of depression I've ever seen in writing. Incredibly, it's told from the vantage point of a Mule!

and the core pgai repo is here: github.com/timescale/pgai

GitHub - timescale/pgai: A suite of tools to develop RAG, semantic search, and other AI applications more easily with PostgreSQL

A suite of tools to develop RAG, semantic search, and other AI applications more easily with PostgreSQL - timescale/pgai

github.com

You can now load any @hf.co dataset into PostgreSQL in just 1 line of SQL 🤯 All thanks to the pgai PostgreSQL extension.

Index types for pgvector dense vector types and their pros and cons.

Testing out a theory about Math education: Can you explain why a times b = b times a (a*b=b*a)? If so, what's you explanation? If not, I'd also like to know!

📺 How to evaluate different embedding models on your actual data In this video, Jacky explains a simple (and unsupervised) yet powerful technique to evaluate embedding models using your own data: www.youtube.com/watch?v=VgSF...

OpenAI vs. Open-source Embedding Model Showdown

YouTube video by Timescale

youtube.com

State of PostgreSQL results for 2024 are now live! Find out what's been going on in the community and ecosystem. www.timescale.com/blog/state-o...

A Sneak Peek Into the State of PostgreSQL 2024

The 2024 State of PostgreSQL survey report is out! Read its first findings.

timescale.com

We’ve added support for Voyage AI in pgai Vectorizer, our open-source tool for auto-creating and syncing embeddings in PostgreSQL.

AI doom scenarios often feel a bit off to me—not because they're wrong about AI being risky, but because they imagine the danger as some AGI-built Terminator rising up to enslave humanity. Honestly, the real risks seem a lot more... human.