Planetscale, Convenient Online Database

David / 2022-05-12

Recently, I need a production ready database for me to finish my DBMS course's homework, although I have mysql database running GCP compute engine, but it is too slow (free tier can only make the VM locate in the US). So I found this Planetscale online database is quite convenient to use

Planetscale Introduction

Planetscale is an online database provider. Originally, when we want to used database, we had to have our own server and then run mysql or other databases on it.

Planetscale make us skip those step, we can connect our own database after simply clicking some buttons.

How To Use

You will see this page after you register an account on Planetscale's website and go to dashboard.

Entering database's name and region just click 'Create database', After processing, you can find a dialog after you click a button called 'connect', Inside the dialog, you can find some instruction about how to connect to planetscale.

Please remenber the password, password will not been shown on website once you connected.

Planetscale is a mysql database, so you can choose mysql as an option in IDE or library.

I encounter a question during testing connection, planetscale need SSL connection.

You can find corresponding path at here, and fill in the connection field.

Cool Feature

I also find a cool feature in dashboard, it is a console directly connect to the database!