refinery
nhost
refinery | nhost | |
---|---|---|
6 | 88 | |
1,213 | 7,529 | |
2.5% | 0.8% | |
7.1 | 9.8 | |
9 days ago | 8 days ago | |
Rust | TypeScript | |
MIT License | 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.
refinery
-
Database Migrations
Great write up! At PeerDB, we’ve been using refinery https://github.com/rust-db/refinery to handle database migrations of our catalog Postgres database from Rust. It is easy, typesafe and gets the job done. Thought this would be useful for users building apps with Rust!
-
Sqlx, diesel, orm or other sqlx query ?
I don't think migrations need to be tied to ORM. We have refinery that allows you to write migrations in rust. I, personally, didn't like and prefer writing them in SQL - why learn how to migrations in X when you already know the SQL dialect that you're using.
-
Ask HN: ORM or Native SQL?
The best solution I've ever seen is this Rust library https://github.com/cornucopia-rs/cornucopia
You write plain SQL for you schema (just a schema.sql is enough) and plain SQL functions for your queries. Then it generates Rust types and Rust functions from from that. If you don't use Rust, maybe there's a library like that for your favorite language.
Optionally, pair it with https://github.com/bikeshedder/tusker or https://github.com/blainehansen/postgres_migrator (both are based off https://github.com/djrobstep/migra) to generate migrations by diffing your schema.sql files, and https://github.com/rust-db/refinery to perform those migrations.
Now, if you have simple crud needs, you should probably use https://postgrest.org/en/stable/ and not an ORM. There are packages like https://www.npmjs.com/package/@supabase/postgrest-js (for JS / typescript) and probably for other languages too.
If you insist on an ORM, the best of the bunch is prisma https://www.prisma.io/ - outside of the typescript/javascript ecosystem it has ports for some other languages (with varying degrees of completion), the one I know about is the Rust one https://prisma.brendonovich.dev/introduction
-
New to PostgreSQL - Best way to use it?
What I personally use here is Refinery, but it's within the Rust ecosystem. It lets you write your migrations in pure SQL - which is what I prefer - but still requires about 5 lines of boilerplate Rust code.
-
Part of SQLx will become proprietary
Example refinery migrations
nhost
-
Database Review: Top Five Missing Features from Database APIs
Hasura ❌ (technically yes with Nhost)
-
the code written during those sudden spurts of inspiration are the backbone of most software development
Only caveat I say is make sure there's something in it for you; if it's 2 AM it better be mostly for self-benefit. I'm busy constructing a monorepo with the latest technology with NX and pnpm and a half dozen other technologies (I recommend checking out http://nhost.io/); at the end I will build whatever I want and maybe make money. It's not done for the good of someone else exclusively that's for sure
-
Does an open source 'backend platform' exist for dotnet?
Yeah, I knew of those, I think that's discussed often enough on the dotnet subs. Ory and Zitadel I knew too, but those provide just one thing, and are not native to dotnet. Altough I'll admit, stuff like nhost seem native to typescript but uses go projects under the covers as well.
-
You're starting development today, which libraries are you going with?
I'm really digging nhost and apollo-client.
-
Is there smth like firebase on-prem?
You can use Nhost (100% open source): https://github.com/nhost/nhost/tree/main/examples/docker-compose
- I created Atomic: Self Hosted Open Source Alternative to Reclaim, Clockwise & Motion
-
When are we going to become millionaires?
Backend Frontend Database pick two or even one. Maybe something like this
-
nhost.io error , ge.create is not a function
I am trying to use basic authentication of nhost.io .
-
Help on designing 'backend' stack to go with NextJs project
If your backend needs aren't super crazy, i would check out https://nhost.io/
- Open Source Firebase Alternative with GraphQL
What are some alternatives?
sqlx - 🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite.
supabase - The open source Firebase alternative.
serde_postgres - Easily Deserialize Postgres rows.
Appwrite - Your backend, minus the hassle.
postgres_migrator - A postgres migration generator and runner that uses raw declarative sql.
Hasura - Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.
pggen - Generate type-safe Go for any Postgres query. If Postgres can run the query, pggen can generate code for it.
hasura-backend-plus - 🔑Auth and 📦Storage for Hasura. The quickest way to get Auth and Storage working for your next app based on Hasura.
pgroll - PostgreSQL zero-downtime migrations made easy
apollo-server - 🌍 Spec-compliant and production ready JavaScript GraphQL server that lets you develop in a schema-first way. Built for Express, Connect, Hapi, Koa, and more.
tusker - PostgreSQL migration management tool
Prisma - Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB