# SQLite-lines - 큰 파일을 라인단위로 읽는 확장

> Clean Markdown view of GeekNews topic #7099. Use the original source for factual precision when an external source URL is present.

## Metadata

- GeekNews HTML: [https://news.hada.io/topic?id=7099](https://news.hada.io/topic?id=7099)
- GeekNews Markdown: [https://news.hada.io/topic/7099.md](https://news.hada.io/topic/7099.md)
- Type: news
- Author: [xguru](https://news.hada.io/@xguru)
- Published: 2022-08-03T09:05:02+09:00
- Updated: 2022-08-03T09:05:02+09:00
- Original source: [github.com/asg017](https://github.com/asg017/sqlite-lines)
- Points: 6
- Comments: 0

## Topic Body

- NDJSON, JSON Lines, logs, txt 등의 파일  또는 Blob에서 빠르게 읽어들이는 확장   
- py-pandas 보다 52배, sqlite-utils 보다 18배, dsq 보다 16배 빠름   
- 사용법  
`.load ./lines0`  
`select  
  line ->> '$.countrycode' as countrycode,  
  count(*)  
from lines_read('./calendar.ndjson')`

## Comments



_No public comments on this page._