flowpipe
xlite
flowpipe | xlite | |
---|---|---|
3 | 16 | |
300 | 1,230 | |
12.7% | - | |
9.9 | 0.9 | |
3 days ago | about 1 year ago | |
Go | Rust | |
GNU Affero General Public License v3.0 | 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.
flowpipe
- Show HN: Query Your Sheets with SheetSQL
- Cutting down AWS cost by $150k per year simply by shutting things off
-
Pipe Dreams: The life and times of Yahoo Pipes
Readers may enjoy Flowpipe [1], an open source cloud scripting engine we launched this week. It allows creation of pipelines in HCL to connect HTTP queries, run containers, execute lambda-compatible functions, query databases, etc all from your own machine / CLI. It can also be combined with Steampie[2], our open source project to query cloud resources (139+ plugins) with SQL. Yahoo Pipes was part of the inspiration for our naming of these "pipes" :-)
1 - https://github.com/turbot/flowpipe
xlite
-
Show HN: Query Your Sheets with SheetSQL
There is similar open-source project for Google Sheets: https://github.com/0x6b/libgsqlite (SQLite extension), which is a fork of https://github.com/x2bool/xlite (same idea but for Microsoft Excel spreadsheets)
-
Query Google Sheets as virtual tables with SQLite extension – libgsqlite
This project actually started as a fork of https://github.com/x2bool/xlite - SQLite extension for querying .xls and .xlsx spreadsheets.
-
A SQLite extension for reading large files line-by-line
Hey, author here, happy to answer any questions! Also checkout this notebook for a deeper dive into sqlite-lines, along with a slick WASM demonstration and more thoughts on the codebase itself https://observablehq.com/@asg017/introducing-sqlite-lines
I really dig SQLite, and I believe SQLite extensions will push it to another level. I rarely reach for Pandas or other "traditional" tools and query languages, and instead opt for plain ol' SQLite and other extensions. As a shameless plug, I recently started a blog series on SQLite and related tools and extensions if you want to learn more! Next week I'll be publishing more SQLite extensions for parsing HTML + making HTTP requests https://observablehq.com/@asg017/a-new-sqlite-blog-series
A few other SQLite extensions:
- xlite, for reading Excel files, in Rust https://github.com/x2bool/xlite
- sqlean, several small SQLite extensions in C https://github.com/nalgeon/sqlean
- mergestat, several SQLite extensions for developers (mainly Github's API) in Go https://github.com/mergestat/mergestat
- Processing Excel files in SQLite
- What's everyone working on this week (26/2022)?
- SQLite extension to query Excel spreadsheets (.xls, .xlsx, .ods)
- SQLite extension to query Excel (.xlsx, .xls, .ods) files as virtual tables
- Xlite。将Excel和Open Document电子表格作为SQLite虚拟表进行查询 (Xlite: Query Excel and Open Document spreadsheets as SQLite virtual tables)
- Interesting project? dynamic lib, .so .dll, Xlite SQLite
What are some alternatives?
spacedrive - Spacedrive is an open source cross-platform file explorer, powered by a virtual distributed filesystem written in Rust.
uom - Units of measurement -- type-safe zero-cost dimensional analysis
asammdf - a rust crate to parse and write ASAM MDF file.
dsq - Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more.
visidata - A terminal spreadsheet multitool for discovering and arranging data
advanced-formula-environment - Create, edit, and reuse formulas in Excel
Envy - Envy. Multi P2P Filesharing+Bittorrent, Shareaza Legacy.
rusqlite - Ergonomic bindings to SQLite for Rust
shallow-understanding - math library i don't know enough to finish lol
mergestat-lite - Query git repositories with SQL. Generate reports, perform status checks, analyze codebases. 🔍 📊
ffsend - :mailbox_with_mail: Easily and securely share files from the command line. A fully featured Firefox Send client.
textql - Execute SQL against structured text like CSV or TSV