postgrex
metagration
| postgrex | metagration | |
|---|---|---|
| 3 | 4 | |
| 1,054 | 99 | |
| 1.2% | - | |
| 6.6 | 0.0 | |
| 7 days ago | about 2 years ago | |
| Elixir | PLpgSQL | |
| Apache License 2.0 | MIT License |
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.
postgrex
-
Elixir clustering using Postgres
Now we can replicate the same behavior in Elixir and Postgrex within IEx (Elixir's interactive shell).
-
TIL: Non standard postgres types in livebook
But I found a problem when the data type is not supported by postgrex. In this case, you can either have to write a custom postgrex extension like the example here. In postgrex GitHub repo, there are many examples for common data types, but XML is missing there.
-
Realtime: Multiplayer Edition
It sounds like Supabase is pulling out the WAL listening bits into its own library?
https://supabase.com/blog/supabase-realtime-multiplayer-gene...
If so, y'all might want to look into: https://github.com/elixir-ecto/postgrex/blob/master/lib/post...
metagration
-
Realtime: Multiplayer Edition
Realtime uses logical replication, and from your link it looks like it should work with Timescale (although not recommended):
> Using logical replication with TimescaleDB is not recommended, as it requires schema synchronization between the primary and replica nodes and replicating partition root tables, which are not currently supported.
As long as logical replication is supported, this won't be an issue for Realtime because the purpose is to receive data changes (which come in a JSON format) and the end-user doesn't need to persist schema modifications.
> but couldn't get it working
If you send me some error logs, I can take a look or forward to one of the team.
> support Postgres streaming replication
This is the first time I've heard it requested - I don't think it's something we'd do unless there was a good reason and strong demand. If we were to do any work in this direction we'd prefer to try contribute DDL streaming to PostgreSQL's logical streaming. We've been thinking about this for a while (Michel has built metagration - https://github.com/michelp/metagration which has prompted a few ideas for core patches)
- GraphJin – An Instant GraphQL to SQL Compiler
- Show HN: Metagration – Migrate Postgres with Postgres
- Metagration: PostgreSQL Migrator in PostgreSQL
What are some alternatives?
ecto - A toolkit for data mapping and language integrated query.
thin-backend - 🔥 Thin Backend is a Blazing Fast, Universal Web App Backend for Making Realtime Single Page Apps
eventstore - Event store using PostgreSQL for persistence
pg_partman - Partition management extension for PostgreSQL
mariaex - Pure Elixir database driver for MariaDB / MySQL
assert-combinators - Functional assertion combinators.
mongodb_ecto - MongoDB adapter for Ecto
pg_graphql - GraphQL support for PostgreSQL
amnesia - Mnesia wrapper for Elixir.
postgrest - REST API for any Postgres database
couchdb_connector - A couchdb connector for Elixir
thin-backend-todo-app