PostgreSQL Primary Use Case

Chethan Rao S - PeerSpot reviewer
Software Engineer at Medflix

In my current company, we use a wide array of databases, like, Cassandra, Elasticsearch, MongoDB, and Postgres. But here, We specifically use Postgres for transactional purposes.

Since, NoSQL database does not have any, like, transactional-based things. It is called asset property. Since SQL databases possess these asset properties, we primarily rely on SQL, particularly Postgres, due to its superior indexing and performance advantages given our scale.

View full review »
KS
Senior Analyst Applications, Projects and Processes at ADVA Optical Networking Israel LTD.

We use PostgreSQL in our company for test systems.

View full review »
Ahmed-Ramy - PeerSpot reviewer
CEO at TMentors

For us, we have the same use cases as MySQL for this product.

View full review »
Buyer's Guide
Open Source Databases
March 2024
Find out what your peers are saying about PostgreSQL, Firebird, MariaDB and others in Open Source Databases. Updated: March 2024.
765,386 professionals have used our research since 2012.
Moises Nájar - PeerSpot reviewer
Executive Director at Extware Consulting

I am using PostgreSQL to develop a general ledger system. The solution is on-premise right now, but it's going to be on the cloud soon.

View full review »
Albert Lacerda - PeerSpot reviewer
Managing partner at Dynamis Informatica

We have a use case for the solution which was related to a website that we developed for a Spanish energy line transmission company. The company used to face a lot of legal issues in Brazil. We had created a SaaS product that helped them to monitor the Brazilian legal parameters. The company had used the product only for two years and then discontinued it.

The company also faced many internal problems where they had to urge the lawyers to get used to the SaaS products. The lawyers wanted to input information into another system and this is where we used PostgreSQL.

View full review »
NP
System Architect at a university with 1,001-5,000 employees

We deploy our databases in either a local cloud or AWS. For the locally deployed database, we have our own private cloud consisting of a couple of different data centers that we partner with. For everything else, we use Oracle or Microsoft SQL. On the Microsoft SQL side, that's not usually software as a service. It's generally done as a local installation on a virtual machine. If we're doing a deployment on an AWS environment, we use the AWS Postgres database. It's slightly different than doing the installation yourself. So if you're doing the PostgreSQL installation on a Linux environment, that's usually when we're using that directly from postgresql.org. 

View full review »
PB
System Architect at a computer software company with 10,001+ employees

We use it in new team architectures, microservices architectures, and databases that are relatively small.

We also use it for table data, public web pages, some server applications that require data persistence, and some backend modules.

View full review »
Ashif  Shaikh - PeerSpot reviewer
Senior Database Administrator at a tech services company with 501-1,000 employees

We are using it as a database to store information.

View full review »
DE
System/Security Engineer at a tech services company with 10,001+ employees

We use it for inventory control.

View full review »
AM
Global Data Architecture and Data Science Director at FH

I have used it in the past for some web applications and back-end databases. In my current organization, we are using Microsoft SQL Server.

View full review »
Faustine Chisasa - PeerSpot reviewer
System Administrator at TZ Telecom Ltd.

I use PostgreSQL on-premises to store monitoring data collected by  Zabbix Server.

I wanted a database engine that could handle an ingress of a thousand real-time values per second, delete old items without affecting performance, and handle hundreds of user queries at all times.

The solution had to support high compression and time series data while maintaining data integrity and performance.

I wanted the database engine to be easy to tune, secure, and set up.

PostgreSQL matched those requirements and has regular updates and plenty of official and community support resources.

View full review »
NK
Senior IT Manager at Excelra

Typically, our team runs the database and then the applications, on Postgres. However, I'm not part of the development process.

View full review »
KA
Chief technical officer at a healthcare company with 51-200 employees

The database for the accounting systems is our primary use case for this solution. Business software is 80% of my use case in the accounting software. It's a good tool for planning. I work with financial data and the data mining aspect is very important, as I need to access the data easily. The data is the most important thing. Sometimes the software developers forget this part because they just want to save the data on the database, but they don't know how to manipulate the data. The performance of the solution is dependant on how easily and quickly you can obtain access to the data.

View full review »
MR
Senior Database Administrator Engineer at a comms service provider with 10,001+ employees

One use case is that we installed it and built it for a customer so that he has access to the database, and he can create whatever he would like to create on it. 

We have deployed it on-premises and in the cloud.

View full review »
PG
Subdirector - Digital Products and Services at a media company with 501-1,000 employees

We use the solution for media purposes. We manage the sites of one of the largest sports business papers and multiple TV channels. So, we develop the websites.

View full review »
Data Analytics and Business Intelligence Manager at a computer software company with 201-500 employees

The database is used for our customers' products. We also offer some products on our POC system, and our customer's POC systems post some data stored on PostgreSQL on the cloud. Our company's data doesn't store at PostgreSQL. We still have our system MS SQL and Oracle.

View full review »
MS
Head of Technical Support at a real estate/law firm with 51-200 employees

