Datasette
Data
sqlite api publishing
SHOW HN2017
How HN took it
4 positive, 9 neutral or asking, 1 mixed, 2 critical, out of 16 comments about the project. Thread score +0.16.
Execution: 1 for, 2 againstIdea: 2 for, 0 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Useful idea for publishing datasets; congratulated on launch
From 3 comments
Congrats for the launch! I was searching for such tool exact yesterday:) I understand the benefits of Immutable pattern, but it'll be nice if datasettle could provide interface…
wsxiaoys on HNCool little utility. Like the fact you can pass SQL in the query string. Have to look for a use for this. Maybe internal use apps that update SQLite periodically from a larger…
mythrwy on HNThis is really cool! It'd be fun to have a GraphQL variant of this.
dangoor on HN
Name praised as brilliant
From 1 comment
The name is brilliant.
dgudkov on HN
Objections
Requires Cloudflare in the demos, a negative for some deployers
From 1 comment
This looks great except for the fact that it runs through cloudflare, that's a big negative for me and will restrict a little my ability to deploy this. However, I can still see…
rmbeard on HN
Does not work on Windows
From 1 comment
Disappointed this doesn't work on Windows, looks really cool.
ccarse on HN
No support for writable databases
From 1 comment
Congrats for the launch! I was searching for such tool exact yesterday:) I understand the benefits of Immutable pattern, but it'll be nice if datasettle could provide interface…
wsxiaoys on HN
Requests
Writable API or interface for periodic updates
From 2 comments
Congrats for the launch! I was searching for such tool exact yesterday:) I understand the benefits of Immutable pattern, but it'll be nice if datasettle could provide interface…
wsxiaoys on HNCongrats on shipping! I have a sqlite DB with historical Visa data, and I want to expose it as an API (like your software does), but with API key. Not a python user here, can you…
justboxing on HN
GraphQL variant
From 2 comments
This is really cool! It'd be fun to have a GraphQL variant of this.
dangoor on HNI'd also like to see the GraphQL version of this, mainly because of GraphQL's strongly typed schema definitions. Means less work required to validate inputs.
ZenoArrow on HN
API key or authentication support
From 1 comment
Congrats on shipping! I have a sqlite DB with historical Visa data, and I want to expose it as an API (like your software does), but with API key. Not a python user here, can you…
justboxing on HN
Questions
How pagination works
From 1 comment
Any examples of how it handles pagination? Couldn't find it in the README.md
anonfunction on HN
Whether the Datasette name conflicts with the Commodore trademark
From 1 comment
Does Commodore own the trademark for the Datasette name?
timbit42 on HN
Alternatives named
PostgREST
From 1 comment
See also: PostgREST, which turns a PostgreSQL database into a rest API. https://postgrest.com/
hamandcheese on HN
sandman2
From 1 comment
The "REST API for your database" thing isn't actually the part of this I'm most excited about - there are quite a few entries in that category already, such as…
simonw on HN
sqlite-web
From 1 comment
The immutable thing is pretty key to the whole project - if you do need a writable API there are a few options out there already though. https://github.com/coleifer/sqlite-web…
simonw on HN
xmysql
From 1 comment
shameless plug (for MySql) : https://github.com/o1lab/xmysql ``` XMYSQL : One command to generate REST APIs for any MySql Database. > 20+ releases to npm in last 2 weeks. > Have…
o1lab on HN
SQLiteProxy
From 1 comment
Shameless plug: I made something similar a while back - https://github.com/assafmo/SQLiteProxy Not as fancy as OP's, but runs great in production since last June :-)
assafmo on HN