pgress
storage-foundation-api-explainer
pgress | storage-foundation-api-explainer | |
---|---|---|
3 | 2 | |
2 | 65 | |
- | - | |
0.0 | 0.0 | |
about 1 year ago | over 2 years ago | |
TypeScript | ||
MIT License | Apache License 2.0 |
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?
storage-foundation-api-explainer
-
IndexedDB is completely broken in latest Safari
> There's even recent work to add even higher performance APIs into the Filesystem Access API and the reception from Firefox and Safari has been positive.
Positive as in: "FileSystem Access is a significant security risk and we're not going to implement this"? https://www.chromestatus.com/feature/6284708426022912
Positive as in "No, we don't want fifteen different file access apis, and we don't think Storage Foundation API is going anywhere"? https://www.chromestatus.com/feature/5670244905385984
And even though this is a draft created and authored exclusively by Googlers, even other Googlers are confused: https://github.com/WICG/storage-foundation-api-explainer/iss...
-
Don’t we all just want to use SQL on the front end?
i think it's changed names (maybe) since i've last seen it? but here is the low level io spec:
https://github.com/WICG/storage-foundation-api-explainer
What are some alternatives?
mingo - MongoDB query language for in-memory objects
standards-positions
mongo-parse - A parser for mongo db queries and projections.
firefox-ios - Firefox for iOS
HashQL-todos-sample
WebKit - Home of the WebKit project, the browser engine used by Safari, Mail, App Store and many other applications on macOS, iOS and Linux.
supavisor - A cloud-native, multi-tenant Postgres connection pooler.
daita - typed sql made simple
postgraphile-plugin-conn
datsync - Datomic <-> DataScript syncing/replication utilities
omnigres - Postgres as a Platform