A startup from the United States.
Open Source
PostgreSQL is an open-source database management system, which means it is free to use, modify, and distribute. This reduces the cost of database management for individuals and organizations.
ACID Compliance
PostgreSQL is fully ACID (Atomicity, Consistency, Isolation, Durability) compliant, ensuring reliable transactions and data integrity.
Extensible
PostgreSQL is highly extensible, allowing users to add custom functions, data types, and operators. This enables tailored solutions to specific requirements.
Advanced SQL Features
PostgreSQL supports advanced SQL features like full-text search, JSON and XML data types, and complex queries, providing powerful tools for database operations.
Community Support
There is a strong and active community around PostgreSQL, offering extensive documentation, forums, and collaborative support, which aids troubleshooting and development.
Multiple Indexing Techniques
PostgreSQL offers a variety of indexing techniques such as B-tree, GIN, GiST, and BRIN, allowing for optimized query performance on various data types.
Cross-Platform Availability
PostgreSQL runs on all major operating systems (Windows, MacOS, Linux, Unix), giving flexibility in deployment and development environments.
Promote PostgreSQL. You can add any of these badges on your website.
Yes, PostgreSQL is considered a high-quality and reliable database management system, suitable for a wide range of applications, from small-scale personal projects to large enterprise systems.
We have collected here some useful links to help you find out if PostgreSQL is good.
Check the traffic stats of PostgreSQL on SimilarWeb. The key metrics to look for are: monthly visits, average visit duration, pages per visit, and traffic by country. Moreoever, check the traffic sources. For example "Direct" traffic is a good sign.
Check the "Domain Rating" of PostgreSQL on Ahrefs. The domain rating is a measure of the strength of a website's backlink profile on a scale from 0 to 100. It shows the strength of PostgreSQL's backlink profile compared to the other websites. In most cases a domain rating of 60+ is considered good and 70+ is considered very good.
Check the "Domain Authority" of PostgreSQL on MOZ. A website's domain authority (DA) is a search engine ranking score that predicts how well a website will rank on search engine result pages (SERPs). It is based on a 100-point logarithmic scale, with higher scores corresponding to a greater likelihood of ranking. This is another useful metric to check if a website is good.
The latest comments about PostgreSQL on Reddit. This can help you find out how popualr the product is and what people think about it.
In this new series we will be creating an API written in go, using a framework like Chi, connecting to a PostgreSQL, and have it deployed to a site like Railway. - Source: dev.to / 2 months ago
PostgreSQL 17 Performance Guide โ Official docs for the latest performance improvements. - Source: dev.to / 3 months ago
You also might be saying, Why not include the credit and attribution data with the product data and just use one data file? Thats a great question. I could have for the purpose of this demo, but if there were a backend to this project and a relational database like PostgreSQL attached to it, I would still have both sets of data in separate tables in the database. By using a foreign key between related records in... - Source: dev.to / 9 months ago
In this quick post, weโll walk through implementing an Upsert operation in Hasura using PostgreSQL and GraphQL. - Source: dev.to / over 1 year ago
Iโm on MacOS and erlang.org, elixir-lang.org, and postgresql.org all suggest installation via Homebrew, which is a very popular package manager for MacOS. - Source: dev.to / about 2 years ago
According to the documentation, crate sqlx is implemented in Rust, and it's database agnostic: it supports PostgreSQL, MySQL, SQLite, and MSSQL. - Source: dev.to / over 2 years ago
Solution is just downloading and installilng pgAdmin from official pgAdmin homepage version, not the one that is included in the postgresql.org package. Source: almost 3 years ago
SQL immediately stands out here because it was designed for making relational algebra, the other side of the Entity-Relationship model, accessible. There are likely more people who know SQL than any programming language (for IaC) or data format you could choose to represent your cloud infrastructure. Many non-programmers know it, as well, such as data scientists, business analysts, accountants, etc, and there is... - Source: dev.to / about 3 years ago
Vapor[0] based on Swift. Advantage of this is that you don't have to evaluate multiple frameworks for Swift and suffer paralysis by analysis. All the Swift community is behind one framework. The next is Actix[1] based on Rust. There are many frameworks in Rust and most of them have not reached 1.0 And which framework will survive becomes a question. Other not so well-known is Wt[2] based on C++. This actually is... - Source: Hacker News / over 3 years ago
This is big news: Heroku used to be one of the easiest ways for you to get a free server, PostgreSQL database, and a Redis cache, all in a single location and all for free. - Source: dev.to / almost 4 years ago
ORMs tend to just obscure what is going on. If I know SQL and PostgreSQL, I can essentially understand just about ANY project that uses them, without having to learn the specifics of one of two dozen ORMs with its own idiosyncrasies. If you are a startup that uses an ORM, then essentially the developers working on your product will always interact with the database through an ORM preventing them from developing... - Source: dev.to / almost 4 years ago
Pg has homepage: https://postgresql.org/ . In there, at the top, there is link named "Documentation" - https://www.postgresql.org/docs/ - From there pick the version you're using, or just go for "current" : https://www.postgresql.org/docs/current/index.html. Source: almost 4 years ago
To use PostgreSQL as external database servers, it's better to use TLS/SSL connection. This post shows how to generate certificates, configure servers and verify them. - Source: dev.to / about 4 years ago
So recently, I was on a live steam with @aydrian on Twitch where I demonstrated how to migrate a live serverless application (Next.js and Vercel) from PostgreSQL database onto CockroachDB serverless with zero application downtime. If you're interested in that, please do check out the video. - Source: dev.to / about 4 years ago
A Postgres database running. You can either have the Postgres server installed, or use Docker. I'll be doing the latter in this tutorial. - Source: dev.to / over 4 years ago
I generally default to using JSON for data interchange but there are still a myriad of formats of XML out there, for which I have created the xmltojson crate. I originally wrote this one night to help me get an XML dataset into JSON so that I could use PostgreSQL's JSONB column type, but I only recently published it to crates.io since it may be useful for others. - Source: dev.to / about 5 years ago
Postgres โ configured PostgreSQL container with apply migrations (by golang-migrate/migrate tool) for backend. - Source: dev.to / about 5 years ago
We are not locking down our subreddit to only postgresql.org content. The PostgreSQL universe is larger than just postgresql.org. Source: about 5 years ago
Finally, on the backend, we've got a simple Scala-based application, deployed on Heroku. The database is PostgreSQL, but the application is not a straightforward CRUD as you might expect, but instead uses SQL-based, transactional event sourcing. Probably overkill, but โ if we ever want to create a new view basing on the events (which include e.g. Program creation in creative mode, or solving a challenge) โ for... - Source: dev.to / about 5 years ago
PostgreSQL, or "Postgres," as it is often affectionately called, maintains a strong and laudable reputation in the realm of database management. With its open-source nature and a license that is both permissive and user-friendly, PostgreSQL stands as a preferred SQL server solution for countless organizations, ranging from large corporations in sectors like ecommerce and telecommunications to tech startups and individual developers.
PostgreSQL is celebrated for its robust features, high performance, and reliability. Its versatility is noteworthy: it handles both SQL for relational queries and JSON for non-relational queries, making it a suitable replacement for more specialized NoSQL databases like MongoDB. This flexibility is one of the key reasons why PostgreSQL is praised as a "darling" of the open-source database community, and why it has been a go-to solution for over three decades.
Moreover, PostgreSQL's JSON capabilities and extensive support for complex data typesโsuch as JSONB, which enables efficient storage and retrieval of JSON dataโallow for a seamless integration within modern web and application development, evidenced by successful stories of migrating applications from MongoDB to Postgres.
The Postgres ecosystem is strengthened by tools that complement its functionality. For instance, Peliqan offers an easy path for users to transfer data from PostgreSQL into platforms like Google Sheets, supplemented by additional tools for data transformation and visualization. Furthermore, PostgreSQLโs compatibility with programming languages like Rust and its ability to power complex operations like those needed in event-sourcing architectures or project setups in languages like Elixir emphasize its adaptability to various technological stacks.
However, PostgreSQL is not without its criticisms. Users have encountered difficulties, for instance, with running PostgreSQL tools on operating systems like Windows, where issues with components such as pgAdmin can arise. This highlights the need for understanding system-specific installation and management nuances that can affect seamless operations.
While PostgreSQL's extensive feature set is advantageous, it can also contribute to complexity, necessitating a deeper understanding of relational database management. Some developers point out the learning curve associated with mastering PostgreSQL's advanced features, such as its powerful querying capabilities like lateral joins. Despite this, the PostgreSQL documentation is well-regarded, providing comprehensive resources for overcoming these challenges.
In comparison with its competitors such as MySQL, Microsoft SQL Server, and Oracle DB, PostgreSQLโs open-source model, rich feature set, and enduring reputation make it a cornerstone technology in the database landscape. Its ability to act as a powerful engine for SQL-based solutions provides a compelling option for those seeking a reliable, versatile, and community-supported database management system. Through continuous development and a vibrant user community, PostgreSQL is well-positioned to remain a pivotal player among databases for years to come.
Do you know an article comparing PostgreSQL to other products?
Suggest a link to a post with product alternatives.
Is PostgreSQL good? This is an informative page that will help you find out. Moreover, you can review and discuss PostgreSQL here. The primary details have not been verified within the last quarter, and they might be outdated. If you think we are missing something, please use the means on this page to comment or suggest changes. All reviews and comments are highly encouranged and appreciated as they help everyone in the community to make an informed choice. Please always be kind and objective when evaluating a product and sharing your opinion.
Simply the best db.
I can't imagine web-dev without PostgreSQL. This is one of the the most irreplaceable and do-anything piece of infrastructure nowadays. Super stable and reliable.