April 27, 2020
Score 10 out of 10
Read Javier Blanque's full review
Pros and Cons
- It is an excellent DBMS, which is scalable, performs well, allows replication, supports ACID and a big subset of the SQL standard (in several cases, it is a superset).
- Is much better at data types than the other DBMSs, with a more rich semantics, with geo-spatial types, complex numbers, etc.
- It supports several methods of indexation, including B-trees, Genetic Algorithms based indexes, and GIN indexes that accelerates full-text searches.
- Its flexibility to select from a variety of procedural languages to make stored procedures is astonishing.
- The performance of PostgreSQL has been enhanced through the years, but always is better to have as much performance as we can.
- The replication services could be done directly within the database, and more easily.
- The Object Orientation of the Database could be extended, and albeit it manages inheritance of tables, and accepts XML and JSON as primary types, it would be wonderful if one could attach methods more easily to tables (to make them more like classes), and instances (rows for example).