Databases
How to Use SQLite for Log Analysis From the Shell Fast
Analyze logs with SQLite from the shell: parse lines into a table, import, add indexes, run top-N and time bucket queries, and know when awk is enough.
7 min read
Tag
sqlite
2 posts
Databases
How to Use SQLite as a Local Store for Shell Scripts
Use SQLite as a local store for shell scripts: create tables idempotently, insert and query safely, handle concurrent runs with WAL and timeouts, and back up.
6 min read