Available 0xDBE 1.0 Preview

Published on October 27, 2015

Available 0xDBE 1.0 Preview

    JetBrains is approaching the release of a new IDE for working with SQL and databases. We launched the EAP program a year ago and thank all of its members. As always, your opinions and wishes have made our product better.

    We are pleased to introduce you to 0xDBE 1.0 Preview . This is a great chance to try our new IDE and share our experiences, which will help us make 0xDBE even better by the time of release.



    We like the name 0xDBE, but it's still working, and for the release we will choose another - more readable.

    We also want to get to know our users better and understand how you work with databases, so we made a small survey.We ask you to go through it, it will take 5-8 minutes. Among those who took part in it, we will play ten annual licenses for 0xDBE.

    So, here’s what we’ve added since the launch of EAP:

    Fast and accurate introspection

    First of all, we reworked the algorithm for obtaining meta-information about the database and expanded the standard JDBC introspection for most supported DBMSs. In addition to increasing speed, this led to improvements in the graphical interface - now database objects are grouped by type:



    Managing database objects

    When you press Ctrl + F6 (Cmd-F6 for OS X) on the table name in the text editor or in the Database view window, the Modify Table window openswhere you can add and remove columns, change their properties, add and remove keys and indexes. In real time, a DDL script is generated that will be executed for these changes:



    Text search

    Text search by query result is now available. For example, you need to find data, but the column is forgotten. There is support for regular expressions:



    Request code generation

    By pressing Alt + Ins (Cmd-N for OS X) in the text editor, DDL-request generation is available. In the window that appears, you can create tables, functions and procedures based on the graphical interface. If the cursor is inside an existing DDL query, the IDE suggests changing the column, adding a key or index.

    The resulting code will be inserted into a text editor or immediately executed in the database:



    When you are going to insert data using several consecutive INSERT statements , this data can be edited in a table before insertion. If you add a row to this virtual table, another INSERT clause is generated in the editor.



    Query Consoles

    We took the opening of the new console into a separate menu item. Navigate between multiple consoles in the Files window , through the Recent Files menu , in the Navigation toolbar, or by pressing Ctrl + Tab . Each console has a context switch - change the scheme for executing the script without creating a new console:



    Change History The

    IDE locally stores the change history of each file. In the adjacent boxes, you can compare versions and roll back to any of them:



    Execution of requests

    Execution of a selected block of code now works not only in consoles, but also in files. You can also choose what the IDE should do in this case: execute the selected block as one request, execute the block as several requests, or try to determine what to do and execute a valid script, even if you selected a non-working piece of code:



    We also added options to run the request from the console. If the cursor is inside a complex expression, the IDE can only execute a subquery, execute the entire query, or ask which of the available queries to execute:



    If the cursor is outside the SQL code, there are also three options: the IDE can execute all the queries in the file, only queries below the cursor or do nothing.

    Executing queries from Structure view

    By pressing Ctrl + Enter (Cmd-Enter for OS X), the query is executed directly from the Structure view window . This is convenient if you need to quickly execute only some of the requests from the file:



    Execution plan The execution plan is

    available for queries:



    Comparing query

    results The results of two queries can be compared in adjacent windows. The IDE highlights the difference and allows you to change the severity of the string equality criteria. That is, if you want to consider equal rows that differ in data in only one (or more, optional) column, this is indicated in the value of the Tolerance parameter . Any column can also be excluded from the comparison process:



    Support for CSV format

    To edit CSV files or other tabular data in the text, select the Edit as Table item from the context menu. A settings window will open in which you can specify the separator, determine whether there are headers in the file, in which cases to quote values, etc. Data from the file will immediately appear as a table preview:



    Query settings with parameters

    We have updated the parameterized settings window queries, which is located in
    Settings → Database → User Parameters . Now regular expressions are highlighted, and it is also possible to select the dialect in which the templates will be used:



    Charts

    You can watch charts with a visual display of dependencies between objects:



    Improved navigation over database objects

    In order to go to any database object, press Ctrl + N (Cmd-O for OS X) and enter its name in the text box. If it is a table, you will see a table editor, and if it is a function or procedure, an editor opens with a DDL script to modify it: The



    default plugins from Intellij IDEA can now be set to 0xDBE. These are Terminal, Git, Subversion and others.

    In addition to everything, we improved HiDPI support for Windows and Linux, added Distraction Free mode , a mode in which you see only a text editor, and also made many other small improvements.

    We plan to release our IDE for SQL developers in mid-November. It will be available as part of the JetBrains Toolbox.as a “Single IDE”, as well as part of the “All Products” package.

    We will be happy to answer any questions!