/? postgres replication https://hn.algolia.com/?dateRange=all&page=0&prefix=true&query=postgresql%20replication&sort=byDate&type=story https://hn.algolia.com/?

/? postgres replication https://hn.algolia.com/?dateRange=all&page=0&prefix=true&query=postgresql%20replication&sort=byDate&type=story https://hn.algolia.com/?dateRange=all&page=0&prefix=true&que... "Pgactive: Active-Active Replication Extension for PostgreSQL on Amazon RDS" (2023) https://news.ycombinator.com/item?id=37838223 https://news.ycombinator.com/item?id=37838223 /? "pgactive" site:github.com https://www.google.com/search?q=%22pgactive%22+site%3Agithub.com https://www.google.com/search?q=%22pgactive%22+site%3Agithub... cloudnative-pg/cloudnative-pg: https://github.com/cloudnative-pg/cloudnative-pg https://github.com/cloudnative-pg/cloudnative-pg : > primary/standby cloudnative-pg > Logical replication #13: https://github.com/cloudnative-pg/cloudnative-pg/issues/13 https://github.com/cloudnative-pg/cloudnative-pg/issues/13 /? logical replication: https://www.google.com/search?q=logical+replication https://www.google.com/search?q=logical+replication pgadmin docs > Publication Dialog; logical replication: https://www.pgadmin.org/docs/pgadmin4/development/publication_dialog.html https://www.pgadmin.org/docs/pgadmin4/development/publicatio... https://github.com/dalibo/pg_activity#faq https://github.com/dalibo/pg_activity#faq ; pip install `pg_activity[psychopg]` : > FAQ: I can't see my queries only TPS is shown (How) Do any ~pg_top tools delineate logical replication activity? pgcenter > PostgreSQL statistics [virtual tables] (and also /proc) https://github.com/lesovsky/pgcenter#postgresql-statistics https://github.com/lesovsky/pgcenter#postgresql-statistics ... "Show HN: ElectricSQL, Postgres to SQLite active-active sync for local-first apps" (2023) from the creators of CRDTs https://news.ycombinator.com/item?id=37590257 https://news.ycombinator.com/item?id=37590257 electric-sql/electric: https://github.com/electric-sql/electric https://github.com/electric-sql/electric : > ElectricSQL is a local-first software platform that makes it easy to develop high-quality, modern apps with instant reactivity, realtime multi-user collaboration and conflict-free offline support. > Local-first is a new development paradigm where your app code talks directly to an embedded local database and data syncs in the background via active-active database replication. Because the app code talks directly to a local database, apps feel instant. Because data syncs in the background via active-active replication it naturally supports multi-user collaboration and conflict-free offline "SQLedge: Replicate Postgres to SQLite on the Edge" (2023) https://news.ycombinator.com/item?id=37067980 https://news.ycombinator.com/item?id=37067980 ; gh-ost, dolt, sqldiff /?hnlog ctrl-f Consistenc, Consensus : - "A few notes on message passing" https://news.ycombinator.com/item?id=26535969 https://news.ycombinator.com/item?id=26535969 : > The C in CAP theorem is for Consistency [3][4]. [...] > [3] https://en.wikipedia.org/wiki/Consistency_model https://en.wikipedia.org/wiki/Consistency_model > [4] https://en.wikipedia.org/wiki/CAP_theorem https://en.wikipedia.org/wiki/CAP_theorem