pgress
tad
pgress | tad | |
---|---|---|
3 | 3 | |
2 | 3,016 | |
- | - | |
0.0 | 7.3 | |
about 1 year ago | 12 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?
tad
-
Show HN: Open-source, browser-local data exploration using DuckDB-WASM and PRQL
Very impressive project and vision! Love the demo!
I am also ex-GS and worked on what I am fairly sure is the table display tool you're describing. I tried to carry the essential aspects of that work (multi-level pivots, with drill-down to the leaf level, and all interactive events and analytics supported by db queries) to Tad (https://www.tadviewer.com/, https://github.com/antonycourtney/tad), another open source project powered by DuckDb.
An embeddable version of Tad, powered by DuckDb WASM, is used as the results viewer in the MotherDuck Web UI (https://app.motherduck.com/).
If you're interested in embedding Tad in Pretzel, or leveraging pieces of it in your work, or collaborating on other aspects of DuckDb WASM powered UIs, please get in touch!
- Building a database to search Excel files
-
Consider Using CSV
Since this is about CSV, this is obligatory tool for larger ones:
* https://github.com/antonycourtney/tad
What are some alternatives?
storage-foundation-api-explainer - Explainer showcasing a new web storage API, NativeIO
parquet-go - pure golang library for reading/writing parquet file
mingo - MongoDB query language for in-memory objects
rill - Rill is a tool for effortlessly transforming data sets into powerful, opinionated dashboards using SQL. BI-as-code.
mongo-parse - A parser for mongo db queries and projections.
KeenWrite - Free, open-source, cross-platform desktop Markdown text editor with live preview, string interpolation, and math.
HashQL-todos-sample
bsv - maximum performance data processing
supavisor - A cloud-native, multi-tenant Postgres connection pooler.
js-bson - BSON Parser for node and browser
postgraphile-plugin-conn
duckdb-wasm - WebAssembly version of DuckDB