Norm
graphile-engine
Norm | graphile-engine | |
---|---|---|
3 | 6 | |
22 | 753 | |
- | 0.1% | |
0.0 | 5.8 | |
10 months ago | 17 days ago | |
Python | JavaScript | |
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.
graphile-engine
- Sketch of a Post-ORM
-
Business Logic Inside Database - How Evil Is It?
But it doesn’t have to work this way. Some modern databases support a feature called "row-level security". It allows you to define access control policies at the row level based on the current user’s attributes (id, role, group membership, etc.). As long as the application can securely pass the current user’s identity to the database, it can leave all authorization checking to the database. And since the rules are defined at the table level instead of the API level, it has a much smaller surface to protect. The "row-level security" feature is the foundation of products like PostgREST, PostGraphile, and Supabase.
- PostgREST – Serve a RESTful API from Any Postgres Database
-
You may not need an SQL query builder or ORM
I really love the way pg-sql2 is going about that.
-
Ask HN: Solo Dev Stack of 2022?
I've been enjoying developing on top of PostGraphile. https://www.graphile.org/
Good starter: https://github.com/graphile/starter
I can add a column the the db, and my frontend gets that autimagically (in dev mode, it generates a graphql schema out of the db, and from that it creates composables for my frontend wiht graphql-codegen). On the frontend I use Vue 3, the starter is build with nextjs/react.
-
Best resource to learn PL/pgSQL?
I don't much direct knowledge on the internals, but here's a snippet from the graphile-engine repo README:
What are some alternatives?
pure-orm - A pure ORM for writing native SQL queries yielding pure business objects
starter - Opinionated SaaS quick-start with pre-built user account and organization system for full-stack application development in React, Node.js, GraphQL and PostgreSQL. Powered by PostGraphile, TypeScript, Apollo Client, Graphile Worker, Graphile Migrate, GraphQL Code Generator, Ant Design and Next.js
pgdbf - Convert XBase / FoxPro databases to PostgreSQL
pgsql-http - HTTP client for PostgreSQL, retrieve a web page from inside the database.
rusqlite-model - Model trait and derive implementation for rusqlite
annuaire-entreprises-sirene-api
mammoth - A type-safe Postgres query builder for TypeScript.
postgrest-starter-kit - Starter Kit and tooling for authoring REST API backends with PostgREST
Hangfire - An easy way to perform background job processing in .NET and .NET Core applications. No Windows Service or separate process required
sqlc - Generate type-safe code from SQL
slonik - A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL.
datasette - An open source multi-tool for exploring and publishing data