PostgreSQL Previous Solutions

Ahmed-Ramy - PeerSpot reviewer
CEO at TMentors

We also have used MySQL.

View full review »
Moises Nájar - PeerSpot reviewer
Executive Director at Extware Consulting

I was previously using Microsoft SQL Server and MySQL.

With MySQL, I had once a terrible problem with a group that was only giving me the first record of a group. I had to implement it through other means for the solution to give me the result that I was required.

View full review »
SE
Software developer at MTNIrancell

I have used MySQL.

View full review »
Buyer's Guide
PostgreSQL
April 2024
Learn what your peers think about PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,740 professionals have used our research since 2012.
PB
System Architect at a computer software company with 10,001+ employees

I am also using Oracle.

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

We have been working with Microsoft SQL.

The main difference between SQL and Postgre is that Postgre is open source. It's completely free.

View full review »
it_user448206 - PeerSpot reviewer
Senior Application Programmer/Analyst, Team Lead at a university with 10,001+ employees

Initially applications at my current employer used Microsoft SQL Server. The cost for licensing/maintaining windows systems was more than we liked. PostgreSQL has offered similar performance for our workloads with lower cost. 

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

We used Oracle. We're currently in the process of migrating from Oracle to Postgres, and we're doing it because of cost.

Postgres is a superior product, and it is free. Oracle's support is really terrible, so you're not really getting any support from Oracle.

View full review »
it_user442602 - PeerSpot reviewer
Sr. Database Engineer at a non-tech company with 5,001-10,000 employees

See my answer above. We evaluated both open-source as well as proprietary solutions. Of the open-source solutions we examined, Postgres has the best track record for innovation and enhancements. While the user base is smaller than some of the more established solutions, the fact that it has been able to avoid being “acquired” by a major player is, in my opinion, a plus.

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

We used to provide service to various clients, and we were also providing internal services. We used different solutions in parallel, such as Amazon Redshift, MySQL. MySQL is also free. I have also used Oracle and IBM Db2 in other organizations.

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

I used other database management systems (MySQL and its variant MariaDB) for my NMS applications before moving to PostgreSQL. I had some optimization issues on MySQL and MariaDB and decided to switch to PostgreSQL, mainly for the TimescaleDB extension support provided on PostgreSQL and which my application natively support including automatic database partitioning and compression. TimescaleDB proved to be helpful since I mostly deal with time series data and the TimescaleDB hypertables improved my applications perfomance greatly.

View full review »
NK
Senior IT Manager at Excelra

We've used a few other products previously. We're also using MongoDB, or at least, we will be, in an application that we've just started.

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

I am also using Oracle Database. The main difference is the scalability. PostgreSQL could be used for small to medium databases but not for a huge production database. I still prefer to have Oracle Database.

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

I don't recall us using a different product.

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

We did not previously use other products. 

I've also used Oracle and Microsoft SQL. This product is free and more robust than Oracle, however, Microsoft SQL might be easier to use.

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

I have used MariaDB and Oracle MySQL.

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

We were using Sybase. We've actually transitioned most of it over to PostgreSQL.

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

We used Oracle before switching to PostgreSQL.

View full review »
it_user456468 - PeerSpot reviewer
Senior DB Engineer at a university with 1,001-5,000 employees

We used Sentinel which was awesome but it did not provide metric views.

View full review »
it_user457146 - PeerSpot reviewer
Co-Founder, CTO at a computer software company with 51-200 employees

I've also used MySQL and MongoDB, but neither of those technologies provide any competitive advantage over PostgreSQL in any respect that comes to mind.

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

We also use Oracle Database. I would say the two are quite comparable.

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

I've also worked with Microsoft SQL, and I find the product to be much more stable.

View full review »
it_user86943 - PeerSpot reviewer
Senior Developer with 501-1,000 employees

I started with this product.

View full review »
it_user234651 - PeerSpot reviewer
Senior Software Engineer, Technical Lead at a tech services company with 51-200 employees

I've used a larger set of databases (including the most well-known and a few more exotic) and setups. Definitively PostgreSQL is a serious contender at the top of the list. I chose it because it's fast, reliable, rich in functionality, and it has no commercial costs for its acquisition.

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

I was previously working in a research organization, which favored open source. I have also used Oracle, Sybase, Microsoft SQL Server, and Ingres databases.

View full review »
it_user383829 - PeerSpot reviewer
Founder and Business Intelligence Consultant at Know Solutions

We had some problems with bigger customers using MySQL so we moved to PostgreSQL.

View full review »
it_user130935 - PeerSpot reviewer
President with 51-200 employees

We used Oracle, MySQL, Microsoft SQL Server. Oracle and Microsoft SQL Server were simply too expensive for smaller customers. MySQL had too many short comings to make it a workable solution.

View full review »
LR
Analista Funcional Líder at a government with 5,001-10,000 employees

