pgcat
cainophile
| pgcat | cainophile | |
|---|---|---|
| 3 | 2 | |
| 2,551 | 235 | |
| 2.7% | 1.7% | |
| 8.0 | 1.7 | |
| 3 days ago | 2 months ago | |
| Rust | Elixir | |
| MIT License | Apache License 2.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.
pgcat
-
MySQL 8.2 Introduces Transparent Read/Write Splitting
Not natively, no. You’d need to front it with something like PgCat [0].
[0]: https://github.com/postgresml/pgcat
-
How to Listen to Database Changes Using Postgres Triggers in Elixir
For #1 I've been keeping a keen eye on pgcat [1], in particular the https://github.com/postgresml/pgcat/issues/303 which
- Can someone share experience configuring Highly Available PgSQL?
cainophile
-
How to Listen to Database Changes Using Postgres Triggers in Elixir
If you want to listen to database changes in Elixir you can also get really good stuff done by using Cainophile (https://github.com/cainophile/cainophile). Same mechanism. I don't know the details of Debezium so I can't say if you are leaving fantastic things on the table. But I've had good fun with Cainophile. For example I've used it in my videos on Electric SQL to react to changes in a Postgres database. It matches nicely with realtime-ish UI via LiveView. So meshes really good with the current Elixir stack.
-
Ask HN: Is there a way to subscribe to an SQL query for changes?
https://github.com/cainophile/cainophile
I happened to do a similar thing but I adapted cainophile into an Elixir “OffBroadway” producer:
What are some alternatives?
pgbouncer - lightweight connection pooler for PostgreSQL
noria - Fast web applications through dynamic, partially-stateful dataflow
odyssey - Scalable PostgreSQL connection pooler
supavisor - A cloud-native, multi-tenant Postgres connection pooler.
postgresql_cluster - PostgreSQL High-Availability Cluster (based on "Patroni" and DCS "etcd" or "consul"). Automating with Ansible.
timely-dataflow - A modular implementation of timely dataflow in Rust
PipelineDB - High-performance time-series aggregation for PostgreSQL
mssql-changefeed
flow - 🌊 Continuously synchronize the systems where your data lives, to the systems where you _want_ it to live, with Estuary Flow. 🌊
cloudpilot-emu - A PalmOS emulator for the web
revori - A revision-oriented DBMS