Wow! Thank you for sharing this. I am bookmarking this article for future use!
( Truth be told, I did not fully understand everything but hopefully future me would )
I haven't yet written a "formal launch post" of the CatBench Postgres/pgvector app that I used for examples in the current article, but all the source code and install instructions are already available here:
Reminds of that article about Postgres for everything: https://github.com/Olshansk/postgres_for_everything