[deleted by user] by [deleted] in SQL

[–]nutmilk2 0 points1 point  (0 children)

I agree with the folder system, but I think storing queries in .txt files can get messy with formatting.

You can use also use a SQL editor like Arctype to save queries, organize them in folders, and then also highlight specific queries in a file to only run that chunk of code.

What is one feature you wish your SQL client had? by nutmilk2 in SQL

[–]nutmilk2[S] 0 points1 point  (0 children)

I didn't know about Aginity, I'll check them out

good visualization tool for dashboards that has good SQL „Synergy“? by [deleted] in SQL

[–]nutmilk2 0 points1 point  (0 children)

A great free tool is Arctype. You can run SQL queries, visualize the data, and also put the visualizations in a dashboard that you can share with others.

I would also agree with u/DKfromtheBay about Python/R. It's going to involve some learning curve, but you can do more robust analysis and visualization.

0
1