In this 15min presentation, Gilles Rayrat, VP of Engineering at Continuent and database proxies guru, shares some of his knowledge on the world of database proxies, how they work, why they’re ...

Get an overview of JDBC's architecture, then learn how to connect to a database and handle SQL queries and responses with PreparedStatements, transactions, connection pooling, and more. JDBC (Java ...

One of the tasks nearly any sysadmin frequently encounters is the care and feeding of the MySQL database server. You can build an entire career around nothing but this topic—making you a DB admin, not ...

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

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

Nobody ever really wants to move a database, but it is a frequent necessity. Here are the most common options and when to use each one Nobody ever really wants to move a database, but it is a frequent ...

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