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

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

In the open-source world, much has been made about the need for a full-featured, robust and reliable database that can handle substantial loads and yet be able to play well with such open-source tools ...

Let’s talk about database application benchmarking. This is a skill set which, in my opinion, is one of the major differentiators between a journeyman-level DBA and a true master of the trade. In this ...

MySQL plans to include enterprise-level technology from SAP in its own open source database, after announcing Tuesday the acquisition of rights to SAP’s database, SAP DB. The two companies will work ...

In database management, it’s easy to assume that newer technologies are always better. While many database solutions have gained popularity in recent years, MySQL—one of the oldest and most widely ...

How to Create a MySQL 8 Database User With Remote Access Your email has been sent At some point, you're going to need to connect to a MySQL 8 database remotely to manage your databases. Here's how to ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

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