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


106 bookmarks. First posted by pythoneer november 2017.


tool for creating and publishing JSON APIs for SQLite databases.
json  api  sqlite  tool  opensource  programming  python 
7 days ago by masukomi
Given how easy it is to turn a CSV into a SQL db, this is basically a universal API builder.
data:availability  data:sql 
january 2018 by phnk
A tool for creating and publishing JSON APIs for SQLite databases, instantly creating a url-based interface for accessing (but not writing) your data via JSON(o) calls.
data  database  app  osx 
january 2018 by Jswindle
RT : Datasette: instantly create and publish an API for your SQLite databases
from twitter_favs
january 2018 by rukku
You can try out out right now at fivethirtyeight.datasettes.com, where you can explore SQLite databases I built from Creative Commons licensed CSV files published by FiveThirtyEight. Or you can check out parlgov.datasettes.com, derived from the parlgov.
Archive 
december 2017 by rboulton
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.
data  tools  api  python  sqlite 
december 2017 by libbymiller
Datasette: instantly create and publish an API for your SQLite databases via Instapaper http://bit.ly/2zCvmYl
IFTTT  Instapaper 
november 2017 by javier.juarez
I just shipped the first public version of datasette, a new tool for creating and publishing JSON APIs for SQLite databases. You can try out out right now at fivethirtyeight.datasettes.com, ...
I just shipped the first public version of datasette, a new tool for creating and publishing JSON APIs for SQLite databases. You can try out out right now at fivethirtyeight.datasettes.com, ...
data  tools  python  sqlite  api  csv 
november 2017 by michaelfox
Click framework
sqlite  python  data  database  api  web  sql  tools  json  via:popular 
november 2017 by cantalaweb
A tool for creating and publishing JSON APIs for SQLite databases, instantly creating a url-based interface for accessing (but not writing) your data via JSON(o) calls.
api  sqlite  json  developer  via:ttscoff 
november 2017 by anglepoised
I just shipped the first public version of datasette, a new tool for creating and publishing JSON APIs for SQLite databases. You can try out out right now at fivethirtyeight.datasettes.com, ...
python  sql  api  database 
november 2017 by danimad
I just shipped the first public version of datasette, a new tool for creating and publishing JSON APIs for SQLite databases. You can try out out right now at fivethirtyeight.datasettes.com, ...
sqlite  api  json  sql  database 
november 2017 by mbischoff
store a flat table in the cloud. query via URL. retrieve JSON
sqlite  api  json  sql  cloud  eric  monson 
november 2017 by bikesandbooks
You can try out out right now at fivethirtyeight.datasettes.com, where you can explore SQLite databases I built from Creative Commons licensed CSV files published by FiveThirtyEight. Or you can check out parlgov.datasettes.com, derived from the parlgov. via Pocket
api  datasets  tools 
november 2017 by kintopp
Interesting thing for quickly packaging up data into read-only SQLite databases, suitable for deployment in containers/CDN as a REST API accessible SQL system
REST  API  SQLite  database  webdev 
november 2017 by asteroza
<p>I just shipped the first public version of datasette, a new tool for creating and publishing JSON APIs for SQLite databases.

You can try out out right now at <a href="https://fivethirtyeight.datasettes.com/">fivethirtyeight.datasettes.com</a>, where you can explore SQLite databases I built from Creative Commons licensed CSV files <a href="https://github.com/fivethirtyeight/data">published by FiveThirtyEight</a>. Or you can check out <a href="https://parlgov.datasettes.com/">parlgov.datasettes.com</a>, derived from the parlgov.org database of world political parties which illustrates some advanced features such as <a href="https://parlgov.datasettes.com/parlgov-25f9855/view_party">SQLite views</a>.</p>


Read-only, so people can't hack into your system. Willison is very smart - in 2009 he was in charge of the <a href="https://simonwillison.net/2009/Dec/20/crowdsourcing/">systems crowdsourcing MPs' expenses at The Guardian</a>, and made it happen in lightning time.
api  data  python  sqlite 
november 2017 by charlesarthur
@philbgorman lots of interesting tinkering things hidden away in here:
data  sqlite  publishing  hosting  parlidata  rapidApps  API 
november 2017 by psychemedia
You can try out out right now at fivethirtyeight.datasettes.com, where you can explore SQLite databases I built from Creative Commons licensed CSV files published by FiveThirtyEight. Or you can check out parlgov.datasettes.com, derived from the parlgov.
IFTTT  Pocket 
november 2017 by deepblue
fivethirtyeight.datasettes.com
api  data  python  tools 
november 2017 by tjwds
I just shipped the first public version of datasette, a new tool for creating and publishing JSON APIs for SQLite databases.

You can try out out right now at fivethirtyeight.datasettes.com, where you can explore SQLite databases I built from Creative Commons licensed CSV files published by FiveThirtyEight. Or you can check out parlgov.datasettes.com, derived from the parlgov.org database of world political parties which illustrates some advanced features such as SQLite views.
data  python  sqlite  tool  api  datasette  json 
november 2017 by cstanhope
This is a really cool project to make public data sets available via a JSON API. Datasette dynamically creates an API for any [SQLite database](http://sqlite.org), and there is a handy utility for Python to turn any CSV into a SQLite database. This writeup of [making a datasette for Polar Bears](https://gist.github.com/simonw/9f8bf23b37a42d7628c4dcc4bba10253) is a good overview. Super easy and simple project doing a good thing. [Listing of datasettes](https://github.com/simonw/datasette/wiki/Datasettes). 👏
november 2017 by thingles
App for publishing SQLite databases.
sqlite  python  data 
november 2017 by mr_stru
I just shipped the first public version of datasette, a new tool for creating and publishing JSON APIs for SQLite databases.

You can try out out right now at fivethirtyeight.datasettes.com, where you can explore SQLite databases I built from Creative Commons licensed CSV files published by FiveThirtyEight. Or you can check out parlgov.datasettes.com, derived from the parlgov.org database of world political parties which illustrates some advanced features such as SQLite views.
data  sqlite 
november 2017 by joek
I just shipped the first public version of datasette , a new tool for creating and publishing JSON APIs for SQLite databases. This will start a web server on http://127.0.0.1:8001/ displaying an interface that will let you browse your Chrome browser history, which is conveniently stored in a SQLite database. Datasette supports a limited form of filtering based on URL parameters, inspired by Django’s ORM. Datasette has a number of limitations in place here: it cuts off any SQL queries that take longer than a threshold (defaulting to 1000ms) and it refuses to return more than 1,000 rows at a time—partly to avoid too much JSON serialization overhead. SQLite is an incredible piece of technology, but it is rarely used in web application contexts due to its limitations with respect to concurrent writes.
november 2017 by sechilds
I just shipped the first public version of datasette, a new tool for creating and publishing JSON APIs for SQLite databases.
sqlite  python  data  api 
november 2017 by jberkel
I just shipped the first public version of datasette, a new tool for creating and publishing JSON APIs for SQLite databases.
api  data  sqlite 
november 2017 by gglnx