Postgres as a search engine

Build a hybrid search engine with semantic, full-text, and fuzzy search – all within Postgres

tl;dr

• Postgres + pgvector for simplified embedding storage
• Colocate data for easy querying and consistency
• Fast and cost-effective solution
• Knowledge graphs in Postgres
• Hybrid search is tricky but possible

How Postgres stores data on disk – this one's a page turner

One thing I wish I had understood better earlier on in my experience with PostgreSQL is how transactions and locks can be used together to provide serializable logic. 

Top Postgres GUI Clients to Master Postgres☄️ 

Postgres Full Text Search is better than ... 

In a previous article, I introduced what is new in SQL:2023. Now I want to show the status of SQL:2023 support in PostgreSQL. See the previous article for details on these features. 

152 psql Tips — This was originally 100 tips when we first included it, but this list of bite-sized tips for the tried and tested psql client continues to grow. If you have a psql session coming up any time soon, this is worth a browse. It’s also possible to load a single tip and hop through randomly if you prefer your tips snack-sized. 

The Most Popular Databases - 2006/2020 - Statistics and Data 

Why Uber Engineering Switched from Postgres to MySQL