dbta

An Introduction to a Distributed SQL Database with CockroachDB

Distributed SQL is an evolution of the database for cloud native, distributed transactions. It can implement a standard SQL interface, ease operational complexity of scale, is geo-replicated, always ...
dbta

An Introduction to Recursive SQL

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

How to Create a MySQL 8 Database User With Remote Access

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

3 ways to import and export a MySQL database

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

MariaDB/MySQL, PostgreSQL and SQLite3 - Comparing Command-Line Interfaces

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