Simon Willison’s Weblog

Subscribe

Items tagged spatialite in Jan

Filters: Month: Jan × spatialite × Sorted by date


Weeknotes: AI hacking and a SpatiaLite tutorial

Short weeknotes this time because the key things I worked on have already been covered here:

[... 477 words]

7:45 pm / 15th January 2023 / spatialite, ai, datasette, weeknotes, gpt3, openai, generativeai, vectorsearch, llms

Datasette 0.64, with a warning about SpatiaLite

I release Datasette 0.64 this morning. This release is mainly a response to the realization that it’s not safe to run Datasette with the SpatiaLite extension loaded if that Datasette instance is configured to enable arbitrary SQL queries from untrusted users.

[... 675 words]

9:22 pm / 9th January 2023 / security, spatialite, datasette, annotatedreleasenotes

Drawing shapes on a map to query a SpatiaLite database (and other weeknotes)

This week I built a Datasette plugin that lets you query a database by drawing shapes on a map!

[... 950 words]

6:50 am / 24th January 2021 / gis, projects, spatialite, sqlite, datasette, weeknotes

geojson-to-sqlite (via) I just put out the first release of geojson-to-sqlite—a CLI tool that can convert GeoJSON files (consisting of a Feature or a set of features in a FeatureCollection) into a table in a SQLite database. If you use the --spatialite option it will initalize the table with SpatiaLite and store the geometries in a spacially indexed geometry field—without that option it stores them as GeoJSON. # 31st January 2020, 6:40 am

Types

Years

Tags