Dr. jonny phd on Nostr: Incredibly, the ancient sqlite3 driver in the ancient mozilla extension system that ...
Incredibly, the ancient sqlite3 driver in the ancient mozilla extension system that zotero uses for plugins cannot return the names of columns along with a query result, so i had to parse them myself and rescue the tragedy of like 15 years of technical debt in order to use even vaguely contemporary database tooling, but mother of lord i fuckin did it. it is now possible to use a database in a zotero plugin without sending yourself straight to hell.
https://github.com/p2p-ld/kysely-zotero-dialectPublished at
2024-12-04 03:46:47Event JSON
{
"id": "2a92c3518b4228885dd69c28c02ce0d9e13ed266df3d72886e3acefa8e7aa885",
"pubkey": "9926f6c53162329fcb33481f0c5db4a015bdd63d564636ea13c35d4975c176e3",
"created_at": 1733284007,
"kind": 1,
"tags": [
[
"proxy",
"https://neuromatch.social/users/jonny/statuses/113592500720301263",
"activitypub"
]
],
"content": "Incredibly, the ancient sqlite3 driver in the ancient mozilla extension system that zotero uses for plugins cannot return the names of columns along with a query result, so i had to parse them myself and rescue the tragedy of like 15 years of technical debt in order to use even vaguely contemporary database tooling, but mother of lord i fuckin did it. it is now possible to use a database in a zotero plugin without sending yourself straight to hell.\nhttps://github.com/p2p-ld/kysely-zotero-dialect",
"sig": "7ef30c4b5f275ac327e84573e821242fc3ab94aa04e53281580bd7042095ad6678e6522495f76069f3010741ef5adf143d0a5fc30088e79d33a1cf16e56da42b"
}
