0xDBE—Brand New IDE for DBAs and SQL Developers

Andrey Cheptsov

Today we have some super exciting news to share with you.

Since its inception JetBrains has focused on making software development a more productive and enjoyable experience by providing developers with top-notch tools. Our products support Java, .NET, PHP, Python, Ruby, Objective-C and many other languages and platforms.

Today, JetBrains expands this list to databases. Meet 0xDBE—our brand new IDE for DBAs and SQL developers.

For years, we’ve been developing a range of database tools as part of our family of IDEs. Now these tools are becoming a separate IDE: for DBAs, SQL developers and just about everyone who works with databases or SQL files.

Though 0xDBE is still under heavy development, today we’re happy to announce the opening of it’s private EAP (Early Access Program), so you have a chance to become an early 0xDBE adopter.

For more details about 0xDBE see http://jetbrains.com/dbe/

To gain access to early builds of 0xDBE, please sign up for its private EAP: http://jetbrains.com/dbe/eap/

Develop with Pleasure!
0xDBE Team

Comments below can no longer be edited.

39 Responses to 0xDBE—Brand New IDE for DBAs and SQL Developers

  1. Alex says:

    June 9, 2014

    Looking forward to trying this out

    Are there any plans for scripting support and ORM integrations? Like python + sqlalchemy or is this just targeted to SQL? An example of how I imagine it is like in linqpad you can have a lightspeed model and code in C#, although linqpad is pretty limited when it comes to managing a DB.

    What is the scope of this tool? Will it allow you to manage SQLServer jobs? or does it not reach outside of the databases(schemas) themselves?

    I am also curious if you guys think there would be any use for tools like this but for nosql style DBs. I can see how a lot of these features may not need to exist in that scenario but it would be interesting to have a unified platform

    • Andrey Cheptsov says:

      June 10, 2014

      ORM support is a part of other IntelliJ-based IDEs, such as IntelliJ IDEA, PyCharm, etc. 0xdbe is about pure SQL mostly.

      As to the scope, I guess the first version will focus on editing SQL, providing only basic schema management features. Further versions will bring more advanced stuff.

      NoSQL is also interesting for us, but SQL is the top priority for now.

      • Alex says:

        June 10, 2014

        I guess in addition to my last comments I have a feature idea:
        One thing with SQL insert statements that is always trouble is when reading a script, it’s hard to line up the insert values with the insert columns. In the scenario where the values are split on to separate lines, would it be possible to show a faded column name before the value? That would be super nifty but I guess it would throw off the alignment of text. Adding at the end of the line may not work well if the line is long so I am not sure how else to display it

        I saw when editing the values you can get the column names for the value position but that is only for editing and not when skimming through a file to understand it. Basically what I am hoping to achieve here, is to be able to look at a file and understand what everything is without having to scroll back and forth for large insert statements or to click in to each column value to pop up the assist message

        • Andrey Cheptsov says:

          June 10, 2014

          A nice idea, thanks! Track the progress http://youtrack.jetbrains.com/issue/DBE-45

          • Alex says:

            June 10, 2014

            Cool cool, hope it works out

            Now I can only wait for the EAP 😉

  2. Prashanth says:

    June 9, 2014

    What does this mean “0xDBE” ? Any significance ?

    • Andrey Cheptsov says:

      June 10, 2014

      DBE stands for DB Environment, DBE is just the short project codename, and 0xdbe is its “number” representation.

      • Mike says:

        June 10, 2014

        What does DB stand for?

        • Andrey Cheptsov says:

          June 10, 2014

          I guess “database”. BTW the name is not final, so feel free to suggest other cool ideas.

          • Alex says:

            June 10, 2014

            What about SQLSquire? 😛
            Or SQuire if the word language is not as important

          • Alex says:

            June 10, 2014

            Or even SQLSquall to fit with the storm ones 😛
            SQLSquirrel? That could make for a funny icon

          • Alex says:

            June 10, 2014

            Is SQL will not be the only thing in the end, maybe DBDataBee?

            Enough ideas for now haha

          • Mike says:

            June 13, 2014

            Why not “OxyDBE” so its spelt more like you suggested pronunciation “o-kzi-di-bi-i” if I’ve interpreted that correctly. Might avoid the confusion then.

          • inquisitor says:

            March 19, 2015

            @Alex, there already is a Squirrel client (squirrel-sql.sourceforge.net).

            Also, if they add in non-relational support (mongo, cassandra, etc.) Their product perception in the market may be hindered with SQL in the name.

            How about DKIN? short for “Data Constructs and Integrations”, pronounced “deacon”, cool, short, easy to say, spelled uniquely so no much confusion with other search terms.

  3. Prashanth says:

    June 9, 2014

    How is it “0xDBE” pronounced ?

    • Andrey Cheptsov says:

      June 10, 2014

      It’s pronounced “o-kzi-di-bi-i”.

      • Mike says:

        June 10, 2014

        WTF? Whats “kzi”?

        • Andrey Cheptsov says:

          June 10, 2014

          Like in the “oxygen” word.

          • inquisitor says:

            March 19, 2015

            Errrrr, sorry to nuance here, the phonetics are still a little confusing.

            o-kzi-di-bi-i (with kzi as in oxygen) is not intuitive…

            the way I try to pronounce the phonics with that description would be:

            “oh-ex-dye-bye-eye”. Is that right?

            If not, is the 0x portion pronounced “ox” as in the animal or “oh-ex” or “zero ex”

            Second part: is it “dee-bee-eye” or “dee-bee-ee” where ee is a long e like ē?

            Fun stuff. great prog. Use your IntelliJ, PyCharm and PHPStorm. Already enjoy 0xDBE, and am looking forward to see it grow!

            What’s the back story behind the name?

            Given that this is likely to shape up into my favourite Database dev environment, I want to make sure I’m doing justice to its name.

  4. Denis Savenko says:

    June 10, 2014

    As well as Alex can’t wait to have a touch on it.

    But there’re some questions about JetBrains’ plans:
    * Are you going to implement some performance tools in 0xDBE such as explain plan, profiler and so on?
    * Is there a plan to implement built-in debugging platform (similar to ‘test window’ in AA PL/SQL Developer)?
    * Was it planned to add built-in diagram tool into the IDE, which would be able to generate DDL script to add ‘drawn’ object into DB schema (like ERWin or Toad Data Modeler)?
    * Is there only strong support for ANSI SQL or does it work well also with Oracle PL/SQL, MS T-SQL and so on?

    • Andrey Cheptsov says:

      June 10, 2014

      “Yes” to all the questions. The first version will focus on the coding assistance for SQL, including all the dialects. Further versions will cover more advanced stuff such as: performance tools, debugging, etc.

  5. William says:

    June 10, 2014

    How will this integrate with coding IDEs such as IntelliJ and PHPStorm? From the licensing standpoint, will it be included with IntelliJ Ultimate the way PHPStorm is, as a plugin?

    Also from a coding standpoint, will I be able to click on a block of SQL code in a PHP file and have it open in an 0xDBE project that is somehow linked to the PHP project? Usually when I am working with SQL, it is embedded in other types of files. Being able to jump to the dedicated IDE to craft/test/optimize the query (possibly with params identified and placeholders added?) and then when done easily bring that back into the PHP or Java IDE would be awesome.

    • Andrey Cheptsov says:

      June 10, 2014

      All the current 0xDBE features are available in IntelliJ IDEA and other IntelliJ-based IDEs (except WebStorm and AppCode). At some point (in the future) some advanced DBA features may be present in 0xDBE only.

      As to embedded SQL, you’ll be able to work with it from an IntelliJ-based IDE without switching.

  6. Igor M. says:

    June 10, 2014

    That’s really cool!
    I’m looking forward to NoSQL support (specifically MongoDB), performance tools – and EAP, of course! : )
    Good luck!

  7. Paul says:

    June 10, 2014

    Hello, are you going to support Hadoop ecosystem?

  8. Peter says:

    June 11, 2014

    An is this support the long time waiting tunnel based connection type? If it has only the JDBC connectors that phpstorm, this is useless for at least the half of the european developers….

  9. AAA says:

    June 12, 2014

    I care about the price.
    I have bought IDEA, resharper, appcode.
    And I will buy your new C++ IDE and this..
    There are too many IDEs. Do you offer a bundle or subscription so that I can access all your product like MSDN?

    • Robert Demmer says:

      June 12, 2014

      AAA, Thank you for your support. Contact sales [at] jetbrains with your question.

  10. 0xDBE. Новая IDE для разработчиков и админов СУБД от JetBrains | FNIT.RU says:

    September 1, 2015

    […] на самые популярные вопросы, возникшие после анонса в нашем англоязычном блоге и на reddit’e, а потом — […]

  11. Javier Z. McFigglestein says:

    October 13, 2015

    Is 0xDBE ever coming out? There hasn’t been a blog post on this for over a year. I’ve tried some EAPs, but those seem to have washed up as well.

    • Andrey Cheptsov says:

      October 13, 2015

      0xDBE will be released in November. In a few days we will release a public preview (almost Beta).

      • Kevin says:

        October 28, 2015

        You guys should probably make a blog entry or two about it, since the public preview is available, but, from what I can see, can only be accessed via a direct link (jetbrains.com/dbe).

  12. iwillneverstop says:

    October 16, 2015

    I’m looking forward to try the final release, comparing with many existing tools.

  13. Andrew Collington says:

    October 21, 2015

    Can I suggest “SQuirreL” for the new name? It fits in nicely with the CLion naming, has SQL in it – kinda sounds like it, too… Plus it’ll give me a good excuse to point to my monitor and shout, “SQUIRREL!” (in a “dogs from the movie ‘Up!'” kind of way) every time I see it. 😉

  14. Vladimir says:

    November 10, 2015

    A year later there is no final release yet.
    Is the project discontinued?
    If it is not, I can suggest two features:
    – compare particular tables from different databases and show the difference in their structure
    – database modeling (reverse engineering, migration)

    • Andrey Cheptsov says:

      November 10, 2015

      Thanks for feedback. Just a couple of weeks ago we announced 0xDBE 1.0 Preview (Beta): https://blog.jetbrains.com/dbe/2015/10/21/0xdbe-preview/
      In the latest EAP build you can already compare two sets of database objects. As to the modelling, I think it won’t make it to v1.0. Stay tuned for more great news within a month.