sqlite-lines
xlite
sqlite-lines | xlite | |
---|---|---|
7 | 16 | |
384 | 1,230 | |
- | - | |
6.8 | 0.9 | |
7 months ago | about 1 year ago | |
C | Rust | |
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.
sqlite-lines
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?
rake-compiler-dock - Easy to use and reliable cross compiler environment for building Windows, Linux, Mac and JRuby binary gems.
spacedrive - Spacedrive is an open source cross-platform file explorer, powered by a virtual distributed filesystem written in Rust.
sqlite-jsonschema - A SQLite extension for validating JSON objects with JSON Schema
uom - Units of measurement -- type-safe zero-cost dimensional analysis
sqlite-fastrand - A SQLite extension for quickly generating random numbers, booleans, characters, and blobs
asammdf - a rust crate to parse and write ASAM MDF file.
sqlite-http - A SQLite extension for making HTTP requests purely in SQL
dsq - Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more.
sqlite-plus - The ultimate set of SQLite extensions
visidata - A terminal spreadsheet multitool for discovering and arranging data
gem-compiler - A RubyGems plugin that generates binary gems
advanced-formula-environment - Create, edit, and reuse formulas in Excel