Event JSON
{
"id": "86c1ab682fe48aabbbfe5bad66d7e82cd46708e8e182c160e89eea3f70f5c356",
"pubkey": "a071462e960207a7a2272a3f59d042e59623bb2217b56f9365cba21e12213e3e",
"created_at": 1716321057,
"kind": 1,
"tags": [
[
"t",
"sqlite"
],
[
"t",
"cli"
],
[
"imeta",
"url https://assets.chaos.social/media_attachments/files/112/480/788/563/437/736/original/46240d7695a48a26.png",
"m image/png"
],
[
"proxy",
"https://chaos.social/@scy/112480816821162528",
"web"
],
[
"proxy",
"https://chaos.social/users/scy/statuses/112480816821162528",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://chaos.social/users/scy/statuses/112480816821162528",
"pink.momostr"
]
],
"content": "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.\n\nHere's mine:\nhttps://codeberg.org/scy/dotfiles/src/commit/dbe858184c07634d16065773e31bf6c1cb50b357/.sqliterc\n\nIt 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.\n\n#CLI\nhttps://assets.chaos.social/media_attachments/files/112/480/788/563/437/736/original/46240d7695a48a26.png\n",
"sig": "9377b9d403e7ff557fa3dad9baf753fec890a45a4f08f13f0773f9d2d5f5ad096977f0eb42abd95ec135db0aa0b405386edc9b8d272c0deddf298138ada03f71"
}