PostgreSQL 사용 후기 및 리뷰

PostgreSQL - A World Class DBMS that you can have for free

주석: 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.

장점:

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.

단점:

I have not found anything against this DMBS product. I have accomplished all of my goals successfully.

Very complete and stable database

주석: I have very good experience installing and configuring databases with PostgreSQL.
Once installed and configured it is very stable, almost without errors and one can rest assured that the data is fine

장점:

It is very complete for any type of project or application. It is stable, easy to use and can handle a lot of structured data. It is free software and is very well documented It is very popular and has a very varied community around the project

단점:

Its installation and configuration can be a bit complex at first. Being free they are not obliged to provide support Requires specific tuning for each possible scenario

Relational database with less capability

주석: 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.

장점:

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.

단점:

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.

The Reliable Workhorse with Infinite Flexibility

주석: 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.

장점:

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.

단점:

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.

One of the best overall databases in the market

주석: For overall backend database purposes I would currently not choose anything other than PostgreSQL. Widely known, easy to hire talent for, secure and reliable.

장점:

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.

단점:

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.

PSQL databse.

주석: Overall this is good software to use when you in a large applications.

장점:

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.

단점:

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.

The database everyone should be using

주석: PostgreSQL is an incredibly powerful piece of software that should be the RDBMS in every software project instead of less powerful but more famous alternatives.
Personally it will be my choice for every future project.

장점:

PostgreSQL is so powerful, complete and stable. This should come with no surprise given the long history behind it. At the same time it's incredibly modern and supports new paradigms (like NoSQL, JSON data types) and it's also very simple to familiarize with.

단점:

It's unbelievable how PostgreSQL is not as well-known as one of his competitors (MySQL) notwithstanding the fact that is so much more powerful.

The best user tailored db experience.

주석: I use PostgreSQL with almost every endeavor nowadays. Both at work and with personal projects, it is very robust when used in my research field which is optimization and operations research, but also flexible enough to help me quickly deploy web apps.

장점:

PostgreSQL is by far the most user friendly and most advanced database system out of the top 5 popular choices. It's inherently relational making it easily compatible with ORMs, has many smaller quirks like jsonb storage, the WITH keyword, and a vast amount of data types. It's also one of the most dynamic DBMS as it releases major changes more than once a year, with an ecosystem that consistently adapts to these versions.

단점:

Extensions in pgsql could use a bit of streamlining (extensions like pg_cron or similar), which was a bit complicated to do in with CI. Another concern would be some stability issues with the latest pgAdmin database interface, but in all fairness that isn't directly an issue with pgsql.

A robust database engine for your web projects and platforms

주석: I have used this database to carry out web projects in the health sector and it has been of great help to manage processes and data in a very efficient way and with the best performance that I have seen.

장점:

What I like most about this database engine is its security, scalability and high performance for the development of platforms and web applications, easy to maintain and manage

단점:

That I did not like the product, its difficult or complex syntax, sometimes the very tedious query error

My Go-To RDBMS

장점:

It is fast, reliable and scalable; the perfect RDBMS in my humble opinion.

단점:

The learning curve, but even that wasn't actually so bad.

Perfect open source relational DB

주석: Overall experience with PostgreSQL is great and it had very little learning curve in moving away from other proprietary DBs.

장점:

This is perfect replacement for any proprietary relational data bases as it provides most of the features from traditional relational DBs. It helps us in data storage and retrieval with good level of flexibility and performance.

단점:

Not much as this is used as free or opensource alternative the performance matches very closely to it's paid competitors. Adding in more GUI support tools could be helpful.

PostgresSQL Review

장점:

PostgreSQL is highly regarded for its robustness, scalability, and reliability, making it the perfect choice for businesses looking for a dependable and secure database. It has a wide array of features such as advanced indexing, support for stored procedures and triggers, as well as a wide array of data types, making it ideal for creating complex applications. It also supports an extensive range of languages and tools, making it easy to use for developers and administrators. Additionally, PostgreSQL has high availability and fault tolerance, making it suitable for mission-critical environments. Furthermore, PostgreSQL can be used in the cloud, making it an ideal solution for businesses looking for a reliable and secure database solution.

단점:

PostgreSQL can be a challenging platform to learn, especially for beginners. Its steep learning curve, complex structure, and lack of user-friendly documentation make it difficult to get started. Furthermore, troubleshooting and debugging can be difficult, causing even more frustration for those just starting out.

"PostgreSQL: A Robust and Reliable Database Solution"

주석: Overall, my experience with PostgreSQL has been positive. It is a robust and reliable database system with advanced features for data management and analysis. The active community and comprehensive documentation make it easy to get started and the software is well-suited for a wide range of applications.

장점:

PostgreSQL is a powerful and flexible open-source relational database management system. It offers high performance, rich SQL support, and advanced data types, such as arrays, hstore, and JSON. It can be used for a wide range of use cases, from small web applications to large enterprise systems. The active community provides a wealth of resources, tutorials, and support, which helps to easily create custom functions and operators. It also allows scalability, which makes it suitable for handling an increasing amount of data and users. Additionally, it supports ACID properties, which ensures data consistency and integrity in the database. Overall, PostgreSQL is an excellent choice for businesses looking for a powerful and flexible relational database management system, it offers great features that make it a great tool for most of use cases.

단점:

PostgreSQL is a powerful and versatile open-source database system that offers many advanced features for data management and analysis. Its robust SQL engine and built-in support for advanced data types make it a great choice for a wide range of applications. While the software can be a bit complex to set up and manage for beginners, the comprehensive documentation and active community make it easy to get started. Overall, I highly recommend PostgreSQL for anyone looking for a reliable and feature-rich database solution.

