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.
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.
It is easy to use.
It could be more secure.
I have been working with PostgreSQL for approximately two years.
I am using the latest version.
PostgreSQL is a stable solution.
We use this solution for organization's applications at the backend and it is not used directly by the end-users.
I have not contacted technical support.
It is a bit different from Oracle, with respect to security.
The initial setup is straightforward.
It was a token installation, I can do it myself.
I would recommend PostgreSQL to others who are interested in using this solution.
I would rate PostgresSQL a seven out of ten.
We use the solution for database management and storage.
The most valuable feature is the performance.
The solution could improve the integration.
I have been using this solution for approximately four years.
I have found the solution to be stable.
PostgreSQL is a scalable solution. However, it could be better.
I have not needed to use the support.
The installation is not simple, it is more difficult than DeviceSQL. We had a few issues during the installation.
I did the implementation of this solution myself and it was more complex than MySQL.
I have evaluated MySQL and DeviceSQL.
I would recommend this solution to others.
I rate PostgreSQL an eight out of ten.
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.
It is very simple to manage.
It is easy to use.
My main concern is that I can use it to connect with the interface. It is simple, it's good.
It needs more integration.
I have been using this solution for two years.
I have not explored the scalability of this solution yet.
I will continue to use this solution but I don't have any plans to increase our usage.
I have not contacted technical support.
The initial setup is straightforward. It was easy to install.
It took only one day to install, and two to three days to connect with the database.
We have a team of three, two admins, and one engineer to maintain the solution.
We had help from a company from Norway, one from South Africa, and one other from Dubai.
We do not pay for licensing.
Depending on the type of work the user wants to do with the interface I would recommend this solution or not.
I would rate PostgreSQL a five out of ten.
The solution is primarily used to develop the databases for your application. I used it personally for a college assignment.
The solution is open-source and therefore free to use.
You can do the same actions as you can with the SQL Server.
It's a standard reliable database management system.
The solution comes with an option to work in dark mode, which I appreciate.
The interface could be much better. Maybe it took a little bit longer to understand the menu options and so on. On top of that, it's a web interface. It makes it uninteresting to look at. It's not so appealing as the options that Microsoft offers. It's a separate program that works separately and you don't mess with the browser. It works okay, you can do what you need to do, however, it's not, in my opinion, so professional-looking. That said, it's open-source so I can understand that they prefer to do it like that.
The installation process could be better organized.
The stability could be better. they release new versions all the time and they aren't quite as stable as we'd like them to be.
We've only used the solution for a few months. We used it for two projects. It was basically used across two semesters. We have used it in the past year.
The solution is not as stable in comparison to Microsoft SQL Server. I had some issues with a version, and I had to re-install it last year. Now, however, it's working fine. That said, they are always launching new updates and they seem to release them too early as they are not so stable.
I'm not sure if I will continue to use the solution. I used it for an assignment, and that's it.
I did not contact technical support. I've never reached out to them directly. Therefore, I can't speak to how helpful or responsive they are.
I've also worked with Microsoft SQL, and I find the product to be much more stable.
The initial setup could be a bit better. They have some improvements to do especially with regards to the additional tools they propose. That part is just a little bit messy. Other than that, I thought it was very easy to install it. It's not overly complex.
I was able to handle the implementation myself. I did not need the help of a consultant or integrator.
The solution doesn't cost anything to use. It's open-source.
I'd rate the solution at an eight out of ten. I'm mostly happy with its capabilities.
I wouldn't necessarily recommend this product for beginners.
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.
We are able to create many different types of jobs and items with this solution making it one of the most valuable features.
The solution needs to improve the query, documentation, and JSON data functionality.
I have been using the solution for two years.
I think the technical support should improve for this solution.
I have previously used MySQL and am currently using it for other projects. MySQL is a little easier to use.
The installation is more difficult to install than other solutions I have used.
I rate PostgreSQL a seven out of ten.
The solution has many valuable features such as it easy to use and the interface is intuitive.
Instead of the installation agent downloading all the packages for the install, it should allow the user to download the packages separately on their own to do the install.
In a future release, the installation agent should take less time to create all the databases, especially the small Oracle databases that I was using.
I have been using the solution for a couple of months.
I have found the solution to be stable.
I have not fully tested the scalability but it has been good enough for what I have been using it for.
I did not experience any technical issues to call the support about.
The installation was easy even though it took approximately four hours. The time accumulated from downloading automatic packages from the VM tunnel. You have to download the whole package on your machine.
The solution requires a license.
I recommend this solution for small organizations.
I rate PostgreSQL a seven out of ten.
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.
It has completely met our needs. It works, and it is robust. We haven't had any problems with what PostgreSQL does for us and the way it does it. That's why we've been using it for so long. We understand it, and it does the job.
When you get a large number of records in a database and start doing various queries, it can adversely impact the performance of the live running systems. That's an area we continue to look at and mean to improve, but it is not only because of PostgreSQL. It is also because of the way the schemas are put together, and certain events are triggered. So, it is because of both parties.
I have been using this solution for 18 years.
It is pretty straightforward.
I would rate PostgreSQL an eight out of ten.
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.
I am more of a fan of doing things straight out of Python, but with the size of the data sets, we were forced to do it in SQL.
What I like is that it's quite powerful in terms of performance.
Part of the reason we use this solution is because of its simplicity and because it works. It does all of the basic things it's supposed to do and it's not anything fancy.
They are fulfilling their customer's needs.
I had some issues when I integrated with the Jupyter Notebook.
In the system administration, if you open the connection to the database with a notebook, there is no automatic closing of this connection.
I would like to see seamless integration with other tools such as Jupyter Notebook. We use it with Anaconda.
Also, possibly more streamline integration with more programming languages. An API for some different languages such as MARGO and JavaScript could be interesting.
I have been using PostgreSQL for one year.
I had an issue where we couldn't find the fault, and it happened on occasion at the end of the day. Some of my basic queries would stop running.
I had some queries run for two days and some run for a day, then I would have to try it again the next day and it would complete in 20 seconds. Sometimes, it seemed to catch itself.
I haven't had any contact with technical support from PostgresSQL. I do my research using Google.
I did not initialize this database, but from what I understand it's very basic. It was simple to do.
I would prefer programming languages to query languages. Scripting, for instance.
If you have a relational database then you want to use PostgresSQL. I would recommend this solution to others who are interested in using it.
It's suitable for everything we use. There was nothing exceptional from my perspective, but it did everything we needed it to do.
I would rate this solution an eight out of ten.