We use it for processing files mostly. It integrates basically with the SQL Server. On the server-side it uses the SQL Server, then from the files that are generated from SQL Server we do have an application running using Microsoft, and we attach it to a Postgres server. We do is for the backups there from time to time.

View full review »
SJ
Director Of Sales Marketing at a energy/utilities company with 10,001+ employees

We are using PostgreSQL for databases.

View full review »
SP
IT Systems Administrator at a transportation company with 51-200 employees

We use it as a backend for some vendor-supplied tools and products. We also do a certain amount of software development, and we use it as the database platform behind our own software.

We have a number of deployments, and the version number very much depends on the vendor software requirements. We have on-premises and cloud deployments.

View full review »
DI
Lead Technical Instructor at codehub

We use the solution to conduct surveys and consider this approach to be one which is cheaper for us. 

View full review »
MA
Senior DBA & IT Consultant at MA Consulting

Any relational databases that you have in Oracle, you can move to PostgreSQL. This is what we have been doing at the moment. 

View full review »
EK
Sr Lead Data & Information Architect at a pharma/biotech company with 5,001-10,000 employees

The solution is quite a good database for light applications for sure. This is how we are using it - as a front-end application and the canned database of PostgreSQL. The use case is comparable to Oracle, with quite a wide range of usage.

View full review »
HP
Computer engineering student at a educational organization with 501-1,000 employees

The solution is primarily used to develop the databases for your application. I used it personally for a college assignment.

View full review »
JT
Software Developer at a healthcare company with 1-10 employees

Currently, I'm doing a lot of source applications with Ruby on Rails, React, and mobile applications. PostgreSQL is my preferred database over MySQL. It's open-source and licenses are free, so it is excellent. The SQL queries are almost the same as MySQL.

View full review »
RU
Senior Solutions Architect at a manufacturing company with 51-200 employees

We use this solution for the back-end database.

View full review »
KV
Data Architect at ACPAS Loan Management Software

I have implemented costing models. I use it to capture item costs and then do calculations to compare costs.

View full review »
AA
Projects Manager at Emery Investments

Our primary use case for PostgreSQL is data storage. 

View full review »
FA
IT Assistant at Hotel 2 Fevrier

We use it to convert the databases. We also use it to make a request from my PMS with the Oracle-based server through the third-party interface.

We use this solution for the interface between our property management system and the cloud-based system. It works from both sides.

View full review »
SS
Software Engineer at a computer software company with 10,001+ employees

We use PostgreSQL as a database, e.g. it's where we install the application. We also use it for all types of batch processing, and it also has the batch sequencing engine. We use it for everything, e.g. everything's right there in the database.

View full review »
Ruben Conti - PeerSpot reviewer
Owner at Intersoftware sas

We use PostgreSQL as a database for our ERP system.

View full review »
PA
Project Manager at a comms service provider with 201-500 employees

We use this solution as part of our backend to store data that is coming from the sensors. 

It is needed to save the meter data from the sensors.

View full review »
JP
Principal Engineer at a manufacturing company with 201-500 employees

We design it and put it as part of our system and sell the system to various airports. We've designed our own schemas, and we track events that are meaningful to airports so that they can create their reports, view statistics, and make meaningful decisions that make sense for them.

View full review »
LW
IT Innovation & Strategy | Real Estate Strategy, Asset Management & Enabling Functions | GSUS at a comms service provider with 10,001+ employees

We use it as an intermediary database for the collection of a variety of data points out of our data systems.

There are many departments that have different data, single points of truth. We asked them to give us different datasets, and we accumulated them in our Postgres-stored database.

It's an intermediary for a machine learning model.

View full review »
RS
Head Channel and Capacity at a computer software company with 201-500 employees

We deployed the Postgre database on CentOS, which is a version of Linux. We have experimented with our replication and other operations. It works perfectly well. We are using the open-source version and do not plan on using any enterprise database.

View full review »
RP
IT Specialist at a government with 1,001-5,000 employees

We use the solution for database management and storage.

View full review »
VR
Full Stack Developer at a tech services company with 10,001+ employees

I am using the solution for data analytics, mainly for ERP because we use Hadoop and Hadoop is a dependency of PostgreSQL through the platform.

View full review »
RM
Director at a tech services company with 1-10 employees

We primarily use the solution for management. We have a managed ERP solution, however, it's all in-house.

View full review »
DR
Implementation Engineer at aldaris spa

I am using it to gain knowledge of the product, as I am an implementation engineer. Some clients are public organizations, migrating from Oracle to PostgreSQL.

View full review »
it_user677721 - PeerSpot reviewer
Information Technology Technician at a tech vendor with 51-200 employees

We use PostgreSQL for most part of our mission critical applications.

The solution has a very robust backup and recovery integration, and has good ANSI SQL language.

View full review »
Buyer's Guide
Open Source Databases
March 2024
Find out what your peers are saying about PostgreSQL, Firebird, MariaDB and others in Open Source Databases. Updated: March 2024.
765,386 professionals have used our research since 2012.