# Tip: Turn prodigy.db into web interface & JSON API with datasette **URL:** \ **Category:** Uncategorized\ **Tags:** usage\ **Created:** [November 14, 2017, 2:05am UTC](https://support.prodi.gy/t/tip-turn-prodigy-db-into-web-interface-json-api-with-datasette/87 "2017-11-14T02:05:30Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![ines](https://sea2.discourse-cdn.com/flex020/user_avatar/support.prodi.gy/ines/32/3_2.png) [@ines](https://support.prodi.gy/u/ines)\ **Post date:** [November 14, 2017, 2:05am UTC](https://support.prodi.gy/t/tip-turn-prodigy-db-into-web-interface-json-api-with-datasette/87/1 "2017-11-14T02:05:30Z")
Just came across this new library on Twitter and immediately thought of all the cool possibilities for Prodigy. Haven't had time yet to play around with this extensively, but it looks promising, so I thought I'd post it here in case anyone wants to give it a go. If you're using Prodigy with SQLite (the default database option), you should be able to simply point datasette at your `prodigy.db`, located in `~/.prodigy/prodigy.db` by default. This lets you view your datasets and collected annotations in your browser, and even share them with others. It might also be very helpful for debugging custom recipes, and to find out what exactly is stored in the database. > ⚠ **NOTE:** In order to only store each example once, the Prodigy SQLite database works with links that map example IDs to dataset IDs. This means that you can't get a nice, self-contained view of an individual dataset at this point. However, you can type in SQL queries! [https://twitter.com/simonw/status/930223164528902144](https://twitter.com/simonw/status/930223164528902144) > **[Datasette: instantly create and publish an API for your SQLite databases](https://simonwillison.net/2017/Nov/13/datasette/)** > > 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, …