How do you or your organization use this solution?
Please share with us so that your peers can learn from your experiences.
The solution is primarily used to develop the databases for your application. I used it personally for a college assignment.
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.
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.
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.
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.
I have implemented costing models. I use it to capture item costs and then do calculations to compare costs.
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.
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.
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.
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.
We primarily use the solution for management. We have a managed ERP solution, however, it's all in-house.
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.
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.
We all know it's really hard to get good pricing and cost information.
Please share what you can so you can help your peers.