Wednesday, 23 February 2022 15:30

8 Most Important features of PostgreSQL

Written by

PostgreSQL is one of the most widely used relational database management systems today. It is object oriented, it is multisystem, so you can use it on any operating system and under a free license.

It has been developed since 1996 by a community of developers (not a company or foundation) based on DBMS POSGRES, which emerged (like many other technologies) from a US military research project (DARPA, ARO) with civilian participation.

The choice of a database management system is usually an afterthought when starting a new project, especially on the Web. Most frameworks come with some object-relational mapping tool (ORM) which more or less hides the differences between the different platforms and makes them all equally slow. Using the default option (MySQL in most cases) is rarely wrong, but it’s worth considering. Don’t fall into the trap of familiarity and comfort – a good developer must always make informed decisions among the different options, their benefits and drawbacks.