top of page

Meals & nutrition

Public·126 members

JetBrains DataGrip 2018.1.1 Crack


JetBrains DataGrip 2018.1.1: A Powerful IDE for Databases and SQL




DataGrip is a cross-platform IDE for working with databases and SQL. It supports a wide range of database systems, such as MySQL, PostgreSQL, Oracle, SQL Server, SQLite, and more. DataGrip provides many features to help developers and data analysts write, execute, and analyze SQL queries, such as code completion, syntax highlighting, refactoring, debugging, and data visualization.


Download: https://t.co/eopxjh5zmG


In this article, we will review some of the new features and enhancements that were introduced in DataGrip 2018.1.1, the latest version of the IDE as of April 2018.


Data editor




One of the main improvements in DataGrip 2018.1.1 is the data editor, which allows users to view and edit data in tables and views. The data editor has been redesigned to be more user-friendly and intuitive. Some of the new features include:



  • A new toolbar with buttons for common actions, such as adding, deleting, or duplicating rows, refreshing data, or exporting data to a file.



  • A new context menu with options for copying, pasting, or transposing data, as well as generating SQL statements based on the selected data.



  • A new column chooser that lets users select which columns to display in the data editor.



  • A new filter panel that lets users apply filters to the data using SQL expressions or predefined conditions.



  • A new pagination panel that lets users navigate through large datasets using page numbers or custom ranges.




The data editor also supports editing data in multiple rows or cells at once, using the multi-cursor feature. Users can also use keyboard shortcuts to perform various actions in the data editor, such as inserting or deleting rows, moving between cells, or editing cell values.


SQL log




Another new feature in DataGrip 2018.1.1 is the SQL log, which shows all the SQL statements that are executed by the IDE or by the user. The SQL log can be accessed from the View Tool Windows SQL Log menu or by clicking on the SQL Log icon in the bottom-right corner of the IDE.


The SQL log has several benefits for users who want to monitor or debug their SQL queries, such as:



  • Showing the execution time and status of each SQL statement, as well as any errors or warnings that occurred.



  • Allowing users to copy, rerun, or edit any SQL statement from the log.



  • Providing a filter option to show only specific types of SQL statements, such as DDL, DML, SELECT, or others.



  • Offering a search option to find any SQL statement by its text or parameters.




IDE general enhancements




DataGrip 2018.1.1 also includes several general enhancements that improve the usability and functionality of the IDE. Some of these enhancements are:



  • A new rename feature that lets users rename any database object, such as tables, columns, schemas, or aliases, by pressing Shift+F6 or choosing Refactor Rename from the context menu. The rename feature will automatically update all the references to the renamed object in the project.



  • A new schema switch mode that lets users switch between different schemas of the same database connection by using a drop-down list in the database tool window or by pressing Ctrl+Alt+Home.



  • An improved navigation feature that lets users jump to any database object definition or usage by pressing Ctrl+B or choosing Go To Declaration or Go To Usage from the context menu.




Conclusion




DataGrip 2018.1.1 is a powerful and versatile IDE for working with databases and SQL. It offers many features and enhancements that make it easier and faster for developers and data analysts to write, execute, and analyze SQL queries. DataGrip supports a wide range of database systems and integrates well with other JetBrains products. You can download DataGrip 2018.1.1 from the official website or check out the release notes for more details.


About

Welcome to the group! You can connect with other members, ge...

Members

bottom of page