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 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.
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.
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:
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.
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:
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:
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
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.
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.