sqlite-parquet-vtable
visidata
sqlite-parquet-vtable | visidata | |
---|---|---|
4 | 36 | |
261 | 7,416 | |
- | - | |
10.0 | 9.8 | |
almost 3 years ago | 8 days ago | |
C++ | Python | |
Apache License 2.0 | 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-parquet-vtable
-
Universal Database
Sqlite3 has parquet extension that support parquet (https://github.com/cldellow/sqlite-parquet-vtable) as virtual table. I use sqlite3 a lot, for work and personally. It's really good, but I do have issue with large datasets, mainly due VACUUM operations. Insertion rate drops significantly when single table hits around 20M rows. Indexing is important for your query speed, but it'll impact your write speed.
-
Show HN: Easily Convert WARC (Web Archive) into Parquet, Then Query with DuckDB
Well there's a virtual table extension to read parquet files in SQLite. I've not tried it myself. https://github.com/cldellow/sqlite-parquet-vtable
-
One-liner for running queries against CSV files with SQLite
/? sqlite arrow
- "Comparing SQLite, DuckDB and Arrow with UN trade data" https://news.ycombinator.com/item?id=29010103 ; partial benchmarks of query time and RAM requirements [relative to data size] would be
- https://arrow.apache.org/blog/2022/02/16/introducing-arrow-f... :
> Motivation: While standards like JDBC and ODBC have served users well for decades, they fall short for databases and clients which wish to use Apache Arrow or columnar data in general. Row-based APIs like JDBC or PEP 249 require transposing data in this case, and for a database which is itself columnar, this means that data has to be transposed twice—once to present it in rows for the API, and once to get it back into columns for the consumer. Meanwhile, while APIs like ODBC do provide bulk access to result buffers, this data must still be copied into Arrow arrays for use with the broader Arrow ecosystem, as implemented by projects like Turbodbc. Flight SQL aims to get rid of these intermediate steps.
> - One cannot create a trigger on a virtual table.
Just posted about eBPF a few days ago; opcodes have costs that are or are not costed: https://news.ycombinator.com/item?id=31688180
> - One cannot create additional indices on a virtual table. (Virtual tables can have indices but that must be built into the virtual table implementation. Indices cannot be added separately using CREATE INDEX statements.)
It looks like e.g. sqlite-parquet-vtable implements shadow tables to memoize row group filters. How does JOIN performance vary amongst sqlite virtual table implementations?
> - One cannot run ALTER TABLE ... ADD COLUMN commands against a virtual table.
Are there URIs in the schema? Mustn't there thus be a meta-schema that does e.g. nested structs with portable types [with URIs], (and jsonschema, [and W3C SHACL])?
/? sqlite arrow virtual table
- sqlite-parquet-vtable reads parquet with arrow for SQLite virtual tables https://github.com/cldellow/sqlite-parquet-vtable :
$ sqlite/sqlite3
-
Show HN: WarcDB: Web crawl data as SQLite databases
https://github.com/cldellow/sqlite-parquet-vtable
But for my use case virtual would be too complicated.
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?
duckdb - DuckDB is an in-process SQL OLAP Database Management System
sc-im - sc-im - Spreadsheet Calculator Improvised -- An ncurses spreadsheet program for terminal
WarcDB - WarcDB: Web crawl data as SQLite databases.
miller - Miller is like awk, sed, cut, join, and sort for name-indexed data such as CSV, TSV, and tabular JSON
zsv - zsv+lib: tabular data swiss-army knife CLI + world's fastest (simd) CSV parser
sqlite-tui - A TUI for viewing and editing database files. [Moved to: https://github.com/mathaou/termdbms]
sqlite_protobuf - A SQLite extension for extracting values from serialized Protobuf messages
tidy-viewer - 📺(tv) Tidy Viewer is a cross-platform CLI csv pretty printer that uses column styling to maximize viewer enjoyment.
datasette - An open source multi-tool for exploring and publishing data
OpenRefine - OpenRefine is a free, open source power tool for working with messy data and improving it
qhs - SQL queries on CSV and TSV files
exa - A modern replacement for ‘ls’.