MySQL

How To Migrate a MySQL Database to PostgreSQL Using pgLoader — step-by-step Linux tutorial on Progressive Robot

How To Migrate a MySQL Database to PostgreSQL Using pgLoader

The prospect of migrating a database can be intimidating, especially when migrating from one database management system to another. This tutorial provides instructions on how to install pgLoader, an open-source database migration tool, and use it to migrate a remote MySQL database to PostgreSQL over an SSL connection.

Read more
How To Connect to a Managed Database on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Connect to a Managed Database on Ubuntu 18.04

If you’re new to working with managed databases, the best way to perform certain tasks, like connecting to the database, may not be self-evident. In this guide, we will go over how to install client programs for a variety of database management systems, including PostgreSQL, MySQL, and Redis, on an Ubuntu 18.04 server. We’ll also explain how to use these programs to connect to a managed database instance.

Read more
How To Use Lithium to Create a Web App — step-by-step Databases tutorial on Progressive Robot

How To Use Lithium to Create a Web App

In this tutorial, we’ll continue where we left off previously when we installed Lithium onto our Ubuntu 12.04 VPS and configured all the necessary requirements for building our web application. If you remember, we also connected a MySQL database and had a glimpse of how to print out “Hello World” onto the page. What will follow now is illustrating how to use the three MVC components (Models, Views and Controllers) together with the Lithium framework.

Read more
CHAT