If you are a SQL programmer, learning recursive SQL techniques can be a boon to your productivity. A recursive query is one that refers to itself. I think the best way to quickly grasp the concept of ...

MySQL is a common database amongst many organizations. As such, when building an automation script that needs to query data from somewhere, you might run into the need to query a MySQL database. By ...

Jack Wallen walks you through the process of connecting the DBeaver GUI tool to a remote MySQL server. If you manage a database server, you are probably always in search of a tool to make that process ...

At some point, you’re going to need to connect to a MySQL 8 database remotely to manage your databases. Here’s how to make this possible. Recently, I was tasked to add a MySQL database GUI for a ...

MySQL and PostgreSQL are two of the most used open source SQL databases, and both fulfill the role of a general-purpose database well. How do you choose which one to use for a project? Let's look at ...

How effective are free and open source data bases? For answers, we reviewed 6:: Microsoft SQL Server Express, PostgreSQL, Oracle's MySQL, MariaDB, Apache Derby and Firebird SQL. Free or open source ...

Don't be afraid of using your chosen database's command-line client. I might as well say this up front: I don't like using GUI (aka non-command-line or graphical) tools with my databases. This is ...