3 ms·

The Jetbrains IDEs all have a database explorer built in. Which is handy for (local) databases related to your project. If you write SQL directly in your app i

• ajford 6y ago
  Yup. And they're tremendously useful (and the reason I don't normally need a db workbench tool). However, at a past employer, I inherited an absolutely awful CMS/fulfillment system/CRM hybrid that was bad at all parts of it's purpose. It proved to be dramatically more efficient to have a full blown DB tool just dedicated to exploring and interfacing with that monstrosity's database and have my regular PyCharm instance for code dev and light touches against the DB. Additionally, at another time it proved nearly impossible to get the IDE db explorer to work properly with the jdbc drivers for a couple of large-scale hosted data lakes, but was rather straightforward in DataGrip. I have no clue why it was an issue with the explorer in PyCharm, but since I got it working in DataGrip I rather quickly moved on and accepted that I was gonna use DataGrip for the data lakes. That said, I definitely love the db explorer feature, and recommend everyone take a look at it if you're already using a JetBrains product. Also, just another shout-out to JetBrains again for their hybrid subscription/lifetime ownership license approach, demonstrating that paid software can exist in the realm of linux systems and that you can make a successful company without resorting to bleeding your customers dry over subscription fees.