One of the best database managers for the world.

주석: From my point of view postgreSQL I consider it one of the most powerful database managers, since I use it daily, from my role as a database administrator, as well as a web developer, since it allows to manage environments put into production easily, with an acceptable and intuitive configuration.

장점:

1164/5000 -Easy installation and configuration in other environments. - Pgadmin management interface of the databases, very intuitive and complete with the necessary to a few clicks, I recommend keeping the graphical tool for the stability it offers. -It has a connection balancer, known as pgpool that allows to manage the cluster structure well. -Principles of replication between active-active or active-passive servers Variety of console-level command options for restore or backup tasks and maintenance tasks -principal manager for developers for the scalability and stability it offers. -Management of free access, which allows the use of it without any problem, without any cost -Ideal manager for the management of relational databases -Allows the management of different versions on the same server with multiple database intentions with different listening ports.

단점:

- Poor documentation - Functional technicians commonly report a slowness at the BD level, but that depends on how the DB is structured and especially if good database practices are applied

Great, yet not perfect Rdbms

주석: I will use it as long it is the best in the marke

장점:

It supports a wide range of data types, which makes it a great candidate.

단점:

complex to set up and configure, especially for those new to RDBMS

Postgresql (psql) is a great way to start with "serious" RDBMS

주석: Postrgresql was a DB engine for our retail stores cashier system. TCO was 20% compared to Oracle (including hardware and support). Fast, flexible and with great support of programming languages, with API compatibility helped us to run a full scale retail chain (16 offline stores) with real time stock management in our online store.

장점:

+ scalability + SQL compilant + security + open source (free but not without costs) + offers more field types than mysql + API compatibility + low TCO - cheaper than Oracle (but with similar performance) + great programming language support (Python, PHP, C++ etc)

단점:

- free (open source) does not mean witout costs. Sometimes it is very hard to find a specialist that can properly handle PG issues - not present at most of hosting services (but you can always run a virtual machine on AWS EC2) - less tools for data manipulation/analysis compared to MySQL

Experience with PostgreSQL

주석: We have used the database for the implementation of reporters in most cases, seeking to remove the load from the main database.

장점:

It allows me to implement a robust database in a very short time, using a structure very similar to Oracle, in addition to having many tools that allow us to manage the data in the best way.

단점:

There are functionalities that with third-party products can obtain better results.

The best database offering available

주석: Excellent. The documentation is complete and well-written.

장점:

PostgreSQL is standards compliant, performant, high-quality, easy to use, well documented, innovative and feature-complete.

단점:

Replication still has a way to go compared to some competing offerings, but additional software can be used to fill in the missing features.

Best Relational Database and it's Open Source

주석: I've found PostgreSQL to be a powerfully efficient and secure tool for managing relational databases

장점:

PostgreSQL excels in its strong documentation, large data handling, and exceptional security.

단점:

Challenges with screen navigation, JSON handling, and data comparison can make it less user-friendly

PostgreSQL Review

장점:

PostgreSQL is an excellent choice for working with relational databases. After extensive experience with databases, I found that PostgreSQL is one of the most reliable options. It is the preeminent open source SQL system and potentially the best of all, open source or not. PostgreSQL offers both remarkable performance and dependability.

단점:

The SQL syntax for Postgresql was slightly different than what I was used to.

Great SQL db

장점:

Free and open source database Ease of scaling the database Easy to work with date, time and timezone jsonb type is really great so we don't need to use non relational database like mongodb fast queries

단점:

I have yet not found a great admin tool for postgres. pgadmin is ok but It is not as good as phpmyadmin or others.

Open source relational database with lots of features

장점:

Open source. Offers a rich set of features and extensions. Available as fully managed database on most cloud platforms.

단점:

Some cases, often involving large sets of data, might require some advanced knowledge in order to run properly/performant.

The most advanced open-source database management system

주석: We use PostgreSQL in most of our projects as a primary backend and our experience has been positive.

장점:

PostgreSQL is one of the most feature-rich, powerful and advanced open-source database management systems. Though this power comes at a cost. Using PostgreSQL in the best possible way takes some time. PostgreSQL is a real beast and it takes time before one becomes fully familiar with it.

단점:

Even with all the power that PostgreSQL gives, there are certain things that are missing. For example, until the latest versions there was no support for partitioning. Lack of a great graphic admin tool is a con in my opinion. Yes, it's possible to use (and we do) third party tools like DBeaver but a great database system must simply have its own admin GUI.

PostgreSQL Review

주석: I highly recommend PostgreSQL, i have been using it at work and at the university

장점:

First, it is open source and wildly used database, it is customizable and scalable

단점:

It does not contain a customer service because it is open source but of course you can find ur answers on the internet and platforms

The best SQL and open source database.

주석: Because range queries are integrated, it is much less effort to query compared to MySQL.

장점:

It is fast and reliable, manages inserts and updates of tens of thousands of lines impeccably. PostgreSQL implements SQL standards very well and supports advanced SQL stuff, the PostSQL database works very well with hibernation HPA and we have been using it extensively together with the Spring framework, the consistency is also very good, you will never lose data or lose data. JSON support in the latest version has made things easier for us now, since we do not need to migrate the schema as always before.  Finally, the backup methods through pg_dump are easy to use and ensure that you can always back up before any major changes.

단점:

It is not very intuitive, in my opinion, and I think those problems must be solved before I can get the kind of traction that MySQL has, also more open sources admit mysql but not postgres. These are some of the problems with postgres.