Connect to PlanetScale on Linux

PlanetScale is a serverless database platform that is easy to spin up and can scale as your volume of data grows. Arctype has a native integration with PlanetScale which you can read about in the Arctype <> PlanetScale Docs. To connect to only the main branch, read on below.

Obtain Credentials

From the Overview Page, select the Connect dropdown to view your credentials. You can follow PlanetScale’s guide on connection strings to set these up.

The first time you generate your password you will need to copy it. If you do not you will need to regenerate your password.

Enter your Credentials in the SQL Client

Add a connection to Arctype with these credentials. Make sure to select Connect with SSL as Planetscale uses a certificate to secure your connection.

Import the CA Certificate into Arctype

Select the CA Cert SSL option to open a file upload dialogue. Note that this certificate is never saved to Arctype servers, only locally. For Ubuntu, the certificate is located in the /ect/ssl/certs folder and is called ca-certificates.crt.

For other linux distributions, see PlanetScales’s guide on secure connections to find their location in the filesystem.

Click Test Connection and Save to view your PlanetScale database!

Limitations

When you connect to your database through this method, you connect on the main branch which is locked from allowing schema, or DDL, changes. This means that SQL commands like CREATE TABLE, ALTER COLUMN, and DELETE TABLE will not work. Similarly, Arctype features like the table editor will not have any effect. Instead you can make these changes on a separate branch in PlanetScale and deploy them to main. Data manipulation such as INSERT rows, DELETE rows, and other non-schema SQL commands all work perfectly.