sqlite-lines
sqlite-lines copied to clipboard
asg017
A SQLite extension for reading large files line-by-line (NDJSON, logs, txt, etc.)
Window's isn't supported because `getdelim()`, the main function behind the entire project, isn't supported in Windows. I'm sure there's an easy workaround, I'm just not familiar with it, so more...
I tried running `make sqljs` on macOS (x86) - after first running `brew install emscripten` I got this error: ``` sqlite-lines % make sqljs emcc -O2 -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_DISABLE_LFS -DSQLITE_ENABLE_JSON1 -DSQLITE_THREADSAFE=0...
Hi, I'm using `lines0.so v0.1.1`. If I run this command on this [input csv file](https://gist.github.com/aborruso/fe965e7c89a0d51209225790c05ea782) ``` sqlite3 tmp.sqlite "select count(*) from lines_read('input.csv');" ``` I have the output in 0.229 seconds....
I love this project so much. Since you're already being quite ambitious with how you handle deployment, here's an idea I've been bouncing around for a while but haven't committed...
I found out the other day that GitHub blocks access to crawlers to pages in the repo other than the main README - which means https://github.com/asg017/sqlite-lines/blob/main/docs.md is unlikely to be...