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