Datasette Publish
Data
data publishing
SHOW HN2018
101points
21comments
#432of 2,155 in 2018
Top 21%of 2018 by points
How HN took it
MixedNo clear lean
5 positive, 4 neutral or asking, 0 mixed, 1 critical, out of 10 comments about the project. Thread score +0.29.
Idea: 2 for, 1 againstPerformance: 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
Handles large datasets well via read-only SQLite
From 2 comments
this was a key answer to a good question. I think you should emphasize that part (handling large data sets) as a key aspect of datasette
lozzo on HNSize. The San Francisco trees database is around 50MB, and I've successfully tested it with multiple GB sized SQLite databases.
simonw on HN
Useful for charting and dynamic web data
From 1 comment
This can be a good solution to use with JS charting libraries that pull CSV/JSON data from an external data source. Add dynamic chart updates on source data updates and you get…
dgudkov on HN
Objections
Static JSON blob on a CDN could work without an API
From 1 comment
Why not convert the data from csv to json and serve the json blob from your object store or CDN (if this solution is immutable)? No need for the API interface, just gzip the json…
toomuchtodo on HN
Unclear use cases for convert-to-JSON-API tools
From 1 comment
been seeing a lot of these convert X into JSON api with query ...but what would be the use cases for this type of tool? who needs this type of solution?
pwaai on HN
Requests
Support adding new CSVs later and deduplication
From 1 comment
This is awesome. Could this be extended so that new CSV uploads can be added at a later date and deduplicate?
brandonlipman on HN
Questions
Who needs this and for what use cases
From 1 comment
been seeing a lot of these convert X into JSON api with query ...but what would be the use cases for this type of tool? who needs this type of solution?
pwaai on HN
Alternatives named
data.world SQL support
From 1 comment
Related option for those who are less focused on the JSON API and instead want to make their datasets public and queryable: data.world added SQL support a little while back,…
dmeeker on HN
xmysql for MySQL databases
From 1 comment
Xmysql: One command to generate api for any MySql database. Generates api at blink of an eye (literally). https://github.com/o1lab/xmysql Has some really nice apis for group by,…
o1lab on HN