Qdrant: Vector Database for the next generation of AI applications
github.com
github.com
My overall impression of Qdrant is that it's clean and uncluttered compared to other options, development is very open, and the devs are technically very capable. The docs are clear and to the point, without a bunch of extra nonsense getting in the way. It's also easy to try out for free via their hosted cloud.
Which is better for you might come down to Go versus Rust, and also whether you want something that feels more like a complete solution (Weaviate), or something that is more focused (Qdrant).
Simple is better and offline is better, which is why SQLite and DuckDB reign supreme.
So, no Pinecone is not a very good DB from what I can tell.