pgress
postgraphile-plugin-conn
pgress | postgraphile-plugin-conn | |
---|---|---|
3 | 2 | |
2 | - | |
- | - | |
0.0 | - | |
about 1 year ago | - | |
TypeScript | ||
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-conn
-
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
-
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)
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
postgraphile-plugin-connection-filter - Filtering on PostGraphile connections
mongo-parse - A parser for mongo db queries and projections.
HashQL-todos-sample
Graphweaver - Turn multiple data sources into a single GraphQL API
supavisor - A cloud-native, multi-tenant Postgres connection pooler.
omnigres - Postgres as a Platform
pg-aggregates - Aggregates for PostGraphile connections