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 up to speed on MySQL basics with this step-by-step tutorial on how to create a database, add a table, and input data into the table. I talk a lot about server software and apps that require the ...

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

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

The structured query language is a powerful tool for connecting to many database systems that store data in tables organized into rows and columns. It's often used on the backend of business websites ...

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

I'm a big fan of MySQL. The community edition of the MySQL server, as the open-source database is formally known, is a popular choice for both development and deployment because it checks all the ...