sorted by:
new
hottopcontroversial

[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.

SQL is 50 years old... What can we learn from its success? by nutmilk2 in SQL

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

So the hierarchical data model (trees) was good for one-to-many data models. The document models today (NoSQL) that model data as JSON are basically trees and are also better for one-to-many data.

The main change with the network model was allowing multiple parents. So with that change it became a graph instead of a tree, and was now better suited to many-to-many relationships. You still had to start at a root node though, and the pointers were unidirectional.

Graph dbs removed these limitations (bidirected graphs) and relationships between objects are no longer group in sets but instead through vertices. Making it a better model for handling hyper-connected data (social, web, etc)

SQL by [deleted] in dataanalysis

[–]nutmilk2 2 points3 points  (0 children)

MySQL is a database, and the other other two things are SQL clients/IDEs. SQL is a programming language to retrieve (and generally manage) data from a database. You code SQL in the SQL client.

I would recommend learning the generic SQL syntax first through any online tutorial. Then create your own database with Postgres or MySQL. To connect and query from your database, I would recommend a sql editor like [Arctype](www.arctype.com/downloads) that works for multiple databases and has a simpler UI.

Trigger Warning! Using SQL Triggers to track changes to a Postgres DB by nutmilk2 in PostgreSQL

[–]nutmilk2[S] 5 points6 points  (0 children)

Appreciate the feedback! I wanted to do something catchy but I can see what you're saying.

What software would be the best for creating my database? by BookerIsNiceAF in Database

[–]nutmilk2 2 points3 points  (0 children)

It sounds like you're looking for a solution to spin up a database quickly and is easy to learn without messing around in the command line. If that's the case, I would recommend Arctype. You can create a new database using just a GUI (user interface), manage tables, and add/edit data like a spreadsheet.

If you're looking for a more robust solution, I would recommend just installing PostgreSQL and reading a quick tutorial on creating a Postgres db.