Releases

DataGrip 1.0 (formerly 0xDBE): A new IDE for DBs and SQL

Hi there,

For a year and a half we ran an Early Access Program (EAP) for this product while it was still known as 0xDBE. At some point one needs to stop and draw the line.

We thank all of you who gave us feedback and we’re looking forward to your help with the following versions.

So please welcome DataGrip 1.0, our IDE for databases and SQL!

DataGrip1_splash@2x

Access major database management systems

  • Big players on the market: Oracle, SQL Server, DB2, Sybase
  • Popular among the community: MySQL, PostgreSQL
  • Small but useful: SQLite, Apache Derby, HyperSQL and H2

Modify database objects and get resulting scripts

DataGrip provides a UI for operations like creating/modifying tables and managing their columns, keys and indices. Execute generated code at once, or open it in the text editor and continue to work with the DDL script directly.

modify

Write SQL efficiently and avoid repetitive coding

With DataGrip you can write code faster by making use of code completion. Just start typing the name of a database object, identifier or variable to get a list of matching suggestions. DataGrip is aware of dependencies for completing JOIN clauses, can suggest types of parameters for functions and procedures, and describe table structure for INSERT statements. There are Live Templates for generating conventional parts of statements – use the default ones and create new ones as well.

complletion

Navigate through the code and rename as you type

DataGrip resolves object references in SQL files. If you rename a variable or alias, they will be renamed throughout the code. If you rename database objects from SQL, they will also be renamed in the actual database.

The IDE shows usages of objects (table, column, etc.) or variables in dedicated views. Navigation tools help you select an object in various contexts like the editor, schema view, and others.

refactorings

Work with data and explore relationships

Powerful table editor lets you add, remove, edit, and clone data rows. Use the filter text field to see only the data you need, without writing WHERE clauses. The other way to find what you need is the text search. It’s helpful if you don’t know which exact column contains the data you’re looking for. Regular expressions are available in the text search. Navigate through the data by foreign keys—you can go to the data your row is referring to and vice versa.

tableeditor

Profile queries and compare results

Choose what you want DataGrip to do when the Execute button is clicked—execute the subquery, execute the outer query, or execute the whole script. Do you want a particular part of code to be executed? Just select it and run. Execution plan is provided. Result-set is similar to the table editor with the same options available including adding/deleting rows, text search, and data navigation. Compare two result-sets in diff viewer.

executing

DataGrip is based on IntelliJ Platform which brings:

  • Text editor with multiple cursors and syntax-aware selection
  • Version control systems integration: Git, Subversion, etc.
  • Plugin ecosystem: Terminal, Textmate bundles, etc.

See DataGrip features page for CSV editor, diagrams, parameterized queries and more.

FAQ

Is DataGrip available via JetBrains ToolBox as part of the “All Products” pack?
Yes, it is available both as a Single IDE and as part of “All Products.” If you already have “All Products,” you can already use DataGrip.

Does DataGrip repeat the functionality of the database tools in other JetBrains IDEs?
Yes, the first version focuses on that core functionality.

Can I use DataGrip with SQL dialects that are not listed?
Yes, JDBC driver is the only requirement.

Are stored code debugging, administration tools and NoSQL features planned?
Yes, we’re going to add this functionality in future versions.

Can I suggest a feature or communicate my feedback?
Yes! Please talk to us via the feedback form, issue tracker, community forums, and Twitter.

Yours,
The DataGrip team
_
JetBrains
The Drive to Develop

Comments below can no longer be edited.

