I've used so many SQL GUIs and DataGrip is better than all of them in every way. From the top notch intellisense to the great GUI with safe and commitable changes, there's just so much that blows everyone else out of the water. I spent two years at one job settling for SequelPro, an old freeware MacOS SQL client. What the hell was wrong with me? For $8 a month, I could have felt much more comfortable and been more effective in my development.
I refunded my purchase.
I am curious how you went about learning all the features. There just seems to be so many and it can be a bit overwhelming.
Really 95% of the time I'm just using the code editor, intellisense, and search everywhere (shift shift shift). I'm glad the other features are there but it's totally fine to slowly discover them.
I think by default it also launches with a tip of the day feature, which you can manually browse through to see many of the tricks.
For the price of a coffee (and maybe a bagel) once a month, you get access to something that can save you hours a week. And if you ever stop subscribing, you can keep using the last licensed version you have, just without further upgrades. I don't think there is a better value anywhere in the software world. It costs even less (and gives way more) than MS Office.
If you need more than one IDE, it's more expensive, but still not bad at all. They also give free licenses to FOSS maintainers, along with significant discounts for startups, education, nonprofits, etc.
Each IDE is configured to:
- Not reformat code on its own
- Ignore whitespace
- Run `prettier` as a pre-commit hook
Those settings are saved to `.editorconfig` where possible, or to each IDE's repo-specific folder (e.g. `.idea`).
Then in theory each developer can use whatever IDE they want, whatever whitespace settings they want (tabs vs spaces), and the end code committed to the repo is still the same. It took a commit or three to set up and work out all the kinks, but afterward it ran flawlessly.
I enjoy it, but don't feel that many advantages over VSCode for my flow. (unfortuntely)