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


87 bookmarks. First posted by pythoneer 9 days ago.


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 
3 days ago by michaelfox
Click framework
sqlite  python  data  database  api  web  sql  tools  json  via:popular 
4 days ago 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 
4 days ago 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 
5 days ago by danimad
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 
6 days ago by ttscoff
Another great addition to my SQlite toolset
from twitter
6 days ago by thej
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 
6 days ago by mbischoff
store a flat table in the cloud. query via URL. retrieve JSON
sqlite  api  json  sql  cloud  eric  monson 
7 days ago by bikesandbooks
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 
8 days ago 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 
9 days ago by charlesarthur
@philbgorman lots of interesting tinkering things hidden away in here:
data  sqlite  publishing  hosting  parlidata  rapidApps  API 
9 days ago 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 
9 days ago by deepblue
fivethirtyeight.datasettes.com
api  data  python  tools 
9 days ago 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 
9 days ago 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). 👏
9 days ago by thingles
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 
9 days ago 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.
9 days ago 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 
9 days ago 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 
9 days ago by gglnx
instant api and ui around a sqlite db
sqlite  api  data 
9 days ago by jkriss
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, ...
9 days ago by martinbalfanz