Tiger Data, the creators of TimescaleDB, today announced that its open-source BM25 search engine, pg_textsearch, is now supported natively in Google Cloud’s AlloyDB and Cloud SQL for PostgreSQL ...

A native BM25 index in AlloyDB and Cloud SQL provides full-text retrieval without having to provision, manage, or pay for separate systems.

I already have a solution for this, but it's not elegant. I'm curious if other people have "cleaner" solutions. My goal is less to make this specific problem better, but more to find a nicer way to ...

When dealing with massive quantities of data, top-k queries are a powerful technique for returning only the k most relevant tuples for inspection, based on a scoring function. The problem of ...

A common SQL habit is to use SELECT * on a query, because it’s tedious to list all the columns you need. Plus, sometimes those columns may change over time, so why not just do things the easy way? But ...

AI has transformed the way companies work and interact with data. A few years ago, teams had to write SQL queries and code to extract useful information from large swathes of data. Today, all they ...