HNHacker News
TopNewBestAskShowJobs

craftsquick

144 karma · joined April 18, 2022

submissionscomments
craftsquick··on Datasette is my data hammer
Really sorry about that -- I should've turned off test mode now for Google OAuth. Login work ok now?
craftsquick··on Datasette is my data hammer
This is a self-plug but shapedata.io does similar things on top of Postgres -- it is much younger than Datasette, so has far fewer features, but should give you a similar exploration experience!
craftsquick··on Show HN: Explore 100M Medical Prices
Hey HN!

I downloaded and parsed through 100M prices negotiated by Blue Cross of Washington (Premera Blue Cross) for all their in-network healthcare procedures. I've compressed about 5TB of JSON data into much easier to work with tables that you can explore yourself. Excited to hear about what you find!

craftsquick··on Show HN: No-Code SQL Builder
Thanks! Frontend: React/Redux and React Flow (for the graph) Backend: Node and Knex.js (for the query generation)
craftsquick··on Show HN: No-Code SQL Builder
You should be able to build every SQL query with this. I built an example Top-N query here: https://imgur.com/a/2xKLltl

Right now building Top-N (and my example) assumes you know the rank function exists, but over time it should be easy enough to pre-build "nodes" that do things like this automatically :)

craftsquick··on Show HN: No-Code SQL Builder
The primary reason was that this was built in one weekend! The information_schema query is a great idea actually, I'll build that in -- thank you!