117 Responses to DataGrip 1.0 (formerly 0xDBE): A new IDE for DBs and SQL

  1. Avatar

    Rymson Balentien says:

    December 16, 2015

    I love 0xDBE and I’ve used it quite a lot this past year, submitting bugs and feature requests whenever I felt it was appropriate, and I want to congratulate you on your v1 release! That said I’m not sure yet I feel as 0xDBE was ready to go live..We are still missing important schema information within the tool (triggers and constraints being the most important). I’m also not sure if the text-only explain plan cuts it, as the ‘raw desc’ column which sometimes contains useful information is unreadable, as it contains too much information (SQLSERVER). Are these features still being worked on? I guess I’ll sit 0xDBE out until january 9th, when my current install expires and see what to do from there. The only issue is that I can’t see myself working with SSMS anymore either.. 🙂

    • Avatar

      Rymson Balentien says:

      December 16, 2015

      I just wanted to add that even though there are some issues I still think 0xDBE is currently the best tool out there!

      • Avatar

        Don says:

        December 19, 2015

        Have you tried DbVisualizer?

    • Avatar

      Maksim Sobolevskiy says:

      December 17, 2015

      Thank you for your feedback, Rymson! Since you are one of the most active EAPers and, in fact, our advocate, we plan to give you a one year licence for DataGrip for free.

      • Avatar

        Rymson Balentien says:

        January 7, 2016

        Dear Maksim,

        I’m sorry I am replying this late. I missed this comment. Indeed I received a license from you guys for which I am very grateful! I’ve recently switched jobs so I haven’t posted many bug requests, but don’t worry I will stay as active as ever before (as well as get my colleagues to use it as well!)

        • Avatar

          Maksim Sobolevskiy says:

          January 11, 2016

          Ha! Thank you so much! You are the person whom we really appreciate. I hope you like your new job! 🙂

    • Avatar

      Maksim Sobolevskiy says:

      October 31, 2017

      Some time passed and now we support triggers and constraints 🙂

  2. Avatar

    Graham says:

    December 16, 2015

    This repeats the functionality in Intellij, but does it add any more features over and above Intellij? If they are equal right now, will that always be the case? Would be nice to see a feature comparison chart.

    • Avatar

      Andrey Cheptsov says:

      December 17, 2015

      The latest version of IntelliJ IDEA Ultimate includes the functionality of DataGrip 1.0. Still, DataGrip is focused on working with databases and SQL and thus may provide better user experience as a standalone IDE.

  3. Avatar

    trailmax says:

    December 17, 2015

    How large the databases can this tool handle? I’ve got a DB with hundreds of tables, with hundreds of fields inside of each table, many thousands of views, sprocs, functions. Many third-party tools just choke on this monster, only SSMS barely handles it. Can your tool handle large set of objects?

    • Avatar

      Maksim Sobolevskiy says:

      December 17, 2015

      Hi! We can handle this kind of databases. So, please download a trial and make sure of it. If there would be some troubles we are always glad to help.

      • Avatar

        trailmax says:

        December 17, 2015

        ah, nevermind. Can’t even connect to local sqlexpress instance.

        • Avatar

          Maksim Sobolevskiy says:

          December 21, 2015

          Why? What is the problem?

          • Avatar

            trailmax says:

            December 21, 2015

            I get “Unable to connect to the instance because there possibly network issue blah-blah…”. But instance is online, TCP/IP connectivity is enabled and I can access it through SSMS.
            Possibly issue with SQL Server 2008RC2 – quite dated now, but suspect the jdbc drivers are crap – I’ve spent hours fighting them trying to get TeamCity to work on SQL Server.

          • Avatar

            trailmax says:

            December 21, 2015

            Drop me an email to trailmax1@gmail.com if need more info for debugging.

        • Avatar

          Maksim Sobolevskiy says:

          December 22, 2015

          Hi! Can you please provide a screenshot of connection window?
          Very often case is when the port number points to the other place than an instance name, and port number has a priority.
          If you still have problems, let’s continue via email.

          Is it possible to connect with JDTS driver?

          We actually support 2008RC2.

          • Avatar

            trailmax says:

            January 18, 2016

            Sorry, missed this message. I don’t get notifications for some reason.

            Here is the screenshot: http://i.imgur.com/CMq8hLp.png
            Now I’m trying to connect to SQL Server 2012 with Windows Authentication – just the same as with 2008R2.

            I have TCP/IP connections enabled on both instances (2008R2 and 2012) and SQL Server Browser has always been turned on – as Anton suggested below.

        • Avatar

          Anton says:

          January 9, 2016

          I’m not a developer of this program, but faced with the same problem.
          Next two steps:
          1. Enable tcp/ip in sql server configuration manager
          2. Enable SQL Server Browser service (stopped by default)
          Helped me solve this problem

        • Avatar

          Maksim Sobolevskiy says:

          January 20, 2016

          Max, let’s try the following at first: just remove the port number and try to connect.

          • Avatar

            Tate Griffin says:

            February 14, 2016

            Removing the port and only specifying the host and instance worked for me.

    • Avatar

      Bruno Paschoali says:

      February 15, 2016

      Hi.

      Problably, your problem is firewall blocking the port that you are using. Try to desativate firewall just for test.

  4. Avatar

    Mihai says:

    December 17, 2015

    This sounds great. What I need it to be is a competitor to Sql Server Data Tools.

    It should let me write only the create table statement (or stored proc etc) and automatically diff with a deployed database. From that it needs to generate an update script that I can use on that database. If this is not already there can we get a youtrack request for this and +1 it?

    Obviously it must have version control and the smart suggestions we’ve come to expect from JetBrains.

  5. Avatar

    Leo Lozes says:

    December 17, 2015

    Just tested it for a few minutes, hoping that I could dump Toad and use this instead. The first things I noticed:

    – There’s no editing in the result grid when you execute a statement from a table with the ROWID attribute (like Toad does). It’s pretty useful.
    – The XMLTYPE editing doesn’t seem to work well, I get an [72000][1461] ORA-01461 error.
    – The PL/SQL packages are not parsed correctly, almost everything is in red.

    On the other side:
    – Very easy to configure, I got my three connections working in 5 minutes.
    – The autocomplete works great.

  6. Avatar

    Albatros says:

    December 17, 2015

    Is there any support for sqlite in the future

    • Avatar

      Maksim Sobolevskiy says:

      December 17, 2015

      We have SQLite support.

  7. Avatar

    Michal says:

    December 17, 2015

    Will thee be some community version or student license?

    I have used it a lot with postgres, I have got quite used to it.

    Thanks

    • Avatar

      Maksim Sobolevskiy says:

      December 17, 2015

      There is no community version but you can always get a free license as a student.
      Check this please https://www.jetbrains.com/student/

  8. Avatar

    Jake Pogorelec says:

    December 17, 2015

    I have been using 0xDBe for a long time now and they even implemented DB2 on iSeries when I posted it (They were currently only supporting DB2 on Linux) Anyhow I really love using this product!

    • Avatar

      Maksim Sobolevskiy says:

      December 21, 2015

      Thanks, Jake!

  9. Avatar

    Jerry says:

    December 17, 2015

    What are the current plans for No SQL support? I’d love a legitimate IDE tool for working with Mongo and Cassandra

    • Avatar

      Maksim Sobolevskiy says:

      December 21, 2015

      Surely, we shall start from most popular NoSQL dbs, but for now there are not particular plans.

    • Avatar

      Mani says:

      December 25, 2015

      Also looking for something like this.

      Currently use NoSQL Manager (for both mongodb and cassandra) which works well. http://www.mongodbmanager.com/

  10. Avatar

    Charlie says:

    December 17, 2015

    Can you import and export excel sheets? Map columns on import?

    • Avatar

      Maksim Sobolevskiy says:

      December 21, 2015

      We have no import excel sheets. What about exporting, there is an export to CSV and if the tab is a separator, excel will open this kind of file.

      • Avatar

        Charlie says:

        December 29, 2015

        I was showing data grip to our database guy at work and this is the first feature he asked for. There are many times when someone will hand him an excel sheet and he needs to import it into our database. Half the time the columns don’t line up exactly so being able to map them on import is a must. Exporting is not a likely as high as a priority, but I’m sure it would save time being able to hand someone an excel sheet back instead of having to do the manual conversion first. He currently uses SQL Studio with SQL Server, but we’re thinking of migrating to Postgres and looking at alternative software. I use Intellij Idea so this is why I had him try out Data Grip.

  11. Avatar

    Steven Barnett says:

    December 17, 2015

    Seems I’m way to thick to use this product. While SQL Management Studio opens and connects without problems, I’ve not found the magic words that allow me to connect to my local SQL Express instance using DataGrip. I did manage to get at a SQLite database though, so there is hope for me yet! Guess I just wait for a FAQ or some kind person to post clues on stackoverflow.

    • Avatar

      Maksim Sobolevskiy says:

      December 22, 2015

      Hi, Steven! Can you please provide a screenshot of connection window?
      Very often case is when the port number points to the other place than an instance name, and port number has a priority.

  12. Avatar

    Billy Cravens says:

    December 17, 2015

    Been running latest versions on up-to-date beefy MBP, and it crashes without warning. Possibly a Java runtime issue? (I think I’m using OSX’s stock)

  13. Avatar

    Ali says:

    December 17, 2015

    I’ve been using the 0xDBE since Dec 2014, alongside Intellij to connect to my hadoop clusters. Its been great. Curious if datagrip will be treated similar to PyCharm, where most of functions will be available as a plugin for Intellij?

    • Avatar

      Maksim Sobolevskiy says:

      December 21, 2015

      IntelliJ IDEA has all DataGrip functionallity.

  14. Avatar

    laispace says:

    December 18, 2015

    Nice!

    Any plan for supporting nosql such as MongoDB?

    • Avatar

      Maksim Sobolevskiy says:

      February 15, 2016

      Far plan, but not in closest releases.

  15. Avatar

    Dev says:

    December 19, 2015

    No Visual Studio extension?

    • Avatar

      Maksim Sobolevskiy says:

      December 21, 2015

      For now we do not plan to implement it as a VS extension.

  16. Avatar

    Don says:

    December 19, 2015

    Ok, gave it a go.

    What it is done right:

    * UI
    * Master password
    * Driver management
    * Data result extractors

    What needs to be improved (must haves for our use case):

    * table/field name substitution in the query, to avoid typing
    * database exploring capability – tables, views, constraints
    * anonymous sessions. not everything needs to be a file
    * folders for database connections – with 60 odd databases configured it is hard to find the right one
    * A keyboard shortcut to open up a new tab for a connection
    * ability to limit the output lines (impractical to select all 100k lines just to see if the query works), not all DBs support limit clause
    * ability to switch connections for the open tab

    Get in touch with me directly if you’d need more input how to make a dev’s work more productive

    • Avatar

      Don says:

      December 20, 2015

      * table/substitution turns out to be there
      * Database exploring capability is there.

      It is unclear though as to when and how these become available. After the schemas were manually set?.
      So if there is an issue – there is no indication of it.

      * The row limit is there but it is a setting somewhere deep in the menus. One can not change it for the next run that easily

      • Avatar

        Maksim Sobolevskiy says:

        December 21, 2015

        Don, thank you for the feedback.

        * anonymous sessions
        * folders for database connections
        * ability to switch connections for the open tab
        Useful and we shall think, thanks!

        * A keyboard shortcut to open up a new tab for a connection
        Here you can do the following:
        Windows/Linux — Ctrl+Alt+Shift+S → Alt+Ins
        Mac — Cmd+; → Cmd+N

        For all features you can create tickets in issue tracker and people will vote for them.

  17. Avatar

    Jerry Boonstra says:

    December 22, 2015

    I’m trying to upgrade from 0xDBE to DataGrip, but it can’t find my 0xDBE settings. Known problem or just me?

  18. Avatar

    Tim Bissell says:

    December 22, 2015

    I like using OxDBE as a pure database access tool when firing up Idea is too slow…

    One feature I would like is to be able to see the passwords stored in the data sources; useful if you want open the database in a different tool, and you can’t remember what it is…

  19. Avatar

    Carlton Dickson says:

    December 23, 2015

    Was hoping that you would create a DB client as the existing ones are average, so it’s a nice surprise to see this released. PHPSTORM smashed existing PHP IDEs out of the park so hopefully this will do the same.

    Is it possible to change the background/theme per data source (I do this to remind myself I’m on TEST/LIVE DB connections :))

    I guess an alternative is to make the connection read-only.

  20. Avatar

    Brandon Lamb says:

    December 24, 2015

    Hey there, we are using DB2 on iseries/ibmi/as400/systemi (so many names) and we make extensive use of stored procedures.

    It seems there is difficulty in calling a sproc that has an out parameter.

    CALL api_my_sproc_v1_0 (”, ‘ENG’, 10, 0, ?);

    2015-12-23 19:38:09] [42886][-469] [SQL0469] IN, OUT, or INOUT not valid for parameter 5 in procedure API_MY_SPROC_V1_0 in *N.

    Is there a trick to doing this? using the jt400 open drivers and not the jdbc4

    • Avatar

      Maksim Sobolevskiy says:

      December 29, 2015

      Thanks Brandon for the feedback. We know about this inconvenient thing, but for now we cannot say if we will create something in the close future.

      • Avatar

        Maksim says:

        February 10, 2016

        Maksim, got the same problem.
        Could you please fix that

  21. Avatar

    Vantis says:

    December 29, 2015

    Hi, I got a trouble while adding a new data source.

    there should be more databases in “Data Sources and Drivers/Schemas” tab but I cannot find them. Only if I declared the database could I can see the database not displayed before.

    It’s an old SQL Server.

    • Avatar

      Maksim Sobolevskiy says:

      December 29, 2015

      Hi! Can you please provide the screenshot?

  22. Avatar

    cuibty says:

    December 30, 2015

    It does not support stored procedures?

    • Avatar

      Maksim Sobolevskiy says:

      January 11, 2016

      Hi! It does. What do you mean with “support”?

  23. Avatar

    butsupphu says:

    January 6, 2016

    I did manage to get at a SQLite database though, so there is hope for me yet! Where is this information?

    • Avatar

      Maksim Sobolevskiy says:

      January 11, 2016

      Hello! What information do you mean?

  24. Avatar

    Wayne says:

    January 6, 2016

    Maksim,

    Is there a way to view all the databases on the server?

    It seems like I can only see one database for each connection I establish. I would like an overall view of all the databases.

    Thanks,
    Wayne

    • Avatar

      Maksim Sobolevskiy says:

      January 11, 2016

      Hello! Do you use MS SQL? Try looking on Schemas tab in data source properties.

      • Avatar

        Mat says:

        January 13, 2016

        Hello, This is exactly what i was looking for. My only feature request here would be a select all button. At my company we have 50ish db’s on a MS Sql Server and I have to constantly switch to different ones based on the client I’m working for at that moment in time. So it would be nice to just say select all the Schema’s so I don’t have to manually go threw and select them.

        • Avatar

          Maksim Sobolevskiy says:

          January 20, 2016

          But it will become very slow in this case, won’t it?

        • Avatar

          Maksim Sobolevskiy says:

          February 15, 2016

          We are actually working on this, hope to have it in the EAP.

  25. Avatar

    Ivan says:

    January 29, 2016

    Hi,

    quick ask: Does it support PL\SQL? Because i didn’t see any of it on the documentation.

    Regards,
    Ivan

    • Avatar

      Maksim Sobolevskiy says:

      February 1, 2016

      Yes it does

  26. Avatar

    Alex says:

    February 1, 2016

    How can I view the triggers of a table?

    • Avatar

      Maksim Sobolevskiy says:

      February 2, 2016

      What DBMS do you use?

      • Avatar

        Gustavo Andrade Ferreira says:

        June 23, 2016

        I am using Mysql with datagrip and dont see any kind of trigger viewing or manipulation. The closest i can is to execute a SHOW TRIGGERS command.

        • Avatar

          Maksim Sobolevskiy says:

          June 24, 2016

          You can view trigger of a table in the table elements, like here: https://pp.vk.me/c633327/v633327435/319f6/I1x61SprYZs.jpg

          For now there is no possibilities to edit a source code, but we are working on it — we understand it is strongly needed.

          • Avatar

            Juan says:

            October 18, 2016

            Are you still working on this feature? I am trying to modify the triggers in the database and the tool is useless in this case. MySQL Workbench has it, but I would like to use the same tool for my basic needs. Cheers

          • Avatar

            Maksim Sobolevskiy says:

            November 9, 2016

            Juan, we do: it’ll be in 2016.3

  27. Avatar

    Vasily says:

    February 12, 2016

    Hi! I like your products, and they’re really fantastic, but with DataGrip I got some butthurt comparing to Navicat (which I’ve decided to leave because of lags, stupid scrolls and such problems of usability when using Mac version – on Windows it works really good)
    So, on DataGrip:
    Altering tables means pain. Too many steps for editing column, no way to change columns order – even if there is some, I gave up looking for it. Arrows is always grey, drag-n-drop displays line where to place column, but then do nothing. So I do it by raw SQL -> No profit from IDE.
    There is no Excel export. And don’t say about CSV, my clients use only Excel, and when it comes to transformation of CSV file encoding with cyrillic text from UTF-8 to what-ever-mac-excel-can-read – it’s pain and time loses.
    For my other workflows everything is ok:)

    • Avatar

      Maksim Sobolevskiy says:

      February 20, 2016

      Hi! Do you have MySQL?
      If yes, we supported reordering columns from UI (these arrows won’t be grey 🙂 expect it in 1.1.
      About Excel, we haven’t implemented it yet, please vote and watch this issue:
      https://youtrack.jetbrains.com/issue/DBE-95

  28. Avatar

    Nikos says:

    February 21, 2016

    I use webstorm, whats the best way to get this to fit in?

    Great news btw!!!

    • Avatar

      Maksim Sobolevskiy says:

      February 25, 2016

      The best way is to buy PHPStorm.
      There is not DB features in WebStorm.

  29. Avatar

    Josian Chevalier says:

    March 7, 2016

    Hey ! I’m not an expert in database management, but I have to admit I’m quite lost with this tool. I’m working on an oracle database, and I’m struggling to find functionalities for triggers or packages. Basically, I can’t see my triggers, nor add packages.

    I actually find it more instinctive and complete to use the database integration provided by the plug-in “DB Navigator”. I suppose most of the functionalities that I can’t find are available, but he difficulty of finding it makes it kind of unusable.

    The autocomplete is very efficient though, but I wouldn’t buy and IDE just to use it as an SQL editor. I absolutely loved all the JetBrains’ product I used, but this one feels like a beta version. I use the All Products Pack though, so I’ll follow the evolutions.

    • Avatar

      Josian Chevalier says:

      March 7, 2016

      Also, Importing my settings from PHPStorm completely fucked up the keymap, erasing most of the shortcuts. The same thing worked perfectly from PHPStorm to PyCharm and IntellijIDEA.

  30. Avatar

    Wayne Fehres says:

    March 15, 2016

    I just downloaded the latest trail version on a Mac (10.11.3). It refuses to accept my Active Directory credentials when connecting to a Microsoft SQL 2012 R2 server. I tried to enter it in several ways (ex: domain/username).

    This looks like a promising product for my team but I need to get this working first.

  31. Avatar

    Bill Dee says:

    March 28, 2016

    Can I export data to Excel?

    • Avatar

      Maksim Sobolevskiy says:

      March 31, 2016

      You cannot export directly to Excel, but you can export to CSV which can be opened from Excel.

  32. Avatar

    MENGMENG SUN says:

    April 6, 2016

    My DataGrip became super super slow since two weeks ago. Even typing a query in console can be frozen several time. When i’m working in DataGrip Most time it can consume up to 200% CPU and 1.5 GB memory. I’m using MAC Pro with 2.6 GHz Core i7, 16 GB DDR3 and SSD. I would like to attach some screenshots from Activity Monitor but I’m not able to.

    Any thoughts?

    • Avatar

      Maksim Sobolevskiy says:

      April 11, 2016

      Hello! We’ve fixed this in 2016.1, so you can download RC from here:
      bit.ly/1qy4C23
      or wait for the official release.

  33. Avatar

    Frank Opitz says:

    April 8, 2016

    I have trouble to dump data as sql insert regarding timestamps. For example when I execute my sql insert script on MSSQL server I get a conversion error converting a varchar to a timestamp. Is there a possibility to create a dump with correct timestamp formatting?

    • Avatar

      Maksim Sobolevskiy says:

      April 11, 2016

      Can you please give an example?

  34. Avatar

    Cvetan Simsic says:

    May 6, 2016

    Is is possible to import/export whole database through DataGrip? And if, how?

    • Avatar

      Maksim Sobolevskiy says:

      May 11, 2016

      Hello! It is not possible for now.

    • Avatar

      Maksim Sobolevskiy says:

      September 1, 2016

      Will integrate with dump tools in 2016.3

  35. Avatar

    Tim Davis says:

    June 9, 2016

    Hi, does this product support PL\V8

    • Avatar

      Maksim Sobolevskiy says:

      June 17, 2016

      Do you mean using it in PostgreSQL?

  36. Avatar

    Quinton Viljoen says:

    June 22, 2016

    I want to use this, but I need Mongo support 😐

  37. Avatar

    carlos arana says:

    July 5, 2016

    in mssql server timestamp column is automatic and can be edited ,
    i receive this error:
    [S0001][273] Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column.

    How can i force to not include the timestamp field in editor ? not hide please

    • Avatar

      carlos arana says:

      July 5, 2016

      sorry the timestamp fields in mssql server CANT be edited

    • Avatar

      Maksim Sobolevskiy says:

      July 8, 2016

      Please watch this: https://youtrack.jetbrains.com/issue/DBE-2842

    • Avatar

      Maksim Sobolevskiy says:

      July 23, 2016

      As we explored, it is working as intented due to SQL Server behaviour.

  38. Avatar

    sebastien says:

    July 10, 2016

    Datagrip looks very promissing
    I’ve been using Querious for 3 months and it suits me well, but i like intellij products and i wanted to test Datagrip.
    I had 0 problem connecting to my datasources, but i lost plenty of time trying to use mysql 5.7. The code inspection wouldn’t let me use ‘JSON’ types, it looks like something in the code inspection needs some update ? :/
    I also updated my mysql Driver but nothing helped. i posted a thread here :
    https://intellij-support.jetbrains.com/hc/en-us/community/posts/207588505-Drivers-outdated-for-Mysql-5-7?page=1#community_comment_207377725

    • Avatar

      Maksim Sobolevskiy says:

      July 11, 2016

      Do you use 2016.1 of DataGrip?

      • Avatar

        Dan says:

        July 25, 2016

        I’m using 2016.2 and it doesn’t work for me either. Mysql version 5.7.11

        • Avatar

          Maksim Sobolevskiy says:

          September 1, 2016

          We added JSON injection in 2016.2, please, try

  39. Avatar

    Data Guy says:

    August 26, 2016

    I love this tool.
    The code complete is great, I can write long SQL expressions really quickly now.
    After a few weeks of testing, the only issue that has me jumping back to dbVisualizer is that I can’t edit “cells” sometimes.
    Sometimes I can, sometimes I can’t.
    It’s not a data issue, I can’t even set them to null sometimes.
    I enter the value, it spins and thinks for a split second, then tells my “0 rows updated”.
    The table has a primary key id field and dbVisualizer can figure out how to update the value.
    Sometimes I can literally just try over and over and it will eventually work.

  40. Avatar

    Charlie Catney says:

    September 1, 2016

    We have a multi tenant environment where all our customers (> 2k) have their own DB with the same schema.

    Is there a facility to execute an SQL command on multiple databases (on the same server) at the same time?

    Ideally I would like a way to filter which databases to execute the command against.

    • Avatar

      Maksim Sobolevskiy says:

      September 9, 2016

      For we have no such functionality

  41. Avatar

    The Alchemist says:

    September 23, 2016

    I don’t wanna sound entitled, but here we go.

    I was a beta tester for 0xDBE and filed a few bug reports, with screenshots and stack traces and everything.

    I was hoping I would get a complimentary license as a result, or a discount or something. 🙁

    • Avatar

      Maksim Sobolevskiy says:

      September 28, 2016

      Hello! We sent free licenses for those who report bugs during 0xDBE period, yes. AS far as I remember we sent them to those who reported more than 6 bugs. Was it true for you?

  42. Avatar

    Shahbaz Anshari says:

    November 14, 2018

    this tool seems good. Can I use this for my website to fetch the customers data?

    • Avatar

      Maksim Sobolevskiy says:

      November 19, 2018

      Well, we think you can if your web-site uses the relational databases

  43. Avatar

    danish says:

    March 5, 2020

    i have 7 year experience sql server very power full and better support query and functions
    manipulation very good

    • Avatar

      Maksim Sobolevskiy says:

      March 19, 2020

      Thanks!

Discover more