DataGrip, install this IDE for databases on Ubuntu

about DataGrip

In the next article we are going to take a look at DataGrip. If you want to use different databases in applications, in Ubuntu we will have the option of install the IDE for DataGrip databases via Snap or Flapck. This is a database environment that supports multiple engines. If a DBMS has a JDBC driver, we will be able to connect to it through DataGrip.

I want to highlight that DataGrip is not free or open source software. It is a paid product created by Jetbrains that offers us a 30 day trial. Despite this, the program can be useful for users who want to test it on Gnu / Linux.

DataGrip is compatible with; MySQL, PostgreSQL, Microsoft SQL Server, Microsoft Azure, Oracle, Amazon Redshift, Sybase, DB2, SQLite, HyperSQL, Apache Derby, and H2. For any of the supported mechanisms, provide database introspection and various tools for creating and modifying objects.

Su query console gives users an expanded view of how their queries work and the behavior of the database engine so that anyone can make their queries more efficient. DataGrip provides context-sensitive code completion, which can help us write SQL code faster.

datagrip working

datagrip detects possible errors in our code and suggests the best options to correct them quickly. It will report unresolved objects immediately, using keywords as identifiers, and will always offer a way to correct problems.

datagrip preferences

This IDE correctly resolves all the references in our SQL code and helps us to refactor them. When you change the name of a variable or an alias, it will update its usages throughout the file. The actual table names in the database are updated when we rename the references to them from their queries. There's even a preview of table / view uses within other views, stored procedures, and functions.

about workbench
Related article:
MySQL Workbench, a visual tool for database design

Installing the DataGrip IDE on Ubuntu

Through Snap

To install the DataGrip Database IDE on Ubuntu via Snap, it is necessary to have support for this technology installed in our system.

If you can use Snap packages on your system, you are all set to install the DataGrip database IDE by opening a terminal (Ctrl + Alt + T) and typing the following command to install stable version:

datagrip snap installation

sudo snap install datagrip --classic

In case you need update the program, we can use the command:

sudo snap refresh datagrip

Once installed, now we can start the program looking for the pitcher on our team. We can also write data grab in a terminal.

datagrip launcher

Uninstall snap

If you want to uninstall the program, in the terminal (Ctrl + Alt + T) we will only have to use the following command:

sudo snap remove datagrip

Via Flatpak

Another option to install the DataGrip database IDE on Ubuntu is through Flatpak. We must have support for this technology installed in our system.

If we can use this type of package, we can already install the IDE for DataGrip databases in Ubuntu through Flatpak by opening a terminal (Ctrl + Alt + T). Then we will only have to use the following command to install the program. Here we may need to be patient, as Flatpak can often take several minutes to download everything it needs:

datagrip flatpak installation

flatpak install --user https://flathub.org/repo/appstream/com.jetbrains.DataGrip.flatpakref

For update the IDE, when there is a new version available, we will have to execute the command:

flatpak --user update com.jetbrains.DataGrip

Once the installation is finished, when we want to start the program, we must write flatpak run com.jetbrains.DataGrip in a terminal (Ctrl + Alt + T). We can also try start the program from the launcher that we should find available in our team.

Uninstall Flatpak

To uninstall this IDE for databases, we will only have to open a terminal (Ctrl + Alt + T) and type the following command:

uninstall flatpak datagrip

flatpak --user uninstall com.jetbrains.DataGrip

We will also be able to use this other command to proceed with the uninstallation of the IDE:

flatpak uninstall com.jetbrains.DataGrip

datagrip trial license

With this we will be able to test this IDE. I want to emphasize again that this is not free or open source software. East It is a paid product, but we can use it with a trial version for 30 days.


A comment, leave yours

Leave a Comment

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

*

*

  1. Responsible for the data: Miguel Ángel Gatón
  2. Purpose of the data: Control SPAM, comment management.
  3. Legitimation: Your consent
  4. Communication of the data: The data will not be communicated to third parties except by legal obligation.
  5. Data storage: Database hosted by Occentus Networks (EU)
  6. Rights: At any time you can limit, recover and delete your information.

  1.   Juan Carlos said

    The program looks good, however to my liking I am not a user of these packages I prefer the usual and the classic. There is also a program called DBeaver and it is the one I use.