asg017/sqlite-lines

This is stars and forks stats for /asg017/sqlite-lines repository. As of 02 May, 2024 this repository has 375 stars and 9 forks.

sqlite-lines sqlite-lines is a SQLite extension for reading lines from a file or blob. See Benchmarks for more info. Usage .load ./lines0 select line from lines_read('logs.txt'); sqlite-lines is great for line-oriented datasets, like ndjson or JSON Lines, when paired with SQLite's JSON support. Here, we calculate the top 5 country participants in Google's Quick, Draw! dataset for calendars.ndjson: select line ->> '$.countrycode' as countrycode, count(*) from lines_read('./calendar.ndjson') group...