Introduction
In the world of database management, having a graphic tool to explore schemes, run consultations and manage permissions intuitively is essential. In this article we focus on SQirL SQL, an open source multiplatform client that works excellent in Linux environments. We'll see how to install it, configure it and make the most of it to improve your daily productivity.
What is SQirL SQL?
SQirIL SQL is a JDBC-based Java application that allows you to connect to virtually any compatible database engine, such as MySQL, PostgreSQL, Oracle, SQL Server and many more. Its interface is organized in tabs showing the object tree, a query editor and a results console. As a multiplatform, the same version as Windows downloads works without changes in Linux distributions, provided you have an installed Java running environment.
Advantages of using SQirL in Linux
Using SQirL in a Linux system brings several advantages: first, integration with the package manager facilitates installation and updating; second, resource consumption tends to be lower than in Windows environments due to the efficiency of the Linux kernel; third, you can run it smoothly on headless servers by using light desktop environments such as XFCE or LXQt, or even by forwarding X11. In addition, by being free software, you can inspect your code, contribute or adapt it to your specific needs.
Installation in Ubuntu and Debian
In Debian-based distributions, the package is available in official repositories. Open a terminal and run:
sudo apt updatesudo apt install squirrel-sql
If you prefer the latest version, you can download the generic installer from the official website, give it execution permits and run it with Java:
chmod +x squirrel-sql-*-installer.jarjava -jar squirrel-sql-*-installer.jar
During the process, the installer will ask you to choose the installation directory and if you want to create a direct access in the application menu.
Installation in Fedora
In Fedora, the package is located in the RPM Fusion repositories. First make sure you have the repository enabled:
sudo dnf install https://download1.rpmfusion.org/free/fedora/rpmfusion-free-release-$(rpm -E %fedora).noarch.rpm
Then install SQirL SQL:
sudo dnf install squirrel-sql
For users who prefer the latest version, the same generic installer method works the same; just make sure you have installedjava-11-openjdkor a higher version.
Installation in Arch Linux
In Arch, the package is located in the community repository AUR. You can install it with a helper like yay:
yay -S squirrel-sql
If you prefer to compile it manually, download the PKGBUILD from AUR, check the changes and runmakepkg -si. After installation, runsquirrel-sqlfrom the menu or terminal.
Initial configuration and connection to databases
Once installed, launch the application. In the first window the wizard will appear to create a connection alias. The steps are:
- Select the right JDBC driver for your database engine (e.g.,
org.postgresql.Driverfor PostgreSQL). - It indicates the connection URL, typically something like
jdbc:postgresql://localhost:5432/nombre_base. - It provides the username and password.
- Try the connection to the button «Test» And if it's successful, keep the alias.
After saving, the alias will appear on the left panel; when you expand it you will see the tables, views, procedures stored and other objects that your user has permission to see.
Highlights
SQirIL SQL includes several features that make it useful for both developers and administrators:
- Object Explorer:navigable tree showing schemas, tables, columns, indexes and triggers.
- SQL Editor:with syntax highlighted, self-completed and history of consultations.
- Results display:shows data in table form, allows to order, filter and export to CSV, Excel or XML.
- DDL Generator:allows to create table creation scripts from existing objects.
- Plugins:active community that provides extensions for NoSQL database support, integration with version control systems and more.
As a Java application, you can adjust your appearance by looking and feeling themes such as Nimbus or GTK theme of your desktop environment.
Tips and best practices
- It uses a different alias for each environment (development, testing, production) and protects configuration files with restrictive permissions (
chmod 600). - Increase the memory assigned to the JVM if you work with very large databases; edit the file
squirrel-sql.shand adds-Xmx1024mOr more as you need. - Program maintenance tasks by running consultations via the command line with
squirrel-sql -cmdIf you need automation. - Keep the JDBC driver up to date in your database; it is usually available on the supplier's site and improves compatibility and performance.
- It supports the ability to create favorites in the SQL editor to reuse frequently used code fragments.
Common problem solution
- «No JDBC driver found»: verify that the driver's JAR is added to the tab «Drivers» of the aliases assistant and that the mentioned class matches the driver's name.
- «The application is closed when starting»: check that you have a compatible version of Java (Java 11 or higher) and that the environment variables
JAVA_HOMEare correctly defined. - «Special characters are shown as strange symbols»: ensure that the connection encoding is configured to UTF-8 in the alias property tab.
- «The performance is slow when loading large schemes»: disables automatic loading of unnecessary objects in preferences and uses scheme filters to limit exposure.
Conclusion
SQirL SQL is consolidated as a robust and flexible option for working with Linux databases. Its multiplatform nature, the wide range of JDBC drivers and the active plugin community make it suitable for both new and experienced users. Following the installation and configuration steps described above, you can integrate this tool into your daily workflow and make the most of your ability to consult, manage and view your data efficiently.
