Everytime I see pinecone I'm immediately put off by it since it's so heavily focused on "use the cloud" and "make an account".
I don't want another account, I don't want to have to be connected to the internet, and I don't even really want multiple files to be generated on disk.
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.
I agree -- I listened to a 2022 podcast interview with the cofounder of Pinecone and he seems very dismissive of what open source can bring to vector database. I found that annoying and off putting. The open source vector database ecosystem is really impressive right now!
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.