![]() He also used ‘Database Color Settings’ to change the background color of one of the databases to rose, making it easier to relate to. Max demonstrated how to group database connections, which can be very handy when you have multiple connections and you want to keep them together because of where they are used, test and production databases, for example. ![]() Max briefly explained various properties of a database connection – read only, transaction mode, run-keep alive query, auto-disconnect later, SSH and SSL, schemas to show in the database, advanced options on JDBC drivers. Max used PostgreSQL to demonstrate all the features of DataGrip, but he also noted that you would get the same functionality with the other databases. The database tool window has a database tree with many objects, and it also shows the active connections. IntelliJ IDEA can help you connect to a database, write queries, view data, manipulate it, and even export or import data. You can connect to many databases, like RedShift, Couchbase Query, H2, MondoDB, MySQL, Oracle, PostgreSQL, and many more. He demonstrated that the Database Tool Window can be used to view existing connections, rename them, or create new ones. He used an existing shortcut, which was being used by another window, but you can choose whatever works best for you. Max started his session by assigning a shortcut to the Database Tool Window, since it doesn’t have one by default. In fact, DataGrip functionality is supported by nearly all JetBrains IDEs, including PhpStorm and RubyMine. ![]() IntelliJ IDEA Ultimate includes nearly all DataGrip functionality. Maxim started his session by noting that DataGrip is a standalone JetBrains IDE for SQL and databases. He started with the basics of writing a simple query faster, and progressed to more complicated tasks like updating data, creating run configurations, and using language injections. On October 16, 2020, we hosted the live webinar ‘Working with SQL and Databases in IntelliJ IDEA’ by Maksim Sobolevskiy, Product Marketing Manager for Database Tools at JetBrains.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |