PostgreSQL ha sido ampliamente adoptado en la industria en los últimos años. Algunas de las compañías líderes a nivel mundial están utilizando PostgreSQL.
Debajo una pequeña lista de organizaciones que la utilizan:
Miles de compañías tienen PostgreSQL para aplicaciones críticas y no críticas
PostgreSQL está presente en todas las industrias. Desde automóviles a agua, de e-commerce a arqueología, PostgreSQL está presente en todos lados y su uso va en aumento.
A continuación algunos ejemplos de usos reales en entornos productivos.
Caso 1: Finanzas
PostgreSQL es muy adecuado para finanzas: es totalmente compatible con ACID y por ello ideal para workloads OLTP (Online Transaction Processing), aunque también es perfectamente integrable con software matemático como Matlab, Python o R.
OLTP, analytics, y Business Intelligence
Caso 2: Datos GIS de gobierno
PostgreSQL is not only a tool for the financial industry – there is also a really powerful GIS extension called «PostGIS» which provides hundreds of functions to process geometric data in various formats. PostGIS is highly standard compliant and is one of the de-facto standards in the Open Source GIS world.
In combination with QGIS or GeoServer the Open Source community provides powerful means to handle geodata. Check out website on PostGIS to find out more about our geodata services.
PostGIS for geometric data
Use case 3: Manufacturing
Many world class industrial manufacturers use PostgreSQL to speed up innovation and to drive growth boost through customer-centric processes, and optimize supply chain performance using PostgreSQL as a storage backend. PostgreSQL is a reliable, long term data stores and offers you reliable storage at low costs.
In industrial manufacturing reliability is everything. If a production site is down due to a failure it can easily cost millions. Therefore PostgreSQL is the ideal choice because it can be configured for automatic failover, full redundancy, and almost zero downtime upgrades.
PostgreSQL has gained a lot of momentum in manufacturing recently because Oracle has changed its license policy in a way that it has become hard for many companies to sustain high license costs.
Automatic failover and zero downtime upgrades
Use case 4: Web technology and NoSQL workloads
Modern websites might require thousands or even hundreds of thousands of requests per second to serve your customers. Scalability can be a major issue and the PostgreSQL community has worked hard to address those scalability questions in the past couple of years.
PostgreSQL is not just a relational database – it can also serve as a NoSQL-style data store. There is no need to choose between the relational and the document oriented world. You can have both in a single product.
Scalable NoSQL workloads with PostgreSQL
Use case 5: Scientific data
Research and scientific projects can generate terabytes of data, which have to be handled in the most beneficial and most efficient way possible. PostgreSQL has wonderful analytical capabilities and offers a powerful SQL engine, which makes processing large amounts of data a real joy.
On top of that PostgreSQL can easily be extended. You can write your own aggregation functions and you can come up with your own business logic in the database. By bringing the algorithms close to your data, a lot more efficiency can be achieved than by performing all operations on the application level.
Contact us today to receive your personal offer from Cybertec. We offer timely delivery, professional handling, and over 17 years of PostgreSQL experience.Contact us