Looks like an interesting extension for Postgres to do vector similarity searches inside the database.

Yet another article on how you can do search straight in PostgreSQL. This one goes a bit further in how to put the pieces together though.

Interesting proof of concept. I wonder how far this will go. There is definitely a need in any case.

Nice set of tips, I knew a few but not all of them. The discussion around CTEs is interesting.

They were probably using RabbitMQ for the wrong scenario in the first place. That said it's a good reminder that sometimes a simpler architecture is what you want and it can bring benefits.

A sound list of advises, applicable to most database systems of course.

Yet another article about Postgres full test search features. This one has the advantage of giving us a glimpse about the other available options. Sometimes you want something typo resistant for instance.

Interesting tips for potential bottlenecks in your queries.

Interesting exploration and workaround for the Postgres query planner.

A good primer on full-text search features in Postgres. A nice way to get started. This is too often overlooked, you can wait before pulling another dependency like Elasticsearch.

A good example of using the best tool for the job. Having your whole data analysis pipeline in pandas might not be what you want for performance reason. Very often there's a relational database you can leverage first.

Because when things are presented a bit too rosy I get suspicious... it's nice to have such counterpoints to realize PostgreSQL is not perfect which means there are scenarios where you might not want it.