PostgreSQL Other Solutions Considered

NP
System Architect at a university with 1,001-5,000 employees

We use PostgreSQL alongside Microsoft and Oracle solutions. Postgre is suitable for scaling with specific projects. But while it scales very well, Postgre doesn't have the same recovery features as some larger-scale databases. For example, you can run Oracle Databases in a couple of different ways for easy recoverability should the primary database fail. First, you've got a rack for redundancy and load distribution. Second, Oracle has a feature called Data Guard that replicates the database in case it goes down. Data Guard allows you to run a completely different copy of the database that will take our main exports and keep it up to date. So if your primary database has a software or hardware failure, you can bring up the secondary database and re-task your applications to use that database. It's not as simple to do this with Postgres. 

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

We are utilizing the database's active native security features. As a result, we currently have no need for any external security tools. We had, but we worked around it.

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

We evaluated EnterpriseDB (EDB) Postgres, which is a paid product, whereas Postgres is open source. We decided that it was better to go with a free product.

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,578 professionals have used our research since 2012.
Faustine Chisasa - PeerSpot reviewer
System Administrator at TZ Telecom Ltd.

I evaluated other options including MySQL and its variant MariaDB & Percona Server for MySQL, Oracle DB, and SQLite.

View full review »
Hardik  Parashar - PeerSpot reviewer
Associate Data Engineer at Digit Insurance

We're currently looking for a more modern solution to replace Postgre. I'm aware of AWS Redshift, Query, and Nextly. These are major players in the market.

View full review »
it_user457323 - PeerSpot reviewer
Senior Database Engineer at a consumer goods company with 1,001-5,000 employees

I have tried and worked on other solutions such as Oracle and MySQL. I would say that the combination of PostgreSQL's features, plus the reliability and performance it offers in combination with the fact that you don't pay for a license was the reason I chose it.

View full review »
it_user212523 - PeerSpot reviewer
TIBCO Middleware Architect & System Administrator at a tech services company with 1,001-5,000 employees

We evaluated Oracle, MongoDB and CouchBase. Although those seem to be different products, they have some common features that worked for us, we decided to go with PostgreSQL because of its reliability and proven track record.

View full review »
JT
Software Developer at a healthcare company with 1-10 employees

When it comes to pros, I would put MySQL and PostgreSQL in the same class. let's say I'm trying to write to the database and then the power went off. It will still keep the data integral. I don't have duplicated data, and data integrity is intact. With NoSQL databases I have to duplicate queries in case something like this happens I don't know whether my data is going to be integral in cases like a failure situation. PostgreSQL has the rollback function which remains integral. I cannot build a search engine using PostgreSQL, because that would be a very expensive hit on resources. Alternatively, with the ElasticSearch utility, and the use of load balancing, it is very easy to use. Elasticsearch returns substantial results and works in the background. I cannot do that with MySQL or PostgreSQL databases as that's actually a very expensive use of resources.

View full review »
it_user494835 - PeerSpot reviewer
Founder and CEO at Shreeyansh Technologies | The Database Company

PostgreSQL is written in ANCI C, fulfilling all of the ACID properties other proprietary databases support. Most of the customers who use proprietary database solutions to their business applications prefer to move away from proprietary licensed databases to open-source databases to save huge amounts of recurring licensing costs resulting in huge profit margins. Customer choose PostgreSQL for its rich feature list, open source, no recurring software licensing costs, no vendor lock-in and various choices for the best commercial support and community-based support available.

View full review »
RU
Senior Solutions Architect at a manufacturing company with 51-200 employees

I have evaluated SQL Server.

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

For our current use case, I'm evaluating PostgreSQL versus MariaDB. I am probably going to use MariaDB because I need the temporal SQL feature, which is not available in PostgreSQL.

View full review »
DZ
Developer at a tech services company with 11-50 employees

We compared it to MySQL, Oracle and we though PostgreSQL Full Text Search functionality was the best for what we needed.

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

We got carried away by the experience of a team member with experience in PostgreSQL and first we used the tool in applications of low concurrency of users but with storage of files pdf, doc and xls in the tables. We were surprised by the results. This is how we trust in PostgreSQL and we demand more and more. We always get good results. Sometimes we have had to migrate to a new version of PostgreSQL, but have done so without any problem(s).

View full review »
it_user254172 - PeerSpot reviewer
Senior Consultant / Manager Technical Operations at a tech consulting company with 501-1,000 employees

I have evaluated MySQL and Ingres previously and then PostgreSQL. My personal choice is PostgreSQL. I also worked on a migration project from Ingres to Oracle.

View full review »
it_user457251 - PeerSpot reviewer
Data Architect at Blue Treble Solutions

I've used Oracle, DB2, Sybase and MSSQL. The only one that comes close to PostgreSQL is Oracle, and only because of the large set of developer tools it offers. But, it's very difficult to manage and extremely expensive.

View full review »
it_user441456 - PeerSpot reviewer
Senior Database DevOps Engineer at a tech services company with 1,001-5,000 employees

I work with few other RDBMSs, but nothing compares to PostgreSQL when it comes to ACID and SQL compliance, stability and the ease of administration.

View full review »
it_user184266 - PeerSpot reviewer
Database Expert at a tech services company with 51-200 employees
  • MySQL
  • SQL Server
  • Sedna XML
View full review »
RP
IT Specialist at a government with 1,001-5,000 employees

I have evaluated MySQL and DeviceSQL.

View full review »
it_user448368 - PeerSpot reviewer
DBA / ETL Developer / Consultant at a marketing services firm with 1,001-5,000 employees

We tested a big portion of our online API product using SoapUI and it was very fast and efficient.

View full review »
it_user250818 - PeerSpot reviewer
Owner with 51-200 employees

We also looked at MySQL and other databases including open source, standards, compliance, and enterprise features.

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

I've only used online open source resources and would say there's not as much as there is for MySQL. Sometimes it took me some time to find a good solution to the more unusual scenarios

View full review »
it_user219786 - PeerSpot reviewer
Founding Partner at a tech vendor with 1-10 employees
  • MySQL
  • Microsoft SQL Server
View full review »
it_user312354 - PeerSpot reviewer
Software Architect and Senior Technology Consultant at a tech services company with 51-200 employees

I've worked with MySQL, Firebird, etc. and, in my opinion, PostgreSQL is more scalable.

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

I explored many different databases: Redis, MongoDB, MySQL, Elasticsearch, and others.

I use some of them in conjunction with PostgreSQL. However, if we are talking about relational databases, then I only use MySQL.

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

We had an RFP process to evaluate between similar product categories.

View full review »
it_user145641 - PeerSpot reviewer
Business Analyst at a transportation company with 1,001-5,000 employees
Oracle and MSSQLServer View full review »
it_user89940 - PeerSpot reviewer
Database Expert with 201-500 employees
I considered in the past MySQL and Firebird. View full review »
it_user183585 - PeerSpot reviewer
BI Expert at a consultancy with 501-1,000 employees

For me all SQL tools/products are similar, except for a few important differences like GIS functions in PostgreSQL, and programming abilities in Oracle PL/SQL, etc.

View full review »
it_user677721 - PeerSpot reviewer
Information Technology Technician at a tech vendor with 51-200 employees

Yes, we reviewed MongoDB, MariaDB, and 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,578 professionals have used our research since 2012.