scy on Nostr: Did you know that you can have a #SQLite CLI config file? Pretty handy for changing ...
Did you know that you can have a #SQLite CLI config file? Pretty handy for changing the default memory limit, output format, or even print a nice banner.
Here's mine:
https://codeberg.org/scy/dotfiles/src/commit/dbe858184c07634d16065773e31bf6c1cb50b357/.sqliterc
It allows SQLite to use up to 1 GiB of page cache, uses nice Unicode box drawing characters, and tracks the runtime of queries by default. It also reminds me of how to turn these things off again.
#CLI
Here's mine:
https://codeberg.org/scy/dotfiles/src/commit/dbe858184c07634d16065773e31bf6c1cb50b357/.sqliterc
It allows SQLite to use up to 1 GiB of page cache, uses nice Unicode box drawing characters, and tracks the runtime of queries by default. It also reminds me of how to turn these things off again.
#CLI