I have used other solutions for over 20 years and the problem of licensing has been our biggest drawback because of the costs and dependence we require from the provider.

View full review »
it_user457224 - PeerSpot reviewer
Partner - PostgreSQL support manager at a tech company with 51-200 employees

I have more than 10 years of DBA experience, working with Oracle, DB2 and MySQL too. All of them have pluses and minuses, and I usually need to explain that nobody can claim "X is better to Y", at least with the universe limited to world-class RDBMS like PostgreSQL, Oracle, DB2 and MySQL. Of course, certain scenarios can mean that one RDBMS is better positioned than another to handle.

View full review »
it_user493518 - PeerSpot reviewer
Director of Operations / Senior Software Engineer at a computer software company with 51-200 employees

We had used Microsoft SQL Server in our previous company. But, the licensing terms kept getting more and more onerous. We started looking at PostgreSQL from the reviews and recommendations, especially since it was open source and Amazon RDS started supporting it.

View full review »
it_user457197 - PeerSpot reviewer
Senior PostgreSQL Database Adminstrator at a financial services firm with 51-200 employees

I have used MySQL, another open source product now controlled by Oracle. It’s reasonably fast and OK for simple databases, but it lacks transactional isolation and its replication setup does not enforce a true master/slave configuration.

View full review »
it_user67833 - PeerSpot reviewer
Software Engineer at a tech vendor with 11-50 employees

I used MySQL and Oracle previously, PostgreSQL is open source and fully ACID and SQL standard

View full review »
it_user434985 - PeerSpot reviewer
Sr. Database Architect at a tech vendor with 501-1,000 employees

I used to be an Oracle DBA over decade ago. I have used over dozen of database solutions ranging from MySQL to MongoDB in the distributed production environments but Postgres provides superior features but not limited to; extendibility, performance, scalability, analytics queries.

View full review »
it_user271512 - PeerSpot reviewer
Manager at a tech services company with 51-200 employees

We have been using Oracle software, and in some cases MS SQL server. The price difference between the used products and PostgreSQL was one of the issues. The second was the ease of installation and the availability on different platforms.

View full review »
DM
Developer at a comms service provider with 51-200 employees

Up to that point, we used MySQL. The decision to change came with a new version being written from scratch, and PostgreSQL being better suited for our needs.

View full review »
it_user140712 - PeerSpot reviewer
Consultant at a tech consulting company

We previously used MySQL. PostgreSQL tries to solve things in the correct way for all platforms, all file systems, and all users. In the end, this means you get a better working and more stable system. They try to stay away from hacks and other non-portable or limited solutions and prefer to work inside the system. For example, an operating system already does many optimizations so why would one want to reinvent things with raw file systems, etc. like Oracle tried to do in the past?

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

It is a bit different from Oracle, with respect to security.

View full review »
it_user252288 - PeerSpot reviewer
Software architect at a tech services company with 51-200 employees

We are using PostgreSQL for new installations and new versions of our solutions where it's possible, and the customer does not require a specific SQL server. Nowadays it's covering all of our needs.

View full review »
it_user127413 - PeerSpot reviewer
Director GIS/Analytics/IT at a non-profit with 501-1,000 employees

We use both MySQL & PostgreSQL, some applications have better compatibility or built in tools, this decides which database we use.

View full review »
it_user306153 - PeerSpot reviewer
Senior Programmer at a tech services company with 51-200 employees

I used other solutions in other companies I've worked for before. When I arrived at my current company they were already using PostgreSQL.

View full review »
it_user298746 - PeerSpot reviewer
NOC Manager with 51-200 employees

We use Microsoft SQL (all versions), MySQL, PostgreSQL, SQLite, etc. We use PostgreSQL when the application supports it and where it makes more economic sense to use it.

View full review »
it_user241635 - PeerSpot reviewer
DevOps Engineer at a transportation company with 51-200 employees

I have worked with MySQL and Oracle solutions. Against MySQL, performance is the big difference. PostgreSQL is far more robust and mature than MySQL, especially when you think about keys and indexes. Against other databases, such as Oracle, the easy installation steps of PostgreSQL is the best difference for me.

View full review »
it_user184266 - PeerSpot reviewer
Database Expert at a tech services company with 51-200 employees

We initially only used an Oracle database, but we decided to add PostgreSQL as an option because of its similarity to Oracle. Also, it's free and is the best open source database.

View full review »
Sundaresan Subramanyan - PeerSpot reviewer
Founder and Managing Director at Analytic Brains Technologies Private Limited

We previously used Microsoft SQL.

View full review »
it_user437376 - PeerSpot reviewer
PostgreSQL Database Administrator at a tech services company with 51-200 employees

I don't use any similar solutions such as Microsoft SQL, Oracle, or MySQL.

View full review »
it_user315483 - PeerSpot reviewer
Programador - Analista at a program development consultancy with 501-1,000 employees

I used MySQL, but for safety and consistency issues, I moved to PostgreSQL

