Announcing 0xDBE 1.0 Preview

We at JetBrains are approaching the release of our brand new IDE for developers who work with SQL and databases. We’ve started the 0xDBE 1.0 EAP (Early Access Program) over a year ago and we appreciate how many people have participated in the program. Your feedback has been instrumental in shaping and improving the product.

Today, we’re really excited to announce the 0xDBE 1.0 Preview, a nearly-finished version of our database IDE. Please give it a try and share your impressions to help us polish it before release to market.

DBIDE2_splash_upd (1)

Along with the preview we’re launching a 5-8 minute survey to get a better understanding of how you work with data. We would very much appreciate your input and feedback.

Note 0xDBE is not the final name of the product and will be changed. Now, let’s take a tour of what we’ve improved since the EAP launch.

Faster and more accurate schema introspection

First of all, we’ve reworked the way the IDE fetches meta information about database objects, and extended the JDBC-based introspection for all supported database engines to make it more native, accurate and fast. As a result, the UI has also changed. Now you can group objects in the Database view. Tables, functions, views, etc. are divided into folders and can be collapsed and expanded.

Introspection

Modify table action

Now you can Modify Table (Ctrl+F6, or Cmd-F6 for OS X) from the Database tool window, or even the Editor or the Query Console. This action lets you add, change and remove columns, indices, and foreign keys. An instant SQL preview is available so you can get a DDL statement for your changes:

Modify

Text search in table editor

Sometimes it is useful to find data inside a table quickly without writing a statement. Call up a text search in the Table Editor with Ctrl+F (Cmd-F for OS X). It’s especially helpful if you don’t know which exact column contains the data you’re looking for. Regular Expressions are available for this search as well.

Find

Code generation

The Generate action, available via Alt+Ins (Cmd-N for OS X), now helps you generate and modify DDL statements. There is a pop-up providing UI for generating statements for creating database objects, for instance, tables, functions and procedures.

You can also modify existing DDL statements and generate adding indexes, keys or columns to a created table.

Generate

The Edit as Table action from the context menu is valid for DML, so if you have several INSERT statements, you can modify the data being inserted as a table. If you add a row to this table, another INSERT statement will be generated:

DML

Multiple query consoles

We’ve added a dedicated action for opening a new console so you can assign any shortcut to it to open it even faster. Several open consoles are available, and you can switch between them via the Files tool window, or the Recent Files menu, or the Navigation toolbar. Each console now has a schema switcher:

New console

Query console local history

You’ll be glad to know that consoles are now equipped with local history. Use it to review the changes you’ve made to SQL code in a particular console, or compare versions in the diff viewer and revert if needed:

Local history

Execution behavior

We’ve extended execution options as well. First, running under selection is now improved and works in files. You can choose what to do with selected SQL code: run as several statements, run as one statement, or make a smart expansion to a valid script.

When the cursor is inside a query, statement execution can now be customized with a few possible options. Define its intended behavior: execute the smallest statement, the largest statement, or ask you to choose what to execute.

If the cursor is outside of any statement, you can configure it to do nothing, execute the whole file, or execute statements to the end.

Executie options

Running statements from the Structure view

Running SQL statements with Ctrl+Enter (Cmd-Enter for OS X) is now possible from the Structure view/popup:

Structure view

Execution plan

An execution plan for statements is provided as well:

Explain plan

Compare query results

You can compare the results of two queries using the diff viewer:

Compare

CSV format support

Now when opening a CSV file, choose the Edit as Table action from the context menu. In the Data Format Configuration window, you can specify the value of the delimiter, whether your file has a header, when to quote values, and a few other things. It offers a preview as well:

CSv

User parameters

A new UI for editing Parameter Patterns is available in Settings > Database > User Parameters. Now Regular Expressions are highlighted and you can choose in what dialect these patterns are valid:

Params

Visual diagrams

Visual diagrams are now available for databases. Build your own diagram displaying the dependencies between objects:

Diagrams

Improved navigation

To navigate to a database object (like table, procedure and so on), press Ctrl+N (Cmd-O for OS X). When navigating to a table, a table editor will open. When navigating to a procedure or function, you’ll jump to the alter DDL statement:

Navigate

It’s also worth mentioning that 0xDBE has improved its support of HDPi for Windows and Linux; offers a Distraction Free mode; and makes it possible to install plugins (e.g. Terminal, Git integration), among other bug-fixes and minor enhancements.

0xDBE will be released in the middle of November as a part of JetBrains Toolbox. Its pricing will be aligned with the “Single IDE” plan. The “All Products” bundle will include 0xDBE.

