2020-11-06T07:13:00Z

What is your primary use case for PostgreSQL?


How do you or your organization use this solution?

Please share with us so that your peers can learn from your experiences.

Thank you!

Guest
1313 Answers

author avatar
Top 5LeaderboardReal User

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

2021-05-19T14:16:03Z
author avatar
Top 5Real User

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.

2021-03-05T03:06:13Z
author avatar
Top 5LeaderboardReal User

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.

2021-03-03T21:38:03Z
author avatar
Top 20Real User

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.

2021-02-14T14:42:23Z
author avatar
Top 5LeaderboardReal User

I use PostgreSQL on-premises to store monitoring data collected by the 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 requests 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 has regular updates and plenty of official and community resources.

2021-02-04T21:04:00Z
author avatar
Top 5LeaderboardReal User

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

2021-01-23T14:46:33Z
author avatar
Top 20Real User

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.

2021-01-13T22:09:33Z
author avatar
Top 5Real User

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.

2020-12-27T09:14:05Z
author avatar
Top 20Real User

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.

2020-12-12T18:23:00Z
author avatar
Top 10Real User

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.

2020-12-07T17:50:00Z
author avatar
Top 10Real User

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

2020-11-26T08:52:22Z
author avatar
Top 5LeaderboardReal User

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.

2020-11-25T20:46:48Z
author avatar
Top 10Real User

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.

2020-11-06T07:13:00Z
Learn what your peers think about PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: May 2021.
509,641 professionals have used our research since 2012.