sqlite_protobuf
visidata
sqlite_protobuf | visidata | |
---|---|---|
2 | 36 | |
80 | 7,416 | |
- | - | |
0.0 | 9.8 | |
over 1 year ago | 8 days ago | |
C++ | Python | |
MIT License | GNU General Public License v3.0 only |
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_protobuf
-
One-liner for running queries against CSV files with SQLite
SQLite's virtual table API (https://www.sqlite.org/vtab.html) makes it possible to access other data structures through the query engine. You don't need to know much if anything about how the database engine executes queries, you only need to implement the callbacks it needs to do its job. A few years ago I wrote an extension to let me search through serialized Protobufs which were stored as blobs in a regular database.
https://github.com/rgov/sqlite_protobuf
-
SQLite Plus: all the missing SQLite functions
Some time ago I joined a project that was recording logs in Protobuf format. I demonstrated that we could log the serialized Protobuf structures to a SQLite database and then use a plugin to query across the message fields: https://github.com/rgov/sqlite_protobuf
Learning how to use the SQLite extension API was a little mind-expanding but it worked like a charm.
visidata
-
Fx – Terminal JSON Viewer
[4] "Is it possible to "flatten" structured data (like JSON?)": https://github.com/saulpw/visidata/discussions/1605
- jq 1.7 Released
-
Mapping LA's Soft-Story Building Earthquake Retrofit Program [OC]
Visidata - https://visidata.org
-
SQLite interface(s) for creating complex queries with a table that has 68 million rows?
You can try Visidata
-
Terminal Based Programs?
VisiData is an awesome terminal spreadsheet tool. edbrowse for internet browsing.
-
Plugin for pretty rendering of data?
Have you ever tried out visidata? It's not vim, but it's a terminal app with vim-like keybindings for visualizing tabular data (and it can convert from other types like json). Not quite a neovim buffer, but you could always open visidata in a new terminal buffer.
-
Ask HN: I'm looking for some new spreadsheet software what are people using?
If you are a command-line user, try visidata[0]
[0] https://github.com/saulpw/visidata
-
Hanukkah of Data: Advent of Code for Data Nerds
The datasets will be available as SQLite, JSONL, and CSV. This will be great for sharpening your SQL/Python/VisiData skills.
-
Hanukkah of Data: Advent of Code for Data Enthusiasts
Help Sarah find the family holiday tapestry before her father notices it's missing! Sharpen your SQL/Python/VisiData skills with Hanukkah of Data.
- Visidata - work with CSV / SQLlite / xls and other data files from the CLI
What are some alternatives?
dflat - Structured Data Store for Mobile
sc-im - sc-im - Spreadsheet Calculator Improvised -- An ncurses spreadsheet program for terminal
sqlite_ora_functions
miller - Miller is like awk, sed, cut, join, and sort for name-indexed data such as CSV, TSV, and tabular JSON
sqlite-plus - The ultimate set of SQLite extensions
sqlite-tui - A TUI for viewing and editing database files. [Moved to: https://github.com/mathaou/termdbms]
sqlite-parquet-vtable - A SQLite vtable extension to read Parquet files
tidy-viewer - 📺(tv) Tidy Viewer is a cross-platform CLI csv pretty printer that uses column styling to maximize viewer enjoyment.
json2csv - Convert json to csv with column titles
OpenRefine - OpenRefine is a free, open source power tool for working with messy data and improving it
xsv - A fast CSV command line toolkit written in Rust.
exa - A modern replacement for ‘ls’.