0xDBE. New IDE for developers and admins of DBMS from JetBrains
As those of you who read the “Programming” hub can remember, in the winter of 2014, JetBrains announced a subscription to the private preview C ++ IDE. As a result, a considerable number of subscribers already use it, at the beginning of autumn we plan to release a public early preview, and we still receive letters from friends on the topic “We did not have time to subscribe, how to jump on this train now?”.
And now there is a great opportunity to fit into a similar story without delay: JetBrains opens a subscription to the early preview of the new IDE for developers who write in SQL . And for database administrators, they also need something more comfortable than pgAdmin. For admins, the new IDE comes in handy where they need to work with the data in the tables. Assign rights, make backups and perform other purely admin tasks IDE does not know how, although we are thinking of teaching her this.
In short: here - subscribe , and under the cut - the details.
')
IDE is based on IntelliJ platform, like other IDBs from JetBrains, supports all popular SQL dialects, offers autocompletions and other conveniences when working with SQL code, working with database schemas, integrating into VCS and one more thing as discussed below. The IDE is written in Java and supports those DBMS for which there are JDBC drivers.
At the moment, 0xDBE is able to do everything the same as the Database Support plugin in IntelliJ IDEA, about which we already talked about in Habré. Those administrators and database developers who do not need other languages supported by IntelliJ IDEA will now be able to work the same way as their colleagues writing in Javascript, PHP, Python or Ruby — that is, they now have their own little JetBrains IDE.
First, we will answer the most popular questions that arose after the announcement in our English-language blog and on reddit , and then details.
So: NoSQL is not supported right now, we are thinking about MongoDB support, but we cannot promise anything right now.
Why is she so called? DBE is a Database Environment. And 0x is added for beauty, it goes well with DBE, in the opinion of the development team. Numerologists have already been knocked down trying to figure out what the number of 3518 for JetBrains (0xDBE in decimal notation) means, and we already had to admit that it has nothing to do with the number 42 .
And now - the details.
Autocompletion in 0xDBE is traditionally clever, takes into account foreign keys (foreign keys), it is easy to guess what you want to insert into the table, knows how to offer parameters for operators, functions and procedures:
Quick fixes
If you are writing code to work with a table or column that you haven’t yet created, the IDE will offer quick-fix and will create what you need:
The editor traditionally includes the latest version of what has been done for the IntelliJ platform, including multi-persistence. In Sublime, it is there, but is it in SQL Developer? ;)
By the way, if looking at the working field 0xDBE, you think about how easy it is for you to create an .sql file, then feel free to do it with File | Attach Directory, there choose the working directory in which you want to create .sql files, and add the file, as you used to (<Alt + Insert>). The directory and files will appear in the Files panel (by default, on the right side of the screen).
If a directory is added to the project by mistake, you can mark it as Excluded (right click | Mark Directory As | Excluded). This, by the way, speeds up the work of the IDE, since it indexes all project files, except those in excluded directories.
Of course, in 0xDBE there is an excellent tabular editor with external key navigation, transposed by the type of long lines (obtained by double <Ctrl + Q> on the line) and other nice features.
Creating and modifying tables also becomes easy, pleasant and error-free in 0xDBE: you can do it in the console, in the graphical interface.
The new IDE, which cannot be downloaded yet, but you can subscribe to the early preview, already have a website . Since this is a preliminary version, something may be added or changed to the release. Wishes can be left in the comments, and when the subscribing colleagues touch the new IDE with their hands, even in our tracker .
Subscribe , and good holidays to all!
JetBrains Team
And now there is a great opportunity to fit into a similar story without delay: JetBrains opens a subscription to the early preview of the new IDE for developers who write in SQL . And for database administrators, they also need something more comfortable than pgAdmin. For admins, the new IDE comes in handy where they need to work with the data in the tables. Assign rights, make backups and perform other purely admin tasks IDE does not know how, although we are thinking of teaching her this.
In short: here - subscribe , and under the cut - the details.
')
IDE is based on IntelliJ platform, like other IDBs from JetBrains, supports all popular SQL dialects, offers autocompletions and other conveniences when working with SQL code, working with database schemas, integrating into VCS and one more thing as discussed below. The IDE is written in Java and supports those DBMS for which there are JDBC drivers.
At the moment, 0xDBE is able to do everything the same as the Database Support plugin in IntelliJ IDEA, about which we already talked about in Habré. Those administrators and database developers who do not need other languages supported by IntelliJ IDEA will now be able to work the same way as their colleagues writing in Javascript, PHP, Python or Ruby — that is, they now have their own little JetBrains IDE.
First, we will answer the most popular questions that arose after the announcement in our English-language blog and on reddit , and then details.
So: NoSQL is not supported right now, we are thinking about MongoDB support, but we cannot promise anything right now.
Why is she so called? DBE is a Database Environment. And 0x is added for beauty, it goes well with DBE, in the opinion of the development team. Numerologists have already been knocked down trying to figure out what the number of 3518 for JetBrains (0xDBE in decimal notation) means, and we already had to admit that it has nothing to do with the number 42 .
And now - the details.
Autocompletion
Autocompletion in 0xDBE is traditionally clever, takes into account foreign keys (foreign keys), it is easy to guess what you want to insert into the table, knows how to offer parameters for operators, functions and procedures:
Quick fixes
If you are writing code to work with a table or column that you haven’t yet created, the IDE will offer quick-fix and will create what you need:
Code editor
The editor traditionally includes the latest version of what has been done for the IntelliJ platform, including multi-persistence. In Sublime, it is there, but is it in SQL Developer? ;)
By the way, if looking at the working field 0xDBE, you think about how easy it is for you to create an .sql file, then feel free to do it with File | Attach Directory, there choose the working directory in which you want to create .sql files, and add the file, as you used to (<Alt + Insert>). The directory and files will appear in the Files panel (by default, on the right side of the screen).
If a directory is added to the project by mistake, you can mark it as Excluded (right click | Mark Directory As | Excluded). This, by the way, speeds up the work of the IDE, since it indexes all project files, except those in excluded directories.
Spreadsheet Editor
Of course, in 0xDBE there is an excellent tabular editor with external key navigation, transposed by the type of long lines (obtained by double <Ctrl + Q> on the line) and other nice features.
Work with database schema
Creating and modifying tables also becomes easy, pleasant and error-free in 0xDBE: you can do it in the console, in the graphical interface.
The new IDE, which cannot be downloaded yet, but you can subscribe to the early preview, already have a website . Since this is a preliminary version, something may be added or changed to the release. Wishes can be left in the comments, and when the subscribing colleagues touch the new IDE with their hands, even in our tracker .
Subscribe , and good holidays to all!
JetBrains Team
Source: https://habr.com/ru/post/225801/
All Articles