Post AS99odG99CLbpmXP5E by Sandbagger@ruby.social
 (DIR) More posts by Sandbagger@ruby.social
 (DIR) Post #AS99odG99CLbpmXP5E by Sandbagger@ruby.social
       2023-01-29T20:38:22Z
       
       0 likes, 0 repeats
       
       @simon I introduced #Datasette to a neighbour this evening and he was over the moon. He has a cool project but I've been sworn to secrecy. I'll spill the beans once the embargo is lifted.
       
 (DIR) Post #AS99odkzIX19NQy29g by simon@fedi.simonwillison.net
       2023-01-29T20:40:37Z
       
       0 likes, 0 repeats
       
       @Sandbagger can't wait to hear more about that!
       
 (DIR) Post #AS9D6N8S8PuGtw5cqu by Sandbagger@ruby.social
       2023-01-29T21:18:35Z
       
       0 likes, 0 repeats
       
       @simon He really liked the cluster map plugin, but then he was like 'I want to show the boundaries of these administrative units'. I think that the plugin uses  Leaflet.markercluster under the hood which accepts polygonOptions. Am I right in thinking that the plugin doesn't use it as an option? If so I am half tempted to have a stab at adding it to the plugin.
       
 (DIR) Post #AS9Dq26udXnz0y8rzc by simon@fedi.simonwillison.net
       2023-01-29T21:25:25Z
       
       0 likes, 0 repeats
       
       @Sandbagger there's a separate plugin that can do that: https://datasette.io/plugins/datasette-geojson-mapI wrote some nores on using that here - you don't need to use SpatiaLite though, retuning a geometry column with regular GeoJSON works fine too
       
 (DIR) Post #AS9E3sNZc8wOt6XI5A by simon@fedi.simonwillison.net
       2023-01-29T21:29:41Z
       
       0 likes, 0 repeats
       
       @Sandbagger this tutorial is also relevant - includes an example of displaying timezone and country borders https://datasette.io/tutorials/spatialite
       
 (DIR) Post #AS9EHUYOzd5p365r8a by Sandbagger@ruby.social
       2023-01-29T21:30:17Z
       
       0 likes, 0 repeats
       
       @simon Ace, thank you!
       
 (DIR) Post #ASH4k0Hu9XxwJWrxbc by Sandbagger@ruby.social
       2023-02-02T16:22:37Z
       
       0 likes, 0 repeats
       
       @simon I am being queried for options for hosting. Personally, I like fly.io (they have a great CLI) and I see here that you have another great plugin https://github.com/simonw/datasette-publish-flyTo your knowledge, the free tier should be able to accommodate an app consisting of no more than 4000 records right?
       
 (DIR) Post #ASH54BQgRFJIf1b8TI by simon@fedi.simonwillison.net
       2023-02-02T16:26:33Z
       
       0 likes, 0 repeats
       
       @Sandbagger the Fly free tier should handle up to 10,000,000 records quite happily, provided each record isn't too largeAlso worth considering Vercel - they have a good free tier which works for databases up to 50MB
       
 (DIR) Post #ASH5vyOX7KBls7F0dM by Sandbagger@ruby.social
       2023-02-02T16:35:59Z
       
       0 likes, 0 repeats
       
       @simon Great thank you!