-
PostgreSQL Convention 2024
2023-11-27 in Postgres
Background 0x01 Naming Convention 0x01 Design Convention 0x01 Query Convention 0x01 Admin Convention Roughly translated from PostgreSQL Convention 2024 with Google. 0x00 Background No Rules, No Lines The functions of PostgreSQL are very powerful, …
-
FerretDB: When PG Masquerades as MongoDB
2023-10-08 in Postgres
MongoDB was once a revolutionary technology that liberated developers from the “schema shackles” of relational databases, enabling rapid application development. However, as time passed, MongoDB gradually drifted away from its open-source …
-
PostgreSQL, The most successful database
2023-06-28 in Postgres
The StackOverflow 2023 Survey, featuring feedback from 90K developers across 185 countries, is out. PostgreSQL topped all three survey categories (used, loved, and wanted), earning its title as the undisputed “Decathlete Database” – …
-
How Powerful Is PostgreSQL?
2022-08-22 in Postgres
Last time, we analyzed StackOverflow survey data to explain why PostgreSQL is the most successful database. This time, let’s rely on performance metrics to see just how powerful “the most successful” PostgreSQL really is. We want everyone to walk …
-
Why Is PostgreSQL the Most Successful Database?
2022-07-12 in Postgres
When we say a database is “successful,” what exactly do we mean? Are we referring to features, performance, or ease of use? Or perhaps total cost, ecosystem, or complexity? There are many evaluation criteria, but in the end, it’s the …
-
Pigsty: The Production-Ready PostgreSQL Distribution
2021-05-24 in Postgres
What is Pigsty? Pigsty is a production-ready, batteries-included PostgreSQL distribution. A distribution, in this context, refers to a complete database solution comprised of the database kernel and a curated set of software packages. Just as Linux …
-
Why PostgreSQL Has a Bright Future
2021-05-08 in Postgres
Recently, everything I’ve been working on revolves around the PostgreSQL ecosystem, because I’ve always believed it’s a direction with limitless potential. Why do I say this? Because databases are the core components of information …
-
What Makes PostgreSQL So Awesome?
2018-06-10 in Postgres
PostgreSQL’s slogan is “The World’s Most Advanced Open Source Relational Database”, but I find this tagline lacks punch. It also feels like a direct jab at MySQL’s “The World’s Most Popular Open Source …