shallow-understanding
xlite
| shallow-understanding | xlite | |
|---|---|---|
| 1 | 16 | |
| 0 | 1,230 | |
| - | - | |
| 6.1 | 0.9 | |
| almost 2 years ago | about 1 year ago | |
| Rust | Rust | |
| - | 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.
shallow-understanding
-
What's everyone working on this week (26/2022)?
Trying to figure out algebra! I'm sure someone has already done it, but I'm a beginner and it seems like a good learning project https://github.com/ZacharyAllwein/shallow-understanding
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?
Envy - Envy. Multi P2P Filesharing+Bittorrent, Shareaza Legacy.
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
rusqlite - Ergonomic bindings to SQLite for Rust
mergestat-lite - Query git repositories with SQL. Generate reports, perform status checks, analyze codebases. 🔍 📊