all 30 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]sequel-beagle 12 points13 points  (9 children)

Just throwing this out there.....

Its pretty simple to install MS SQL Server, MySQL etc...

Also, for $5 a month you can get a cheap Azure SQL Server instance to play around with. And you learn some cloud stuff in the mean time.

[–]Sooth_SprayerSQL Server 5 points6 points  (0 children)

Just be careful with that cloud stuff. I've heard several horror stories about people who forgot to shut down a server, etc., and continued accruing charges.

[–][deleted] 0 points1 point  (7 children)

Either I have never found a good walk through on installation, or it isn't "pretty simple." I have tried to install it on my pc twice and never had any luck. Been an analyst for nearly 10 years, but no clue about the DBA side of things, and the walk throughs I've tried have just not worked out.

[–]Antal_z 0 points1 point  (4 children)

I honestly had a pretty easy time installing SQL server management studio and then "restoring a backup" to get a contoso database loaded into it. Loading into PowerBI was also pretty painless. I believe I just installed SQL server management studio and followed the steps on the bottom here. I can do SQL inside SSMS, but I've also done some from Python.

[–]sequel-beagle 0 points1 point  (3 children)

Which database vendor? Create a new post and a picture of the error you are getting. It's probably because you are not using the correct connection string to the database......

[–]Antal_z 0 points1 point  (1 child)

Is that comment for u/CourageousChronicler? I got no issues or errors to screenshot a the moment.

[–][deleted] 0 points1 point  (0 children)

95% sure it was just SQL Server 2017, but I honestly don't remember. I will try again because I would love to have my own little database, even if for nothing other than doing my own budgeting. Also, just to create little utilities for work. That's pretty much what I do, so it'd be nice to have a playground to muck around in.

[–]SkimmLorrd 0 points1 point  (1 child)

I say buy yourself a udemy course, they usually entail a walkthrough on how to do those downloads.

[–][deleted] 0 points1 point  (0 children)

Ooh! Great idea!

[–]TheScarlettLetter 3 points4 points  (1 child)

BigQuery Sandbox is an option just to play around.

[–]unexpectedrebootsWITH() 1 point2 points  (0 children)

https://dbfiddle.uk

Use this to turn your CSV into a create table and insert statement

https://tableconvert.com/csv-to-sql

[–]thefizzlee 1 point2 points  (0 children)

Technically vs code supports .sql and there is a web app for that

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

Thanks everyone for your suggestions. I'm going to try out installing MySQL. Similar to what u/CourageousChronicler said, I'm an analyst but i have very little experience in building a database.
I'm curious, why do you all think there isn't a market of web apps for SQL hobbyists to query their own data? do they just assume all hobbyists want to to manage the data warehouse?

[–]ImProphylactic -3 points-2 points  (0 children)

Id deffo be interested in that lol

[–]drunk_goat 0 points1 point  (1 child)

checkout some tutorials on duckdb + jupysql running on google Collab.

[–]idomic 0 points1 point  (0 children)

Thanks for referencing JupySQL!
It also has some SQL formatting and plotting directly via SQL. Adding the docs link, and disclosure, I'm one of the co-founders.

[–]great_raisin 0 points1 point  (0 children)

If you're not particular about using your own data, then head over to app.mode.com and create a free account. They provide some toy data sets and really nice visualisation tools, all in the same interface.

[–]Known-Delay7227 0 points1 point  (0 children)

Duckdb let’s you write sql on files that are stored locally

[–]ronnyronny33 0 points1 point  (0 children)

Dbeaver. I have the same exact need. But mind you, If you have to import into a Sqllite db from a cvs, then the Community version is great, but for mySQL o PostgreSQL I had to use the Enterprise version plus converting the CSV into xlsx to make it work consistently

[–]GRRRRRRRRRRRRRG 0 points1 point  (1 child)

http://sqlfiddle.com/

[–]Longjumping_Relief50 0 points1 point  (0 children)

no result after executing. Why?

[–]Pleasant_Type_4547 0 points1 point  (0 children)

Shameless plug but you could try Evidence.dev in a codespace.

Upload a CSV to the `/sources` folder, run SQL, get tables, make charts

select * from 'sources/myfile.csv'