9 ms·

How is no one talking about https://www.jetbrains.com/datagrip/ https://www.jetbrains.com/datagrip/ These guys actually fix their bugs. It works on every datab

How is no one talking about https://www.jetbrains.com/datagrip/ https://www.jetbrains.com/datagrip/ These guys actually fix their bugs. It works on every database known to humans, and also does nearly everything DBeaver appears to do.

dikei 8y ago
DBeaver support much more database products than Datagrip though.
dotjosh 8y ago
This, it's incredible. Amongs many other things, it supports a lot of the navigation/refactoring features of all the other IntelliJ products.
- danellis 8y ago
  Does it do anything the IntelliJ database plugin doesn't do?
yumraj 8y ago
Perhaps, but DBeaver is free while Datagrid is not, in fact it is rather expensive at $199. For many people, including me perhaps, something like DBeaver is good enough since it's free.
- crazysim 8y ago
  $90 individual https://www.jetbrains.com/datagrip/buy/#edition=personal https://www.jetbrains.com/datagrip/buy/#edition=personal But you're probably right.
  - neosavvy 8y ago
    If you are a student it's free. Also good tools are worth paying for, I have been a subscription user of their tools now for years. I think it's like $199 for a subscription to the whole suite. If you are a dev (or work for someone who expects you to do dev work for pay) it's worthy spending a few of your coins on good tools. I stare at these tools all darn day, and they rarely if ever crash. I don't regret moving away from Eclipse almost a decade ago, which used to devour all my system resources and crash and fail constantly.
    - endorphone 8y ago
      I agree wholeheartedly, and subscribe to the whole suite of JetBrains tools. Absolutely fantastic value.
      - h1d 8y ago
        Their all product pricing is pretty good value. If you need more than 2 of their tools (while using IntelliJ which covers half of their offerings), then you should switch to all products and quickly get to third year discount. I use IntelliJ, AppCode and that already means I should be using all products pack which I'm subscribed to.
    - crumpets 8y ago
      There are tons of tools in the open source world that are incredible and free. The assumption that you have to spend money on tools does not apply to software at all unless you are working in a proprietary ecosystem. What is the paid version of grep/ripgrep that works better?
      - thejosh 8y ago
        >good tools are worth paying for Not ALL tools need to be paid for.
        pjmlp 8y ago
        Not all WORK needs to be paid for.
        eitland 8y ago
        That is correct. Trivial example: If I say I'll do some work for free the we can assume you don't need to pay for it.
        pjmlp 8y ago
        Just like I should not complain if you decide not to keep doing it, when the need to pay for bills arises or I happened to abuse from your goodwill.
  - aedron 8y ago
    It's not the money, it's having to buy it.
