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."
"PostgreSQL is very powerful, easy to manage, and has many features."
"It is very simple to manage."
"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."
"I like that you can move any relational database from Oracle to PostgreSQL. I also like that it's pretty stable."
"It has completely met our needs. It works, and it is robust. We haven't had any problems with what PostgreSQL does for us and the way it does it. That's why we've been using it for so long. We understand it, and it does the job."
"Postgres has some functions called JSONB aggregators or other aggregators, which are quite useful."
"Scalable, stable, and easy to manage database system, with a straightforward installation."
"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."
"I think Chroma doesn't have a ready-made containerized image available."
"They need to have a better graphical interface. There is a tool called pgAdmin 4 that they use, which is free. It is written in Java, and it is slow. They need to have a better product that is similar to Toad for Oracle, but, of course, it is hard to get something that's really great and free. Other than that, it is great."
"It would be great if the solution offered even more integration capabilities."
"PostgreSQL could improve by being more user-friendly. In SQL Server they have a studio where you can easily do management but not in this solution."
"The pricing could be better."
"If it was free to use, it would be the perfect solution."
"There are some products out there that have a slightly different method of implementation for the SQL language. Some of those are slightly better in some areas, and PostgreSQL is slightly better in some areas. I would probably like to match all of those products together. It is just down to the functionality. For example, Oracle has a number of options within SQL that are outside of what you would class as the SQL standard. PostgreSQL misses some of those, but PostgreSQL does other things that are better than what Oracle does. I would like to merge those two products so that there is a certain amount of functionality in a single product."
"A better graphic user-interface would be nice to see."
"There could be a plugin to distribute the data on servers for the product."
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.