pgress
postgraphile-plugin-connection-filter
pgress | postgraphile-plugin-connection-filter | |
---|---|---|
3 | 6 | |
2 | 279 | |
- | 0.0% | |
0.0 | 0.0 | |
about 1 year ago | 11 days ago | |
TypeScript | TypeScript | |
MIT License | 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.
pgress
-
Show HN: Open-source, browser-local data exploration using DuckDB-WASM and PRQL
Hey Marco, I'll take a look - filters theoretically should be fast, when you create a new filter, it simply reads does a `select * from table limit 1` to get column names
I wasn't sure whether you could query DBs directly from the browser but looks like you can! (https://github.com/alexanderguy/pgress) - will add it to roadmap!
-
The Database Package Manager for PostgreSQL Trusted Language Extensions
I had fun with a similar concept: just access the database from the browser using nginx/TLS/lua: https://github.com/alexanderguy/pgress
If you're good with your authenticated users directly talking to the DB (which there are plenty of uses for), it's a great way to get your data into the browser.
- Don’t we all just want to use SQL on the front end?
postgraphile-plugin-connection-filter
-
PostGraphile — The Gateway Drug To GraphQL
Connection Filter Plugin
-
Show HN: Graphweaver – Instant GraphQL API on Postgres, MySQL, SQLite and More
For example:
https://github.com/graphile-contrib/postgraphile-plugin-conn...
and
https://github.com/graphile/pg-aggregates
-
GraphQL server frameworks do NOT support ad hoc querying out of the box?
Have a look at PostGraphile (in case you are using JavaScript and a PostgreSQL DB). With the advanced connection filter plugin (https://github.com/graphile-contrib/postgraphile-plugin-connection-filter) you get an automatically created filter for multiple items and their connection.
-
Experiences with GraphQL and ORMs
The postgraphile-plugin-connection-filter I referred to is up-front about the fact that the filters it generates could allow a caller to form queries that would bring your server to its knees. So I'd have to do some work to limit what predicates were allowed.
-
Don’t we all just want to use SQL on the front end?
More examples here: https://github.com/graphile-contrib/postgraphile-plugin-conn...
(Personally, I think their docs are good at telling you how to use it but fairly bad at showing how great the tool is)
-
Is there a standard or best-practice syntax for passing down "filters" as arguments in GraphQL queries?
I really line the approach used here https://github.com/graphile-contrib/postgraphile-plugin-connection-filter
What are some alternatives?
storage-foundation-api-explainer - Explainer showcasing a new web storage API, NativeIO
supabase - The open source Firebase alternative.
mingo - MongoDB query language for in-memory objects
postgrest - REST API for any Postgres database
mongo-parse - A parser for mongo db queries and projections.
postgraphile-plugin-conn
HashQL-todos-sample
supavisor - A cloud-native, multi-tenant Postgres connection pooler.