1–7 of 7 posts
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/
Show HN: No-Code SQL Builder
craftsql.com
Why did you decide not to connect to the database and pull the schema info automatically? If you don't want to connect, you could write a query against the information_schema to give to your users to run and paste the results back into craft.
What level of sophisticated queries can be created with it? For example, can it do "Top N and Other"? Which BTW, was recently added for SQL Frames ( https://sqlframes.com/docs/data_sets/top_n_other_sets )
Most of these visual SQL builders I have seen only tackle the basic level of SQL. I am interested in an advanced SQL builder myself to plug as a no-code SQL builder to front the SQL Frames API.
Nice work and great use of React Flow. What level of sophisticated queries can be created with it? For example, can it do "Top N and Other"? Which BTW, was recently added for SQL Frames ( https://sqlframes.com/docs/data_sets/top_n_other_sets ) Most of these visual SQL builders I have seen only tackle the basic level of SQL. I am interested in an advanced SQL builder myself to plug as a no-code SQL builder to front th…
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 :)
Why did you decide not to connect to the database and pull the schema info automatically? If you don't want to connect, you could write a query against the information_schema to give to your users to run and paste the results back into craft.
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!
Earlier quoted context omitted.
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!
Wow , a lot got done in one weekend. Could you please share which framework/libraries/tools you use to build it ?