Simon Willison’s Weblog

Subscribe

Entries tagged datasette in 2017

Filters: Type: entry × Year: 2017 × datasette × Sorted by date


Building a location to time zone API with SpatiaLite, OpenStreetMap and Datasette

Given a latitude and longitude, how can we tell what time zone that point lies within? Here’s how I built a simple JSON API to answer that question, using a combination of data from OpenStreetMap, the SpatiaLite extension for SQLite and my Datasette API tool.

[... 2185 words]

3:52 pm / 12th December 2017 / geospatial, openstreetmap, sqlite, timezones, datasette

New in Datasette: filters, foreign keys and search

I’ve released Datasette 0.13 with a number of exciting new features (Datasette previously).

[... 1143 words]

9:17 pm / 25th November 2017 / csv, projects, search, sqlite, datasette

Datasette: instantly create and publish an API for your SQLite databases

I just shipped the first public version of datasette, a new tool for creating and publishing JSON APIs for SQLite databases.

[... 968 words]

11:49 pm / 13th November 2017 / apis, json, projects, sqlite, webapis, sanic, docker, datasette

Types

Years

Months

Tags