Mx Autumn :blobcatpumpkin: on Nostr: I thought I could simply add a geometry column to our existing technicians table and ...
I thought I could simply add a geometry column to our existing technicians table and add a spatial index to it... except MySQL doesn't support default values for geometry aside from null, and does not support spatial index on nullable columns
So a new table it is then...
Published at
2025-01-09 15:47:49Event JSON
{
"id": "ecfe3ab08bd7a7113ddcfcd992cb9666676acc1e6ca74243ed06485bdb1760f0",
"pubkey": "3631bd2fecc3cc8c0c8582027159251e0da96512c8fde867459de1de5ef4c94c",
"created_at": 1736437669,
"kind": 1,
"tags": [
[
"emoji",
"gonzo",
"https://media.notacult.social/custom_emojis/images/000/000/006/original/4aa50091744acfa3.png"
],
[
"proxy",
"https://notacult.social/users/carbontwelve/statuses/113799179101102535",
"activitypub"
]
],
"content": "I thought I could simply add a geometry column to our existing technicians table and add a spatial index to it... except MySQL doesn't support default values for geometry aside from null, and does not support spatial index on nullable columns :gonzo: \n\nSo a new table it is then...",
"sig": "a185771ef0f471129e5b852f593e3a2dfa48a5d5b915d07b980960c4a414b09288e20ced9793fb16d6e3dd71ac263bf71cc9438755434ba70385f73aaa32a3d8"
}