Norm
rusqlite-model
Norm | rusqlite-model | |
---|---|---|
3 | 1 | |
22 | 11 | |
- | - | |
0.0 | 0.0 | |
10 months ago | over 1 year ago | |
Python | Rust | |
GNU General Public License v3.0 or later | - |
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.
Norm
- Show HN: Sqlbind a Python library to compose raw SQL
-
Sketch of a Post-ORM
This is just not liking SQL, which is fine, but it's not 'the future of querying databases'. It's just a simplified language that is under-specified and doesn't really support even a fraction of the use cases of SQL, and therefore looks 'cleaner'. It's a bad abstraction.
Here is my attempt at a 'post orm' if anyone is interested, as a bonus it is fully implemented and some people actually use it: https://github.com/justinvanwinkle/Norm
-
Show HN: Write universally accessible SQL, not library-specific ORM wrapper APIs
I tried to do something similar with https://github.com/justinvanwinkle/Norm about 10 years ago. It hasn't generated a lot of interest, but I find it quite useful to construct queries without having to learn the minutia of an ORM library, or even a SQL generation library.
rusqlite-model
-
Show HN: Write universally accessible SQL, not library-specific ORM wrapper APIs
I'm quite anti-ORM, though I've never not used one professionally (just because it's already been there / not my decision), so that might be different if I did for a while. I do think something's necessary though, and it maybe is a bit arbitrary where we draw the line for what's an 'ORM'?
For example, I really enjoyed using rusqlite for a little side project/personal thing, but found apart from anything else just the repetition of `(?,?,?,?,?,?)` any time I wanted to insert something was annoying, for example. I started working a bit on [0] .. I don't know if I'd call it an ORM, just so I didn't have to do that, and could write `Model { ... }.insert(&conn)` instead. But still write plain SQL queries, I just want easy mapping between db table and language 'model' struct/class; column and field/attr.
[0] - https://github.com/OJFord/rusqlite-model
What are some alternatives?
pure-orm - A pure ORM for writing native SQL queries yielding pure business objects
diesel - A safe, extensible ORM and Query Builder for Rust
pgdbf - Convert XBase / FoxPro databases to PostgreSQL
mammoth - A type-safe Postgres query builder for TypeScript.
Hangfire - An easy way to perform background job processing in .NET and .NET Core applications. No Windows Service or separate process required
slonik - A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL.
pgsql-http - HTTP client for PostgreSQL, retrieve a web page from inside the database.
rbatis - Rust Compile Time ORM robustness,async, pure Rust Dynamic SQL