Deane Barker on Nostr: SQLite has great JSON support. You can store JSON in a field, query "into" the JSON, ...
SQLite has great JSON support. You can store JSON in a field, query "into" the JSON, and in my testing, it seems to be as fast as anything else. Handy for storing small arrays (think "tags").
Sounds like bad form, but it saves the complication of managing another table, foreign key, and join, so in most cases, it feels like wash to me.
Published at
2024-12-31 13:48:38Event JSON
{
"id": "c5758e508f537b5c891e2d5b15efb970f48bf88744a0b0e13a2b8ec4129178b7",
"pubkey": "666949cc57219f49a56ab43c01251ea16363c77a80398e32afa8698b07c4a697",
"created_at": 1735652918,
"kind": 1,
"tags": [
[
"proxy",
"https://contenttechtodon.org/users/deane/statuses/113747749658967848",
"activitypub"
]
],
"content": "SQLite has great JSON support. You can store JSON in a field, query \"into\" the JSON, and in my testing, it seems to be as fast as anything else. Handy for storing small arrays (think \"tags\").\n\nSounds like bad form, but it saves the complication of managing another table, foreign key, and join, so in most cases, it feels like wash to me.",
"sig": "dde2c82b922f0f83b52bd21f1a6d4ddd06c33d8e86cd5b6ecc9ed8dfb7cda445116dc6053dc945ea3a71410341c2b9e5a76e50b32fbde0d16ff62563d08224f4"
}
