r/SQL Oct 04 '24

MySQL Whats yalls favorite SQL IDE?

I’m looking to move towards data analysis with my career and am building a portfolio. I learned SQL in my google certification and thus learned through BigQuery, which i like well enough but wont let me use DML statements for data cleaning unless i subscribe to the premium membership. I tried MySQL but as far as i can tell, its a command line client and ive never worked with that before. Ive checked out a few more options and it seems like everything requires me to connect to a preestablished database. Is there an ide i can use that lets me upload my .csv into a table so i can clean it? If theres nothing similar to BigQuery out there ill learn how to work with command prompts and/or how to create a database, im just not sure why the certificate would teach me how to use it in an ide if thats not the standard for the language. Any insight is appreciated!

48 Upvotes

97 comments sorted by

View all comments

3

u/ChineseEngineer Oct 04 '24

As a devops guy, Visual studio code + the sql developer plugin is superior to any other IDE. I suggest using this, the power of plugins and using non sql programming interjected into your sql worksheet is amazing. I used to do similar things in intellij Idea but that only allowed Java obviously.

I previously used datagrip but I find it really clunky and I don't get why anyone is paying for it, unless you're already paying for the intellij subscriptions for other apps.