Wir helfen Unternehmen seit 17 Jahren,
bessere Software zu finden
PostgreSQL
Was ist PostgreSQL?
Kostenloses Open-Source postrelationales Datenbanksystem, das auf allen gängigen Betriebssystemen läuft. PostgreSQLs 25-jährige Entwicklungsgeschichte bietet eine breite Palette von Funktionen für Entwickler und DBAs, in einem robusten Software-Server geliefert und weltweit eingesetzt. PostgreSQL wird von DBEngine in den Top-5-Datenbanken eingestuft, somit höher als die meisten kommerziellen Systeme. Mit Millionen von Installationen in integrierten-Systemen, großen Cloud-Anbietern und bedeutenden Vor-Ort-Installationen, ist PostgreSQL die beliebteste Wahl für neue App-Entwicklung.
Wer verwendet PostgreSQL?
Alle Branchen, alle Sektoren, alle Länder
Du bist nicht sicher, ob PostgreSQL das Richtige ist?
Mit einer beliebten Alternative vergleichen
PostgreSQL
Weitere gute Alternativen zu PostgreSQL
Bewertungen über PostgreSQL
In Betracht gezogene Alternativen:
PostgreSQL - A World Class DBMS that you can have for free
Kommentare: I have used PostgreSQL for Windows since 2008 and it has been a pleasure. Some DBs have tables with more than 1 million records and performance seems not to be affected.
Vorteile:
It is free although there are some paid options that include support and special configurations. It is very stable, I have not had any critical situations like data loss. As a ASP.NET developer, it integrates easy using ADO.NET Data Providers for which there are many choices. Concurrency control is included which is very useful for data integrity. Versions for Linux, Mac, Solaris and BSD are available which increases the integration power. A huge number of third party add-ons (paid and free) can be found. PostgreSQL is being continuously improving, there is a well defined plan of maintenance and new versions are coming out regularly.
Nachteile:
I have not found anything against this DMBS product. I have accomplished all of my goals successfully.
In Betracht gezogene Alternativen:
The Reliable Workhorse with Infinite Flexibility
Kommentare: Nothing short of exceptional. It covers all the bases with its reliability and performance, and its flexibility is unmatched. I've found it difficult to recommend any other database unless you have specific requirements, such as a document store or a graph database. Postgres fills in all the gaps and has become my go-to choice for any project that requires a rock-solid, flexible relational database.
Vorteile:
does the basics like a pro while offering infinite flexibility. From JSON columns to full-text search, there's a plugin for every need. Plus, it plays nicely with every ORM known to man. Postgres has mastered the art of doing the basics exceptionally well. It's reliable, performant, and stands strong as a relational database. But what sets it apart is the remarkable flexibility it offers. Need to store and query JSON data? No problem. Looking for full-text search capabilities? Postgres has your back with plugins that can handle it all. This database truly adapts to your evolving needs, making it a versatile choice for any project.
Nachteile:
No Issues at All, Just Vendor Restrictions. Now, I have to dig deep to find something negative about Postgres. The truth is, I haven't encountered any issues with Postgres itself. Its robustness and stability have been flawless in my experience. If I had to point a finger, it would be at the vendors (like Heroku) who occasionally restrict certain plugins. But hey, that's not Postgres's fault—it's still a champ in its own right.
Relational database with less capability
Kommentare: It is used when a commercial partner vendor introduces a commercial system and creates a small-scale system. If you connect multiple units, it is easy to use with a response that can support the operation without installing a dedicated server machine. When using packaged software in a large-scale system, there may be restrictions on the number of data elements and the number of servers connected, but we were able to reduce installation and operation costs. I was able to keep the cost of the database low and spend money on packaged software options.
Vorteile:
Since it was developed to comply with SQL standards, there are no problems migrating from other RDBMS. I think the popularity of MySQL as an RDBMS is split in two, but PostgreSQL does not have the following MySQL keylogging problem, so it can be said that it is an RDBMS with little custom. We recommend PostgreSQL as the first choice for RDBMS unless otherwise specified because it works stably and can support real operations. When a small business is a customer's system project, the RDBMS license fee is often too high to pay. In such cases, customers will be happy to propose PostgreSQL, which is stable, reliable, and free to use. Unless it is a situation that requires a paid database, I think PostgreSQL is sufficient. It is not inferior to the function.
Nachteile:
When you are looking for something you want to look up in a manual, it is often difficult to find it and, in the end, you often consult blog articles written by experts instead of the manual. I want the structure of the manual to be easy to understand.
In Betracht gezogene Alternativen:
One of the best overall databases in the market
Kommentare: For overall backend database purposes I would currently not choose anything other than PostgreSQL. Widely known, easy to hire talent for, secure and reliable.
Vorteile:
PostgreSQL is well supported by backend frameworks like Django. Getting into the command line of PostgreSQL database isn't necessary that often, but when a must, it works very robustly.
Nachteile:
Not suitable for some data types as well as some of the competition, like time series data, that is becoming more and more important via IoT use cases.
In Betracht gezogene Alternativen:
PSQL databse.
Kommentare: Overall this is good software to use when you in a large applications.
Vorteile:
This is one of the best database software I’ve used. It has a lot of features/functions that are usable for Big projects. One of them I've use is the PSQL vector search that is not widely used but very important feature that built in PSQL, beside that it has a tons of usable functions to do operations inside database and then get the result for example timezone adjusting, manipulation with data, string function and etc.
Nachteile:
Trully telling there should be few cons in this software. I've used this for over 4 years sometimes find to difficult to configure it it linux environments compared with mysql.
