metagration
thin-backend-todo-app
| metagration | thin-backend-todo-app | |
|---|---|---|
| 4 | 4 | |
| 100 | 11 | |
| - | - | |
| 0.0 | 10.0 | |
| about 2 years ago | almost 2 years ago | |
| PLpgSQL | JavaScript | |
| 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.
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
thin-backend-todo-app
-
Thin Backend - Instant Postgres Backend for React/Vue/Svelte/... Apps with Realtime, Optimistic Updates & Auto-generated TypeScript Bindings
In the early development phase we actually added GraphQL support to Thin. It was removed as we figured out that a lot of the common CRUD operations would take a lot more boilerplate code when doing it with GraphQL. Now our API consists of high level functions like `createRecord(tableName, object)` and `useQuery(query(tableName))`. You can find some example code here: https://github.com/digitallyinduced/thin-backend-todo-app/blob/main/app.tsx
-
Thin Backend: Instant API for your Postgres DB
If you want to play around with Thin, you can find a small example app here. It's running on Vercel here.
-
GraphJin – An Instant GraphQL to SQL Compiler
If you're looking for something like GraphJin, PostGraphile or Hasura but with less boilerplate and complexity, more end-to-end typesafe approach and optimistic updates, check out Thin Backend https://thin.dev/ (https://github.com/digitallyinduced/thin-backend)
Thin Backend takes a bit more of a higher level approach to database operations than services like GraphJin, but solves fundamentally the same problem. Doing things in a more structured way also allows us to do things like optimistic updates by default that require manual work with GraphQL tools.
To see some code examples, here's a small example project done with thin-backend: https://github.com/digitallyinduced/thin-backend-todo-app It's running on Vercel here: https://thin-backend-todo-app.vercel.app/
-
Thin Backend - Instant Postgres Backend for React Apps with Realtime, Optimistic Updates & Auto-generated TypeScript Bindings
} ``` Live example here: https://thin-backend-todo-app.vercel.app/ Full Code: https://github.com/digitallyinduced/thin-backend-todo-app
What are some alternatives?
thin-backend - 🔥 Thin Backend is a Blazing Fast, Universal Web App Backend for Making Realtime Single Page Apps
pg_partman - Partition management extension for PostgreSQL
pg_graphql - GraphQL support for PostgreSQL
assert-combinators - Functional assertion combinators.
graphjin - GraphJin - Build NodeJS / GO APIs in 5 minutes not weeks
fastapi - FastAPI framework, high performance, easy to learn, fast to code, ready for production
postgrest - REST API for any Postgres database
aquameta - Web development platform built entirely in PostgreSQL