7 ms·

If you have the license for it, it is hard to beat Datagrip from Jetbrains. Support for just about any database and also integrated support for AI/Copilot makin

If you have the license for it, it is hard to beat Datagrip from Jetbrains. Support for just about any database and also integrated support for AI/Copilot making it much easier to write exploratory queries.

osener 1y ago
For simpler use-cases I've used both https://dataflare.app/ https://dataflare.app/ and https://tableplus.com/ https://tableplus.com/ with success. They are much quicker and lighter to start-up, browse some tables and run some queries. Free versions are generous enough for daily use as well. For example for TablePlus "The free trial is limited to 2 opened tabs, 2 opened windows, 2 advanced filters (filters are not available on the free TablePlus Windows) at a time."
- cies 1y ago
  DBeaver is free, quite full featured (no AI) and FLOSS.
  - rsyring 1y ago
    But has a very complex and busy UI that, for whatever reason, makes it difficult/tiring for me to use. Very emblematic of it's Java GUI roots.
    - cies 1y ago
      Yeah. Some tools are used by many for a long time and get lots of features in the process... And some tools dont...
    - mixmastamyk 1y ago
      You can turn off most of them.
- eknkc 1y ago
  I love TablePlus. I basically use it for everything at this point even though I have a JetBrains all prod license. Never liked DataGrip.
schaum 1y ago
I used Datagrip like 10 years ago and it was amazing, back then I used some pre-release evaluation thingy, loved it, was only working with mysql though. last year i looked at it again, in a project where mongodb is used, it did not perform so well, sure the features where there, but still mongodb is document orientated so i had to come up with workarounds and so ... yeah back to cli unfortunately but for any relational database, I'd rather use datagrip!
wiether 1y ago
I suppose it has more advanced features than IntelliJ? Because when I switched to MacOS I had to find a replacement for HeidiSQL and, to my surprise, I was able to do everything I wanted to directly from IntelliJ, which was already my main IDE. https://www.jetbrains.com/help/idea/database-tool-window.html https://www.jetbrains.com/help/idea/database-tool-window.htm...
- redditor98654 1y ago
  I use the dedicated app but IntelliJ ultimate bundles datagrip into the ide too.

osener 1y ago

For simpler use-cases I've used both https://dataflare.app/ https://dataflare.app/ and https://tableplus.com/ https://tableplus.com/ with success. They are much quicker and lighter to start-up, browse some tables and run some queries. Free versions are generous enough for daily use as well. For example for TablePlus "The free trial is limited to 2 opened tabs, 2 opened windows, 2 advanced filters (filters are not available on the free TablePlus Windows) at a time."

cies 1y ago
DBeaver is free, quite full featured (no AI) and FLOSS.
- rsyring 1y ago
  But has a very complex and busy UI that, for whatever reason, makes it difficult/tiring for me to use. Very emblematic of it's Java GUI roots.
  - cies 1y ago
    Yeah. Some tools are used by many for a long time and get lots of features in the process... And some tools dont...
  - mixmastamyk 1y ago
    You can turn off most of them.
eknkc 1y ago
I love TablePlus. I basically use it for everything at this point even though I have a JetBrains all prod license. Never liked DataGrip.

schaum 1y ago

I used Datagrip like 10 years ago and it was amazing, back then I used some pre-release evaluation thingy, loved it, was only working with mysql though. last year i looked at it again, in a project where mongodb is used, it did not perform so well, sure the features where there, but still mongodb is document orientated so i had to come up with workarounds and so ... yeah back to cli unfortunately but for any relational database, I'd rather use datagrip!

wiether 1y ago

I suppose it has more advanced features than IntelliJ? Because when I switched to MacOS I had to find a replacement for HeidiSQL and, to my surprise, I was able to do everything I wanted to directly from IntelliJ, which was already my main IDE. https://www.jetbrains.com/help/idea/database-tool-window.html https://www.jetbrains.com/help/idea/database-tool-window.htm...

redditor98654 1y ago
I use the dedicated app but IntelliJ ultimate bundles datagrip into the ide too.