View full review »
it_user308454 - PeerSpot reviewer
Sysadmin at a tech services company with 51-200 employees

I use MySQL, MariaDB, and Oracle. I chose PostgreSQL or others depending of the project. For Java implementations I prefer PostgreSQL, and for PHP development, I prefer MySQL or MariaDB,

View full review »
it_user203334 - PeerSpot reviewer
Technical Lead with 1,001-5,000 employees

No other solution was used.

View full review »
it_user246798 - PeerSpot reviewer
Director of Client Integration at a financial services firm with 51-200 employees

We were using version 8 before, and also an earlier Oracle instance. We chose the product because it is powerful, well documented, and open source.

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

I have previously used MySQL and am currently using it for other projects. MySQL is a little easier to use.

View full review »
it_user457314 - PeerSpot reviewer
Sr. Oracle and PostgreSQL DBA at a consumer goods company with 1,001-5,000 employees

We haven't used any other open-source service, but we have engaged Enterprise DB for enhancing our monitoring but there was no need to do so.

View full review »
it_user210627 - PeerSpot reviewer
Computer Science Teacher at a educational organization with 501-1,000 employees

Since Oracle was expensive for a company business an inexpensive way was to focus on PostgreSQL.

View full review »
it_user234753 - PeerSpot reviewer
Team Lead ETL at a tech services company with 51-200 employees

I have worked with MySQL, Microsoft SQL, db2, and Oracle. We chose PostgreSQL for its JSON support as our APIs are sending JSON responses and PostgreSQL is like home for JSON. Choosing it has helped our cloud computing requirements a lot.

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

The company used a Microsoft SQL Server previously. I don't know what the reasons were for changing, however, due to the fact that, when I arrived at the business, they already had Postgre.

View full review »
it_user514974 - PeerSpot reviewer
CTO at a tech vendor with 51-200 employees

We had several performance issues with MySQL.

View full review »
it_user212502 - PeerSpot reviewer
Technical Account Manager with 1,001-5,000 employees

We've got experience with a number of RDBMS, but PostgreSQL has always stuck out to be the most economical and sensible product. That being said, we do have instances of Maria, and various NoSQL's floating around.

View full review »
it_user268431 - PeerSpot reviewer
Specialist of Information Security at a transportation company with 1,001-5,000 employees

In my last company, we had been using Access. We changed to PostgreSQL as we needed something more robust and usable. This was provided by PostgreSQL which at the time was the perfect solution for what we needed.

View full review »
it_user389811 - PeerSpot reviewer
Co-Founder, Technical Manager, Consultant at a hospitality company with 51-200 employees

I used MySQL. PostgreSQL syntax is much clearer and consistent, and its stored procedures are powerful and fast. The documentation is also much better and of more help.

View full review »
it_user219786 - PeerSpot reviewer
Founding Partner at a tech vendor with 1-10 employees

I used MySQL, but I needed support for full text search. PostgreSQL adds this, and also many more advanced SQL functions.

View full review »
it_user389220 - PeerSpot reviewer
CEO - Software Engineer at a tech services company with 51-200 employees

MySQL but not in the same scale.

View full review »
it_user373887 - PeerSpot reviewer
Senior Software Engineer at a tech services company with 51-200 employees

We tried RethinkDB a couple of years back, and it was unstable at that time. Also, MySQL didn't have a JSON type back then. We switched to PostgreSQL and never looked back.

View full review »
it_user439254 - PeerSpot reviewer
Expert Web Developer at a tech vendor with 501-1,000 employees

I used MySQL. I switched because at that time, because some things were complicated with MySQL. For example: scaling, sparse data JSON, and other issues.

Both projects have the same query syntax, and the transition for me was almost painless.

View full review »
it_user220542 - PeerSpot reviewer
Database Engineer at a financial services firm with 1,001-5,000 employees

We switched due to a common OS integration strategy.

View full review »
it_user145641 - PeerSpot reviewer
Business Analyst at a transportation company with 1,001-5,000 employees
MySQL: scalability; Oracle: cost-benefit View full review »
it_user89940 - PeerSpot reviewer
Database Expert with 201-500 employees
I worked for years on Oracle. I decided to move on PostgreSQL because I think is a first class product. View full review »
it_user677721 - PeerSpot reviewer
Information Technology Technician at a tech vendor with 51-200 employees

We switch to this solution due to its stability and that it is open source.

View full review »
it_user434967 - PeerSpot reviewer
Staff System Admin at a tech company with 5,001-10,000 employees

Yes, we evaluated other solutions, and we are moving away from PostgreSQL after the evaluation period.

View full review »
it_user417285 - PeerSpot reviewer
Senior Production Support Engineer at a tech company with 501-1,000 employees

I switched as I needed to increase the volume of data.

View full review »
Buyer's Guide
PostgreSQL
April 2024
Learn what your peers think about PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,740 professionals have used our research since 2012.