The h-stores are very powerful for handling collections of key-value pairs. The query syntax and functions are well documented and easy to use. The h-stores are very powerful for handling collections of key-value pairs. The query syntax and functions are well documented and easy to use.
PostgreSQL is a powerful and open source database, which is central all data processing.
We'd like to be able to start using JSON objects for easy code representation. This feature is available in v10.4.
I've been using it for eight years.
We've had no issues with the deployment.
There have been no stability issues.
It's been able to scale for our needs.
I use online documentation, which met my needs.
We were using version 8 before, and also an earlier Oracle instance. We chose the product because it is powerful, well documented, and open source.
I did not set up the actual installation. I did set up the schema, tables, foreign keys, etc. That was straightforward in that it was well documented.
In house. You do need someone that knows PostgreSQL or that can spend time learning about the product.
It's open source. ROI is a matter of time.
The challenge with this product would be finding the IT resource that can implement the product.