simonw/datasette: An instant JSON API for your SQLite databases


42 bookmarks. First posted by aisamanra november 2017.


metafeather starred simonw/datasette
from:ifttt  github 
4 days ago by metafeather
Brilliant talk by at about very useful framework “datasette”:
from twitter
8 weeks ago by milele
Finally taking the time to play with datasette for a personal project
from twitter_favs
july 2018 by danbri
Github repo
Name: datasette
Tagline: Instantly publish structured data to the internet with a JSON API
Homepage: https://simonwillison.net/2017/Nov/13/datasette/
Languages:
JavaScript = 372736 bytes
Python = 285901 bytes
HTML = 20146 bytes
CSS = 4925 bytes

# Datasette

[![PyPI](https://img.shields.io/pypi/v/datasette.svg)](https://pypi.org/project/datasette/)
[![Travis CI](https://travis-ci.org/simonw/datasette.svg?branch=master)](https://travis-ci.org/simonw/datasette)
[![Documentation Status](https://readthedocs.org/projects/datasette/badge/?version=latest)](http://datasette.readthedocs.io/en/latest/?badge=latest)
[![License](https://img.shields.io/badge/license-Apache%202.0-blue.svg)](https://github.com/simonw/datasette/blob/master/LICENSE)

*An instant JSON API for your SQLite databases*

Datasette provides an instant, read-only JSON API for any SQLite database. It also provides tools for packaging the database up as a Docker container and deploying that container to hosting providers such as [Zeit Now](https://zeit.co/now).

Got CSV data? Use [csvs-to-sqlite](https://github.com/simonw/csvs-to-sqlite) to convert them to SQLite, then publish them with Datasette. Or try [Datasette Publish](https://publish.datasettes.com), a web app that lets you upload CSV data and deploy it using Datasette without needing to install any software.

Documentation: http://datasette.readthedocs.io/ Examples: https://github.com/simonw/datasette/wiki/Datasettes

## News

* 23rd May 2018: [Datasette 0.22.1 bugfix](https://github.com/simonw/datasette/releases/tag/0.22.1) plus we now use [versioneer](https://github.com/warner/python-versioneer)
* 20th May 2018: [Datasette 0.22: Datasette Facets](https://simonwillison.net/2018/May/20/datasette-facets)
* 5th May 2018: [Datasette 0.21: New _shape=, new _size=, search within columns](https://github.com/simonw/datasette/releases/tag/0.21)
* 25th April 2018: [Exploring the UK Register of Members Interests with SQL and Datasette](https://simonwillison.net/2018/Apr/25/register-members-interests/) - a tutorial describing how [register-of-members-interests.datasettes.com](https://register-of-members-interests.datasettes.com/) was built ([source code here](https://github.com/simonw/register-of-members-interests))
* 20th April 2018: [Datasette plugins, and building a clustered map visualization](https://simonwillison.net/2018/Apr/20/datasette-plugins/) - introducing Datasette's new plugin system and [datasette-cluster-map](https://pypi.org/project/datasette-cluster-map/), a plugin for visualizing data on a map
* 20th April 2018: [Datasette 0.20: static assets and templates for plugins](https://github.com/simonw/datasette/releases/tag/0.20)
* 16th April 2018: [Datasette 0.19: plugins preview](https://github.com/simonw/datasette/releases/tag/0.19)
* 14th April 2018: [Datasette 0.18: units](https://github.com/simonw/datasette/releases/tag/0.18)
* 9th April 2018: [Datasette 0.15: sort by column](https://github.com/simonw/datasette/releases/tag/0.15)
* 28th March 2018: [Baltimore Sun Public...
github  programming  github-starred-to-pinboard 
may 2018 by brianyang
GitHub is where people build software. More than 27 million people use GitHub to discover, fork, and contribute to over 80 million projects.
json  database  api  python  sqlite  csv  datasette 
may 2018 by iredwards
If you want to include licensing and source information in the generated datasette website you can do so using a JSON file that looks something like this: If you have Zeit Now or Heroku configured, datasette can deploy one or more SQLite databases to the internet with a single command: This will create a docker image containing both the datasette application and the specified SQLite database files. It will then deploy that image to Zeit Now or Heroku and give you a URL to access the API. Both publish and package accept an extra_options argument option, which will affect how the resulting application is executed.
may 2018 by sechilds
GitHub is where people build software. More than 27 million people use GitHub to discover, fork, and contribute to over 80 million projects.
python  sqlite  api  consulting  data  datascience  dataviz 
may 2018 by gregoltsov
Datasette provides an instant, read-only JSON API for any SQLite database. It also provides tools for packaging the database up as a Docker container and deploying that container to hosting providers such as Zeit Now.

Got CSV data? Use csvs-to-sqlite to convert them to SOLite, then publish them with Datasette. Or try Datasette Publish, a web app that lets you upload CSV data and deploy it using Datasette without needing to install any software.
database  json  SQL  SQLite  API  sharing  journalism  tools 
april 2018 by macloo
Yup, go nuts. It's an SQLite database running in a docker container ().
from twitter
april 2018 by russ
You might be thinking of ’s Datasette? There’s some associated CSV-to-SQLite tools.
from twitter
february 2018 by creature
Datasette provides an instant, read-only JSON API for any SQLite database. It also provides tools for packaging the database up as a Docker container and deploying that container to hosting providers such as Zeit Now.
development  data  database  SQL  sqlite  Python  github  api  json 
february 2018 by hex
attendees interested in quick and dirty APIs for data might find 's of interest
c4l18  from twitter
february 2018 by acdha
Instantly publish structured data to the internet with a JSON API
REST  database 
february 2018 by pgt150
A project from Simon Willison that provides an instant, read-only JSON API for any SQLite database.
january 2018 by shiflett

Datasette provides an instant, read-only JSON API for any SQLite database. It also provides tools for packaging the database up as a Docker container and deploying that container to hosting providers such as Zeit Now.

sqlite  python  database  publish  json  api 
january 2018 by tonious
datasette - An instant JSON API for your SQLite databases
python  database  api  json  sqlite 
november 2017 by geetarista
Nice utility from Simon Willison
technology  database  python  sqlite  api 
november 2017 by andy47
datasette - An instant JSON API for your SQLite databases
programming  databases  sqlite  apis  web_development 
november 2017 by kger
lmorchard starred simonw/datasette
github  needs-tags 
november 2017 by zhaocai
lmorchard starred simonw/datasette
github  needs-tags 
november 2017 by deusx