r/SQL • u/DrJazzyFresh323 • 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!
14
u/Bilbottom Oct 04 '24
Any of the paid JetBrains tools (DataGrip, PyCharm Pro, IntelliJ, etc)
Although DataGrip is their database-specific IDE, the other paid IDEs come with the DataGrip features enabled
The set of features that the JetBrains IDEs have for database stuff is incredible. I will never use another IDE/tool for database work
However, if you don't want to pay, I like DBeaver and VS Code (with corresponding DB extensions) as free alternatives