Jeremy List on Nostr: T.I.L. Using sqlite from c or c++ when you're binding variables to a prepared ...
T.I.L. Using sqlite from c or c++ when you're binding variables to a prepared statement it uses 1 based indexing but when you're reading stuff from rows it uses 0 based indexing.
I'd really have preferred some consistency there, especially since the inconsistency is undocumented!
Published at
2024-05-15 02:44:34Event JSON
{
"id": "0191aae2facaae6f8dd008690045f10d5ba3c25e7b90cd7803b9e03c274465a9",
"pubkey": "52a02488c84a10a1ff1c12c2394fdec529db5b6b0af69ed5c855694701dcdd41",
"created_at": 1715741074,
"kind": 1,
"tags": [
[
"proxy",
"https://hachyderm.io/users/jeremy_list/statuses/112442807036715831",
"activitypub"
]
],
"content": "T.I.L. Using sqlite from c or c++ when you're binding variables to a prepared statement it uses 1 based indexing but when you're reading stuff from rows it uses 0 based indexing.\nI'd really have preferred some consistency there, especially since the inconsistency is undocumented!",
"sig": "c13c034330d9de61c2c5672a993cf533caefb144b0e4430ab2279c94209f556069aa442c2ba5bafeefad00f5aa110320d94f303ae003bf66f74c3fb0c2480d27"
}
