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

A Python CLI for transferring SQLite 3 schema and data to MySQL or MariaDB. sqlite3mysql reads the source schema from SQLite, creates equivalent MySQL/MariaDB tables, indexes, foreign keys, and views ...

Recently, I started working on a data analytics project using Microsoft Power BI in combination with MySQL for database management and data preparation. This is a completely new experience for me, and ...

Another year passes. I was hoping to write more articles instead of just these end-of-the-year screeds, but I almost died in the spring semester, and it sucked up my time. Nevertheless, I will go ...

With a combined market value of around $150 billion, Snowflake and Databricks have divergent visions on how to get customers' analytics and machine learning tools to their data, which is often spread ...

Before Donald Trump became US president and the UK left the EU – both arguably the result of a new kind of online politics – a rather nervous-looking Mark Zuckerberg shuffled out onto a Harvard ...

Get up and running—and avoid the setup pitfalls—with this enterprise-class, open-source database available for all major platforms. For years now, PostgreSQL has been one of the best-kept secrets of ...

The Cloud SQL Python Connector is a Cloud SQL connector designed for use with the Python language. Using a Cloud SQL connector provides a native alternative to the Cloud SQL Auth Proxy while providing ...

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

Grafana needs data to be useful. Phil Hajjar walks you through the process of using a MySQL database as a source for data visualization in Grafana. Grafana is one of the most widely-used interactive ...

Today, I discovered some fantastic Python libraries that facilitate connections to different types of databases. These include psycopg2-binary for PostgreSQL, snowflake-connector-python for Snowflake, ...