
Pinecone is great for super simple vector storage, and with the new serverless option the choice is really a no-brainer. I've been using them for over a year now in production, and their Sparse-Dense offering made a huge impact on the quality of retrieval (domain-heavy lexicon). The tutorials and content on site are both extremely well-thought out and presented, and the one or two times I reached out to support they cleared up my misunderstandings in a courteous and quick manner. But seriously, with serverless now, I'm able to offer insane features to users that were cost-prohibitive before. Review collected by and hosted on G2.com.
I can tell you what used to be challenging: which was cost monitoring and the web interface, both issues which have been drastically improved in the recent months. The web interface is still a bit cumbersome to use, but that's only because vector storage/search is not what you would expect coming from other "content" management systems. There isn't a lot of hand-holding like you might find elsewhere, but really—if you're in this space, you do have to do a lot of work on your own anyways. Hard to find something to dislike when it "just works." Review collected by and hosted on G2.com.