Offers clear structure and reliable transactions but needs improvement in handling scalability
What is our primary use case?
We are working with Spring Boot and everything related to this area, using a couple of modules from Spring Boot such as security, data, and cloud. The most major aspect is that we work with relational database architecture.
For the relational database, I use PostgreSQL on Ubuntu.
I have been using PostgreSQL on Ubuntu for all my commercial experience, which is around six or seven years.
I use a relational database where objects and relations between them are needed, and where there is a specific structure. For example, if we have a parameter for our object, such as a user or an apple, we have specific size, weight, etc. Non-relational database is not about that; it's more about speed, but relational databases are specifically created for this task.
The support for complex data types such as JSON and XML in PostgreSQL on Ubuntu adds technical behavior not related to typical relational databases. I have worked with JSON in PostgreSQL on Ubuntu, and it helps manage non-structured data effectively. You can also add an index for JSON and speed up searches, though it's a complex topic that requires deep knowledge of how indexes work.
What is most valuable?
The best feature of PostgreSQL on Ubuntu is its structure because it adds clarity and understanding when investigating a database. This structure makes it more understandable than non-structural data, which enhances readability and understandability for someone new to the project.
I have utilized the advanced data replication features in PostgreSQL on Ubuntu. It provides a powerful mechanism for transactions, which is a huge achievement for relational databases.
The community around PostgreSQL on Ubuntu is awesome and perfect. Any question or issue can be resolved with quick Googling, and there are many knowledgeable people, which is really beneficial.
What needs improvement?
Asynchronous replication will help in managing data distribution and seeing benefits, but I'm not certain as I have not worked with such tasks in PostgreSQL on Ubuntu. I've resolved similar things in non-SQL databases such as MongoDB, but I haven't attempted those functionalities in PostgreSQL on Ubuntu due to their complexity.
For how long have I used the solution?
I have been using PostgreSQL on Ubuntu for all my commercial experience, which is around six or seven years.
What do I think about the stability of the solution?
The main benefits PostgreSQL on Ubuntu brings are stability and reliability, especially for transactions in companies handling money, which is crucial.
What do I think about the scalability of the solution?
The main disadvantages I see in PostgreSQL on Ubuntu relate to handling scaling. Vertical scale can work sometimes, but as databases grow, resources can become inadequate, leading to the need for complex replication and sharding which not every specialist is aware of.
Which solution did I use previously and why did I switch?
I have worked with other relational databases apart from PostgreSQL on Ubuntu.
How was the initial setup?
In the very beginning of my learning path, I faced some difficulties in setting up PostgreSQL on Ubuntu, but now it's clear how it works. I know all the steps to make it work: creating databases, making users, providing rules, and creating tables.
Which other solutions did I evaluate?
The main differences of PostgreSQL on Ubuntu in comparison to other competitors involve ACID compliance, where non-relational databases have made strides. However, non-relational databases often have sharding available by default, making them more comfortable for dividing information. They also tend to be faster and fit for blob storage, but it's not the best way for storing files, as I prefer dedicated storage solutions such as S3 or Azure Blob Storage.
What other advice do I have?
My advice for organizations considering PostgreSQL on Ubuntu is to thoroughly discuss their project needs, as it depends on their specific requirements. Spending time discussing future goals and project needs is crucial before making any decisions about a database, because changing databases during a project can be difficult and resource-intensive.
The structure and design of the database as it stands are really nice.
I haven't escalated any questions or issues regarding technical support with PostgreSQL on Ubuntu.
I don't remember anything about PostGIS capabilities.
On a scale of 1-10, I rate PostgreSQL on Ubuntu a 7.
Handles high-demand database operations efficiently and offers significant cost savings
What is our primary use case?
We use
PostgreSQL on Ubuntu for storing our data related to high court cases.
What is most valuable?
The best advantage of
PostgreSQL on Ubuntu is its ability to fulfill all our requirements as an
RDBMS. We frequently use various database-related operations such as storing, retrieving, and utilizing views and triggers. Its concurrency and connection handling are very efficient, especially since we have around 1,000 users.
What needs improvement?
We have not faced any errors, and for our purposes, PostgreSQL on Ubuntu is working perfectly. However, integrating AI features for analytical data generation might be beneficial as our processes are increasingly dependent on AI tools.
For how long have I used the solution?
We have been using
PostgreSQL since 2018.
What do I think about the stability of the solution?
I have found PostgreSQL on Ubuntu to be a very stable product.
What do I think about the scalability of the solution?
PostgreSQL on Ubuntu is very scalable with no restrictions.
How are customer service and support?
We have not utilized customer support, as we generally obtain information from publicly available sources.
How would you rate customer service and support?
How was the initial setup?
The initial setup is quite easy to install, with the documentation being very well-organized. We do it ourselves without needing external technical assistance.
What about the implementation team?
We handle the installation ourselves.
What was our ROI?
We find the solution able to make savings of around 10% to 20%, depending on the solution being used.
What's my experience with pricing, setup cost, and licensing?
PostgreSQL on Ubuntu is free of cost. We are not purchasing anything additional.
What other advice do I have?
I would rate PostgreSQL on Ubuntu as a ten out of ten. The only suggestion for improvement is to add AI features.
Which deployment model are you using for this solution?
Hybrid Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Other
