# datasette

- Page: https://shared.btbytes.com/p/datasette
- Date: 2020-12-12
- Tags: database, sqlite, datasette

[Datasette](https://datasette.io/) is a tool for exploring and publishing data. Uses sqlite for storing data and is written in python and exposes the db over a web interface. support adhoc querying (made posible by mounting the database file in Readonly mode, so destructive operations are possible).

The author -- [Simon Willison](https://simonwillison.net/) has [substack newsletter](https://datasette.substack.com/) for the project.


How he uses datasette -- ["What is the killer app for datasette"](https://news.ycombinator.com/item?id=33218438); Oct 2022.


[datasette.io, an official project website for Datasette](https://simonwillison.net/2020/Dec/13/datasette-io) -- a blog post detailing how datasette is used to publish a website, in this case the website of the project itself. which uses the [The Baked Data architectural pattern](https://simonwillison.net/2021/Jul/28/baked-data/).