PlanetScale provide a hosted MySQL database with 5GB of storage included in the free tier.

1. Sign up to PlanetScale 2. Create a new database 3. Create a password 4. Create your first table 5. Insert an item 6. Query an item 7. Do more than queries!

1. Sign up to PlanetScale

Go to https://auth.planetscale.com/sign-up

2. Create a new database

Select New database on the dashboard.

Create a database.

3. Create a password

Go to Settings → Passwords and click New password.

Save the host, username, and password values as Val Town secrets – use planetScaleHost, planetScaleUsername, and planetScalePassword respectively.

4. Create your first table

Copy and paste this val to create a table with the given schema.

5. Insert an item

Insert one or more items.

6. Query an item

Use the rows property to get your query results – or return the entire results object to see what other data is available.

7. Do more than queries!

Read the source of the @vtdocs.queryPlanetScale helper, see how it uses the @planetscale/database SDK, refer to the driver’s documentation, and extend it!