- tomnipotent 8y ago
  > rather expensive at $199 Compared to a six-figure salary? Developers tools are a bargain for what we get out of them.
  - meddlepal 8y ago
    Developers are hands down one of the cheapest group of customers to deal with. I've been shelling out for IntelliJ Ultimate for years because I want to support JetBrains. At this point I think I could actually get away with just the open source Community Edition, but it's worth paying them for the effort in my mind.
    - tomnipotent 8y ago
      I love JetBrains, ever since I discovered ReSharper when I was still active in C# some 10 years go. Now I use PyCharm, DataGrip and GoLand on a daily basis and am happy to throw my money at them.
      - h1d 8y ago
        Isn't it becoming cheaper to go with all products pack at that point?
    - nerdponx 8y ago
      Is it common to buy your own tools in other skilled trades (when you aren't a freelancer)? I don't mind buying good software, but it feels weird for me to pay in order to make my employer more money. It's not like the productivity boost I get from buying Datagrip is going to get me a raise or a better job. That said, for software I use in my personal life I can and do pay, and I think we should all be more in the habit of either buying non-trial versions (Sublime, PyCharm) or making small monthly donations (Neovim, iTerm, regex101, QMK, et al).
      - dahdum 8y ago
        Mechanics are often required to buy their own tools. Higher end chefs are expected buy their own knives. Machinists are expected to buy many of their own instruments. It’s not universal but definitely not uncommon.
- h1d 8y ago
  It's about $8 a month and even lower on subsequent years. But the real power of DataGrip comes by using it in one of their IDE that auto completes table and column names inside code and allows you to shift-click it to get to see the definition and show warning when you specify an unknown field.
wyqydsyq 8y ago
The software is great but I would never buy it purely because of their business model. There is absolutely no reason DataGrip needs to be a subscription service. There aren't any ongoing costs for customers to use it. It should be a one-off purchase with optional support subscription, maybe requiring re-purchase at major version increments, not this bullshit where you need to maintain a subscription for a license on a binary program you already paid for and installed. Feels as dodgy as Adobe turning Photoshop into a subscription service Fuck these business models and the sales idiots who try to apply them to every single product
- chamakits 8y ago
  Just so you know, although not very clearly documented, yearly subscriptions include perpetual license for that specific version. You can see it on the “buy” page. It’s still less than ideal, but I pay yearly for their “all pack” product and I feel with the amount I use it I’ve gotten my money’s worth every year.
  - doxavore 8y ago
    This. The JetBrains licensing model is great. Subscribe to get updates, with a perpetual fallback license for the last version when your subscription lapsed. Their old versions also continue to work across OS upgrades, etc. If you subscribe, the annual fee decreases substantially for the first few years. This is nothing like Adobe's Creative Cloud.
    - rolleiflex 8y ago
      I thought their fallback perpetual license is actually for the version you had when you purchased it, not for the version that was available when your subscription lapsed? Not sure if they changed this recently - I stopped following them when they switched to subscription with fairly onerous terms (which they rectified after backlash to ‘mediocre’, but never to ‘fair value’).
      - doxavore 8y ago
sqlcook 8y ago
Nice if you’re only connecting to a single instance, nightmare if you have multiple. DbVisualizer is better imho.
milin 8y ago
Prolly does not work on redis
- tyldum 8y ago
  Enterprise version, like with Influxdb as well.
crawrey 8y ago
DataGrip is great. My previous workplace used to be locked into the Microsoft ecosystem and the core legacy product was backed onto a Microsoft SQL Server DB. Over the years we pushed the business to move away from the MS/Windows ecosystem. When this happened, like many others, I looked for a UNIX compatible DB client that supported SQL Server. First, I tried SQuirreL[1] and it was horrible. I just had to uninstall it and keep looking. I settled on DBeaver for a while as it has some nice features and it did most of the things I needed it to, but it was not particularly polished. Eventually the business decided to pay for Jetbrain's All Products package which includes DataGrip and from my experience you could say: Eclipse is to IntelliJ IDEA what DBeaver is to DataGrip. The other product I was looking closely at was Navicat for SQL Server[2], which looks pretty damn good and those who use it seem to swear by it. However, I am not a DBA and for that reason I can't justify the USD$699 personal licence price tag of Navicat. DataGrip is not perfect, but it's pretty damn close and I think its price tag is well justified. 1. http://squirrel-sql.sourceforge.net/ http://squirrel-sql.sourceforge.net/ 2. https://www.navicat.com/en/store/navicat-for-sqlserver/ https://www.navicat.com/en/store/navicat-for-sqlserver/
- sixdimensional 8y ago
  I paid for and use Navicat and it has always been stable, fast and good. A little pricey as you say, but good.
- worble 8y ago
  I've never personally used it, but I'm fairly sure you can use Azure Data Studio[0] for plain MSSQL databases, despite Azure being in the name. I'd be in interested in what people think of it, since I've never seen anyone talk about this in the wild. [0]https://github.com/Microsoft/azuredatastudio https://github.com/Microsoft/azuredatastudio
- h1d 8y ago
  Have you tried TablePlus? (Not the author but just want to know the experience if you have.)
  - crawrey 8y ago
mu_killnine 8y ago
It works on every database known to humans Our team just bought a bunch of licenses of DBeaver and I think this is only correct if you mean 'relational' databases. We have a MongoDB and Eleastic and I don't believe that DataGrip supports either of these, which was a real drag. We're fully on Jetbrains tools otherwise (R#, dotTrace and dotMemory, TeamCity as build server) so it was a no brainer for me to want to continue that trend but it didn't check all the boxes for us, despite its clear polish. I tend to hate any IDE built on Eclipse (which I think DBeaver is), but I've been very pleasantly surprised with how well it works. 1. It's got very nice ER modeling where other tools (Like Oracle SQL Developer) make you jump through a dozen screens and a wizard to make a simple diagram. 2. It's got nice export tools to get your data to business partners in a more convenient way. Sure you can copy tables in pretty much every tool but there's just an 'excel' button that can pop open your current query in a new sheet. 3. It does have a weird delay when opening up databases sometimes where it 'reads metadata' about the table and it can sometimes take a long time to return even the most basic query. But once it's cached that data I've not noticed problems after that. 4. It does seem like the document database tooling isn't as baked as the relation tooling. I routinely get hangs when querying my Mongo collections, which is sometimes a drag. But it hasn't been a huge issue. Overall, I'd highly recommend the paid version of this tool as it's helped me consolidate: Robo3T, Sql Server Mgmt Studio, SQL Developer, and MySQL Workbench into a single tool.
akfanta 8y ago
> It works on every database known to humans Except any non-relational DBs.
h1d 8y ago
I tried to like it and used it for a few months but eventually got back to SequelPro and it just feels breeze to use when every operation is so snappy not to mention an instant launch. The embedded DataGrip can be a good tool inside one of their IDE though.

dikei 8y ago

DBeaver support much more database products than Datagrip though.

dotjosh 8y ago

This, it's incredible. Amongs many other things, it supports a lot of the navigation/refactoring features of all the other IntelliJ products.

danellis 8y ago
Does it do anything the IntelliJ database plugin doesn't do?

yumraj 8y ago

Perhaps, but DBeaver is free while Datagrid is not, in fact it is rather expensive at $199. For many people, including me perhaps, something like DBeaver is good enough since it's free.

crazysim 8y ago
$90 individual https://www.jetbrains.com/datagrip/buy/#edition=personal https://www.jetbrains.com/datagrip/buy/#edition=personal But you're probably right.
- neosavvy 8y ago
  If you are a student it's free. Also good tools are worth paying for, I have been a subscription user of their tools now for years. I think it's like $199 for a subscription to the whole suite. If you are a dev (or work for someone who expects you to do dev work for pay) it's worthy spending a few of your coins on good tools. I stare at these tools all darn day, and they rarely if ever crash. I don't regret moving away from Eclipse almost a decade ago, which used to devour all my system resources and crash and fail constantly.
  - endorphone 8y ago
    I agree wholeheartedly, and subscribe to the whole suite of JetBrains tools. Absolutely fantastic value.
    - h1d 8y ago
      Their all product pricing is pretty good value. If you need more than 2 of their tools (while using IntelliJ which covers half of their offerings), then you should switch to all products and quickly get to third year discount. I use IntelliJ, AppCode and that already means I should be using all products pack which I'm subscribed to.
  - crumpets 8y ago
    There are tons of tools in the open source world that are incredible and free. The assumption that you have to spend money on tools does not apply to software at all unless you are working in a proprietary ecosystem. What is the paid version of grep/ripgrep that works better?
    - thejosh 8y ago
      >good tools are worth paying for Not ALL tools need to be paid for.
      - pjmlp 8y ago
        Not all WORK needs to be paid for.
        eitland 8y ago
        That is correct. Trivial example: If I say I'll do some work for free the we can assume you don't need to pay for it.
        pjmlp 8y ago
        Just like I should not complain if you decide not to keep doing it, when the need to pay for bills arises or I happened to abuse from your goodwill.
- aedron 8y ago
  It's not the money, it's having to buy it.
tomnipotent 8y ago
> rather expensive at $199 Compared to a six-figure salary? Developers tools are a bargain for what we get out of them.
- meddlepal 8y ago
  Developers are hands down one of the cheapest group of customers to deal with. I've been shelling out for IntelliJ Ultimate for years because I want to support JetBrains. At this point I think I could actually get away with just the open source Community Edition, but it's worth paying them for the effort in my mind.
  - tomnipotent 8y ago
    I love JetBrains, ever since I discovered ReSharper when I was still active in C# some 10 years go. Now I use PyCharm, DataGrip and GoLand on a daily basis and am happy to throw my money at them.
    - h1d 8y ago
      Isn't it becoming cheaper to go with all products pack at that point?
  - nerdponx 8y ago
    Is it common to buy your own tools in other skilled trades (when you aren't a freelancer)? I don't mind buying good software, but it feels weird for me to pay in order to make my employer more money. It's not like the productivity boost I get from buying Datagrip is going to get me a raise or a better job. That said, for software I use in my personal life I can and do pay, and I think we should all be more in the habit of either buying non-trial versions (Sublime, PyCharm) or making small monthly donations (Neovim, iTerm, regex101, QMK, et al).
    - dahdum 8y ago
      Mechanics are often required to buy their own tools. Higher end chefs are expected buy their own knives. Machinists are expected to buy many of their own instruments. It’s not universal but definitely not uncommon.
h1d 8y ago
It's about $8 a month and even lower on subsequent years. But the real power of DataGrip comes by using it in one of their IDE that auto completes table and column names inside code and allows you to shift-click it to get to see the definition and show warning when you specify an unknown field.

wyqydsyq 8y ago

The software is great but I would never buy it purely because of their business model. There is absolutely no reason DataGrip needs to be a subscription service. There aren't any ongoing costs for customers to use it. It should be a one-off purchase with optional support subscription, maybe requiring re-purchase at major version increments, not this bullshit where you need to maintain a subscription for a license on a binary program you already paid for and installed. Feels as dodgy as Adobe turning Photoshop into a subscription service Fuck these business models and the sales idiots who try to apply them to every single product

chamakits 8y ago
Just so you know, although not very clearly documented, yearly subscriptions include perpetual license for that specific version. You can see it on the “buy” page. It’s still less than ideal, but I pay yearly for their “all pack” product and I feel with the amount I use it I’ve gotten my money’s worth every year.
- doxavore 8y ago
  This. The JetBrains licensing model is great. Subscribe to get updates, with a perpetual fallback license for the last version when your subscription lapsed. Their old versions also continue to work across OS upgrades, etc. If you subscribe, the annual fee decreases substantially for the first few years. This is nothing like Adobe's Creative Cloud.
  - rolleiflex 8y ago
    I thought their fallback perpetual license is actually for the version you had when you purchased it, not for the version that was available when your subscription lapsed? Not sure if they changed this recently - I stopped following them when they switched to subscription with fairly onerous terms (which they rectified after backlash to ‘mediocre’, but never to ‘fair value’).
    - doxavore 8y ago

sqlcook 8y ago

Nice if you’re only connecting to a single instance, nightmare if you have multiple. DbVisualizer is better imho.

milin 8y ago

Prolly does not work on redis

tyldum 8y ago
Enterprise version, like with Influxdb as well.

crawrey 8y ago

DataGrip is great. My previous workplace used to be locked into the Microsoft ecosystem and the core legacy product was backed onto a Microsoft SQL Server DB. Over the years we pushed the business to move away from the MS/Windows ecosystem. When this happened, like many others, I looked for a UNIX compatible DB client that supported SQL Server. First, I tried SQuirreL[1] and it was horrible. I just had to uninstall it and keep looking. I settled on DBeaver for a while as it has some nice features and it did most of the things I needed it to, but it was not particularly polished. Eventually the business decided to pay for Jetbrain's All Products package which includes DataGrip and from my experience you could say: Eclipse is to IntelliJ IDEA what DBeaver is to DataGrip. The other product I was looking closely at was Navicat for SQL Server[2], which looks pretty damn good and those who use it seem to swear by it. However, I am not a DBA and for that reason I can't justify the USD$699 personal licence price tag of Navicat. DataGrip is not perfect, but it's pretty damn close and I think its price tag is well justified. 1. http://squirrel-sql.sourceforge.net/ http://squirrel-sql.sourceforge.net/ 2. https://www.navicat.com/en/store/navicat-for-sqlserver/ https://www.navicat.com/en/store/navicat-for-sqlserver/

sixdimensional 8y ago
I paid for and use Navicat and it has always been stable, fast and good. A little pricey as you say, but good.
worble 8y ago
I've never personally used it, but I'm fairly sure you can use Azure Data Studio[0] for plain MSSQL databases, despite Azure being in the name. I'd be in interested in what people think of it, since I've never seen anyone talk about this in the wild. [0]https://github.com/Microsoft/azuredatastudio https://github.com/Microsoft/azuredatastudio
h1d 8y ago
Have you tried TablePlus? (Not the author but just want to know the experience if you have.)
- crawrey 8y ago

mu_killnine 8y ago

It works on every database known to humans Our team just bought a bunch of licenses of DBeaver and I think this is only correct if you mean 'relational' databases. We have a MongoDB and Eleastic and I don't believe that DataGrip supports either of these, which was a real drag. We're fully on Jetbrains tools otherwise (R#, dotTrace and dotMemory, TeamCity as build server) so it was a no brainer for me to want to continue that trend but it didn't check all the boxes for us, despite its clear polish. I tend to hate any IDE built on Eclipse (which I think DBeaver is), but I've been very pleasantly surprised with how well it works. 1. It's got very nice ER modeling where other tools (Like Oracle SQL Developer) make you jump through a dozen screens and a wizard to make a simple diagram. 2. It's got nice export tools to get your data to business partners in a more convenient way. Sure you can copy tables in pretty much every tool but there's just an 'excel' button that can pop open your current query in a new sheet. 3. It does have a weird delay when opening up databases sometimes where it 'reads metadata' about the table and it can sometimes take a long time to return even the most basic query. But once it's cached that data I've not noticed problems after that. 4. It does seem like the document database tooling isn't as baked as the relation tooling. I routinely get hangs when querying my Mongo collections, which is sometimes a drag. But it hasn't been a huge issue. Overall, I'd highly recommend the paid version of this tool as it's helped me consolidate: Robo3T, Sql Server Mgmt Studio, SQL Developer, and MySQL Workbench into a single tool.

akfanta 8y ago

> It works on every database known to humans Except any non-relational DBs.

h1d 8y ago

I tried to like it and used it for a few months but eventually got back to SequelPro and it just feels breeze to use when every operation is so snappy not to mention an instant launch. The embedded DataGrip can be a good tool inside one of their IDE though.