serde_postgres
refinery
serde_postgres | refinery | |
---|---|---|
1 | 6 | |
60 | 1,213 | |
- | 2.5% | |
0.0 | 7.1 | |
about 3 years ago | 10 days ago | |
Rust | Rust | |
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.
serde_postgres
-
Part of SQLx will become proprietary
Agreed. ORM's seem to do the job 80-90% of the time and make it absolutely painful the remaining 10-20% of the time. Statically checked SQL is pretty much the sweet spot in terms of tradeoffs, but I wouldn't be opposed to something along the lines of serde_postgres but for serialization, so I could use my struct definitions as the single source of truth and simply slap a derive macro on the struct to generate the necessary migrations. I'm not sure whether such an endeavour would be even remotely feasible, though, and it would perhaps be something one would expect to find in Diesel rather than in SQLx.
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
What are some alternatives?
refinery - The data scientist's open-source choice to scale, assess and maintain natural language data. Treat training data like a software artifact.
sqlx - 🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite.
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.
welds
migra - Like diff but for PostgreSQL schemas
cornucopia - Generate type-checked Rust from your PostgreSQL.