| refinery | welds | |
|---|---|---|
| 6 | 3 | |
| 1,213 | 85 | |
| 1.8% | - | |
| 7.1 | 8.5 | |
| 9 days ago | 1 day ago | |
| Rust | Rust | |
| MIT License | BSD 3-clause "New" or "Revised" 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
welds
- Welds – An async ORM written in Rust using the sqlx framework
- GitHub - weldsorm/welds. Written for ease of development.
-
Sqlx, diesel, orm or other sqlx query ?
Wow its cool to see so many people are interested in ORMs in rust. I have been writing an ORM for the last 6 months because I was so frustrated with SeaORM and Diesel. I would love some feedback if anyone is interested in taking a look. ORM is Welds .
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.
serde_postgres - Easily Deserialize Postgres rows.
postgres_migrator - A postgres migration generator and runner that uses raw declarative sql.
pggen - Generate type-safe Go for any Postgres query. If Postgres can run the query, pggen can generate code for it.
pgroll - PostgreSQL zero-downtime migrations made easy
tusker - PostgreSQL migration management tool
safeql - Composable / async / functional / type-safe / parallel-pipelined queries and relations without SQL injection or N+1s.
nhost - The Open Source Firebase Alternative with GraphQL.
PostgreSQL - PostgreSQL client for node.js.
migra - Like diff but for PostgreSQL schemas
cornucopia - Generate type-checked Rust from your PostgreSQL.