Download 0xDBE 1.0 Preview today and please share your impressions with us.

Develop with pleasure!

 

This entry was posted in Beta releases, Features and tagged , , , . Bookmark the permalink.

31 Responses to Announcing 0xDBE 1.0 Preview

  1. DJ Far says:

    One of the most useful and powerful features of MySQL Workbench is its EER Diagram tool, that allows you to build an ER Model and then forward-engineer it to a physical schema. Of course, it only works with MySQL.
    Any plans to incorporate a modeling tool?

  2. maus says:

    Any thought on useful implementations in MS SQL Server shops?

  3. N.T. says:

    Any plans to add support for SAP HANA?

  4. Vitaly says:

    I have been participated in EAP from the beginning. And after a year I have to say that it is still the same absolutely useless instrument. Just a simple toy. But too enormous toy to waste space on my SSD.

    It is impossible to use it with Oracle DB.
    I would be glad to explain my point of view and give you examples. But who cares?

  5. Chris Roberts says:

    I’ve been using 0xDBE ever since the EAP came out last year and it’s been great. Will it be included in the Toolbox subscription?

    • Andrey Cheptsov says:

      Sure, it will be aligned with jetbrains.com/toolbox/ (Single IDE). The “All Products” bundle will include 0xDBE.

  6. A.N. says:

    No graphical query/DDL/views creator. This would be the killer feature for us. So we could replace IBM data studio and EMS SQL manager. Both tools are very glitchy. With a graphical query editors we are much more productive than writing view with plain SQL.

    Greetings

  7. Ricardo Pereira says:

    Please consider adding Redshift dialect…

  8. Ryan says:

    Given the announcement date should it should be named McFlIDE?

  9. Dt says:

    Almost anything is better than pgadmin3. I’m sold.

  10. peter says:

    Will this be available as part of IntelliJ? If so when? I love the current DB support in IntelliJ and I use it daily. It would be great to get these improvements in the IntelliJ version.

    • Maksim Sobolevskiy says:

      Hi, Peter! All 0xDBE features are available in IntelliJ IDEA. So, look for all described features in IntelliJ IDEA 15.

  11. Pingback: JetBrains previews new IDE for SQL and databases - SD Times

  12. Thorn says:

    Господи, у вас что, работают клоуны или студенты? Что за маразм создавать таблицы рукописным текстом? И эти бесконечные деревья “база-таблицы-имена таблиц” – вы из 20 века штоле? Это архаизм именно оттуда! Какие же вы узколобые, товарищи – создали стотыщную копию того, чего и так на рынке НАВАЛОМ.

  13. Pingback: Alpha Rayaneh News | JetBrains previews new IDE for SQL and databases

  14. Kevin D says:

    Still hobbled by the fact that every open query to a server uses the and connection?

    • Kevin D says:

      Seems they have indeed made it so that multiple connections to a database can be run at the same time! This is great!

  15. Jorma says:

    0xDBE is a great tool for us. We have both H2 and Postgres databases so it’s a very natural fit. Being able to export and import the database settings between machines would be an awesome addition.

    I started the survey but terms and conditions and a captcha were too much.

  16. Dude says:

    Looks too Java (e.g. Data Sources config). Any plans to release this for .NET SQL Server developers with proper Visual Studio integration?

  17. Pingback: IronFleet и Dotty — Episode 0064 « DevZen Podcast

  18. Pingback: 2 – JetBrains: Announcing 0xDBE 1.0 Preview - Exploding Ads

  19. Lazy Ninja says:

    Love the tool – can’t wait for release.

    Will I have few days after release to purchase the license or will the EAP/Preview version stop working immediately?

    Secondly badly need TNS names (tnsnames.ora) support for Oracle

  20. Bobbo says:

    One thing that can get me off of Visual Studio, hence Windows; would be to also provide a way to handle the Azure Storage: Tables/Blobs/Message Queues. As we move more & more to Cloud based storage services, there’s a definite need to be able to manage these types of data repositories.

  21. Igor says:

    Thanks for your work! What about database internal procedures debugger? I mean test window to allow write and debug procedures without creating and storing it in database. Thanks

  22. Lazy Ninja says:

    Will there be a seperate connection type for Redshift? The Postgres introspector fails to read Redshift databases for me and I need to resort to the legacy one to be able to see the schemas

    Secondly any word on tnsnames.ora file support? Currently Oracle connection properties are quite hectic?

Leave a Reply

Your email address will not be published. Required fields are marked *