News for hackers. Stuff that matters.

craftsquick

Re:Datasette is my data hammer on Wednesday January 18, 2023 @04:32AM (#34424927)
Really sorry about that -- I should've turned off test mode now for Google OAuth. Login work ok now?
Re:Datasette is my data hammer on Wednesday January 18, 2023 @03:38AM (#34424674)
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!
Re:Show HN: Explore 100M Medical Prices on Monday September 19, 2022 @02:07PM (#32901786)
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!

Show HN: No-code data analysis

https://www.shapedata.io/

Hey HN!We built Shape recently and would love to hear your thoughts. A lot of jobs now require making decisions with data in a database or warehouse. Unfortunately, most people don't know SQL.Shape plugs directly into a database or warehouse and allows you to do (almost anything) that SQL could do, but without code. There's a quick 2-min demo here: https://www.youtube.com/watch?v=r_Hq1hm-8bIIf...

( Read More... | no comments | on HN )
Re:Show HN: No-Code SQL Builder on Thursday May 12, 2022 @12:53AM (#31349430)
Thanks! Frontend: React/Redux and React Flow (for the graph) Backend: Node and Knex.js (for the query generation)
Re:Show HN: No-Code SQL Builder on Wednesday May 11, 2022 @01:07AM (#31336026)
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 :)

Re:Show HN: No-Code SQL Builder on Tuesday May 10, 2022 @11:58PM (#31335689)
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!

Show HN: No-Code SQL Builder

https://craftsql.com/

Hey everyone!I built a tool to help you visually build SQL queries - if you write a lot of SQL at work (or help people write it), check it out!You can try it out without needing to sign up, or integrate with any databases.Would love all your thoughts!Link: https://craftsql.com/

( Read More... | 6 comments | 15 points | on HN )

Show HN: CraftSQL helps you write SQL easily

https://craftsql.com/

Hey everyone!I'm a long-time reader, first-time poster. I built a tool to help you easily write SQL by building queries visually.I did this because (a) I used to write a lot of SQL in an old job and (b) my girlfriend now needs to write SQL for her job and she's very new to it. So if you write a lot of SQL for work (or help people that need to write their own SQL), check it out! I built this...

( Read More... | no comments | on HN )