PolarDB-for-PostgreSQL
citus
Our great sponsors
| PolarDB-for-PostgreSQL | citus | |
|---|---|---|
| 13 | 61 | |
| 2,755 | 9,801 | |
| 1.2% | 3.3% | |
| 8.3 | 9.5 | |
| 13 days ago | 8 days ago | |
| C | C | |
| Apache License 2.0 | GNU Affero General Public License v3.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
PolarDB-for-PostgreSQL
-
How to scale storage of PostgreSQL database?
Disaggregated storage for Postgres is still a very new technology, both with NeonDB and PolarDB (https://github.com/ApsaraDB/PolarDB-for-PostgreSQL).
-
Neon – Serverless Postgres
Amazing work by the Team. Congrats y'all. It was one of the best presentations in the PGcon22.
I did email Heikki the following questions, in case if someone from Neon is around here.
a) How does Neon compare to polardb https://github.com/ApsaraDB/PolarDB-for-PostgreSQL.
b) The readme mentions a component "Repository - Neon storage implementation". Does it use any special FileSystem? Any links to read more about it?
c) Heard the cold start is a second (IIRC), how does that value differ if one runs Neon on bare metal instead of k8s?
-
Start Your GitHub Journey From Contributing To Any GitHub Project
【Reference - Documentation】 https://github.com/alibaba/PolarDB-for-PostgreSQL#contributing
-
[News] PolarDB for PostgreSQL Paxos Is Open Sourced
【GitHub - PolarDB for PostgreSQL】 Check Now >
- PolarDB, yet another open source database system based on PostgreSQL open-sourced by Alibaba
- alibaba/PolarDB-for-PostgreSQL - PolarDB, yet another open source database system based on PostgreSQL
-
Hacker News top posts: May 30, 2021
PolarDB, yet another open source database system based on PostgreSQL\ (41 comments)
- PolarDB, yet another open source database system based on PostgreSQL
citus
- SPQR 1.3.0: a production-ready system for horizontal scaling of PostgreSQL
- Citus: PostgreSQL extension that transforms Postgres into a distributed database
-
Figma's Databases team lived to tell the scale
I see they don't mention Citus (https://github.com/citusdata/citus), which is already a fairly mature native Postgres extension. From the details given in the article, in sounds like they just reimplemented it.
I wonder if they were unaware of it or disregarded it for a reason —I currently am in a similar situation as the one described in the blog, trying to shard a massive Postgres DB.
-
PostgreSQL Is Enough
It is possible, if you pay for it. You can do Multi-AZ Clustered Instances in RDS, where you get the benefits of Multi-AZ failover with traffic sharing.
If you can run your own infra – at least on an EC2 level – you can do things like Citus [0] for Postgres, which is about as close to "just add database nodes" as you'll get.
[0]: https://www.citusdata.com/
-
Vitess 18
So while searching for something like this for postgres I came across citus. Any one know how that stacks up?
https://github.com/citusdata/citus
- In-Depth Guide: Citus Technical Readme
-
Revolutionizing Database Scaling with CitusDB
References: CitusDB
- Squeeze the hell out of the system you have
- Show HN: Hydra 1.0 – open-source column-oriented Postgres
- Schema-based sharding comes to PostgreSQL with Citus
What are some alternatives?
flyctl - Command line tools for fly.io services
Greenplum - Greenplum Database - Massively Parallel PostgreSQL for Analytics. An open-source massively parallel data platform for analytics, machine learning and AI.
materialize - The data warehouse for operational workloads.
yugabyte-db - YugabyteDB - the cloud native distributed SQL database for mission-critical applications.
neon - Neon: Serverless Postgres. We separated storage and compute to offer autoscaling, branching, and bottomless storage.
vitess - Vitess is a database clustering system for horizontal scaling of MySQL.
database-lab-engine - DBLab enables 🖖 database branching and ⚡️ thin cloning for any Postgres database and empowers DB testing in CI/CD. This optimizes database-related costs while improving time-to-market and software quality. Follow to stay updated.
TimescaleDB - An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
helm-charts - neondatabase helm charts
dbt-core - dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.
walex - Postgres change events (CDC) in Elixir
stolon - PostgreSQL cloud native High Availability and more.