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

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

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

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

SQL stands for Structured Query Language. It’s a standard language for accessing and manipulating databases. MySQL is a database management system, like SQL Server, Oracle, Informix, Postgres, etc.

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