We performed a comparison between Chroma and PostgreSQL based on real PeerSpot user reviews.
Find out what your peers are saying about Elastic, Meta, Chroma and others in Vector Databases."The solution's most valuable feature is its documentation, which allows new users to easily learn, deploy, and use it."
"The solution provides complete support in terms of the SQL dialect and behaves nicely when it comes to transactions."
"PostgreSQL is very easy to use. I have experience in Oracle SQL and PostgreSQL uses the same syntax which makes it is easy for me to develop."
"Clustering will be the number 1 feature. It is also open-source so it is free. It can also be clustered, to allow fault tolerance."
"PostgreSQL has complete SQL dialects and is useful for writing sophisticated and complex queries. We have experience with Oracle database. My partner is experienced in DDA and he writes sophisticated SQL queries. The solution helps to get the job done in the best possible way. In today’s age, most developers do not have strong SQL knowledge or language command. They find it difficult to write even a SQL statement. These developers write cool queries which perform badly on the database end. As DBAs, we constantly urge the developers not to write bad queries, help them learn more, and write placebo commands."
"It is easy to install and easy to manage. There is no license on it, so it is free. There is high compatibility with Oracle, and there are many tools for the migration of data from Oracle to Postgre."
"PostgreSQL is very powerful, easy to manage, and has many features."
"The most valuable features are the price, stability, it is scalable and is used by our clients in small business environments, and it is a simple product to use."
"The initial setup is quick and easy."
"I think Chroma doesn't have a ready-made containerized image available."
"It would be great if the solution offered even more integration capabilities."
"Integration with other platforms could be improved."
"We often find the solution's datetime datatype challenging."
"There could be a plugin to distribute the data on servers for the product."
"PostgreSQL’s performance could be improved."
"PostgreSQL uses high memory compared to its counterparts when a highly demanding load is involved, especially one that makes many concurrent connections to the database."
"I had some issues when I integrated with the Jupyter Notebook."
"We have to set up event API, which takes a lot of events from the user."
Earn 20 points
Chroma is ranked 3rd in Vector Databases with 1 review while PostgreSQL is ranked 6th in Vector Databases with 120 reviews. Chroma is rated 8.0, while PostgreSQL is rated 8.6. On the other hand, the top reviewer of PostgreSQL writes " A scalable and stable database for transactional purposes". Chroma is most compared with Faiss, LanceDB, Redis, Milvus and OpenSearch, whereas PostgreSQL is most compared with Firebird SQL, EDB Postgres Advanced Server, MySQL, MariaDB and OpenSearch.
See our list of best Vector Databases vendors.
We monitor all Vector Databases reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.