Norm
mammoth
| Norm | mammoth | |
|---|---|---|
| 3 | 4 | |
| 22 | 492 | |
| - | -0.2% | |
| 0.0 | 0.0 | |
| 10 months ago | 7 months ago | |
| Python | TypeScript | |
| GNU General Public License v3.0 or later | 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.
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.
mammoth
-
PostgresJs: The Fastest full featured PostgreSQL client for Node.js and Deno
Super happy user of this [1] it's rather minimalistic but great.
[1] https://github.com/Ff00ff/mammoth
- Mammoth: A type-safe Postgres query builder pur sang for TypeScript
-
Kysely — A type-safe SQL query builder for typescript
This looks awesome. I had previously used Mammoth, but will dig into your library this weekend. Great job!
-
Show HN: Write universally accessible SQL, not library-specific ORM wrapper APIs
In a type-safe environment I think you should just be able to switch your pur sang SQL builder to another dialect. Because of the type-safety you’ll be able to find incompatibilities at compile time which makes the migration easy enough (ignoring data migration). This avoids creating a weird ad hoc SQL dialect trying to fit all the others in a single API.
I work on Mammoth which is a pur sang Postgres query builder, see https://github.com/Ff00ff/mammoth.
What are some alternatives?
pure-orm - A pure ORM for writing native SQL queries yielding pure business objects
slonik - A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL.
pgdbf - Convert XBase / FoxPro databases to PostgreSQL
Sqlmancer - Conjure SQL from GraphQL queries 🧙🔮✨
rusqlite-model - Model trait and derive implementation for rusqlite
ucast - Conditions query translator for everything
Hangfire - An easy way to perform background job processing in .NET and .NET Core applications. No Windows Service or separate process required
pgsql-http - HTTP client for PostgreSQL, retrieve a web page from inside the database.
pitwall-pg - A postgres library to help write safe, parameterized, transaction-aware SQL for when an ORM or query builder isn't the right tool for the job