just curious which editor is mostly used for SQL on mac I used to use Notepad++ on Windows but have not moved to Mac.
Sublime text. Or you use RStudio if you’re familiar with dbplyr.
DataGrip
Does Amazon not have licenses for a product like DBVisualizer? That's what I'd pick, and get my company to pay for it.
Nope. We do not have that
Sublime text is generally my weapon of choice.
Datgrip
Vim
PyCharm Pro. PyCharm Pro has Datagrip integrated into it, plus all the niceness of a full blown IDE. Best integration I've ever used.
VSCode
Can I also use it for R and Python?
https://marketplace.visualstudio.com/items?itemName=Ikuyadeu.r https://code.visualstudio.com/docs/languages/python