Blog
Nick Van Wiggeren [@NickVanWig] |
Stream real time video and audio through PostgreSQL on PlanetScale. →
Simeon Griggs [@simeonGriggs] |
Build a real-time application with PlanetScale and the Cloudflare global network. Infrastructure choices you won't need to migrate away from once you hit scale. →
Learn how to sync user data from a Clerk project into your PlanetScale MySQL database with webhooks using Netlify and Netlify Functions. →
Learn how to build virtual relationships between tables in PlanetScale while using the Drizzle TypeScript ORM. →
Learn how middleware technology works, the pitfalls of application-level sharding, and how Vitess enables horizontal sharding of MySQL for near infinite scale. →
Learn how to integrate PlanetScale with Node applications built using the Serverless Framework on AWS. →
Learn how the schema migrations are performed iteratively by evolving change scripts. →
Learn how the schema migrations are performed using a single state definition. →
JD Lien |
Learn what you should look out for when upgrading an existing database from MySQL 5.7 to 8 and how to change your database to be compatible with the new version. →
Learn how to use Python SQLAlchemy with MySQL by working through an example of creating tables, inserting data, and querying data with both raw SQL and SQLAlchemy ORM. →
Learn how to migrate from Postgres to MySQL, Postgres vs MySQL incompatibilities, and more. →
An overview of some common MySQL error codes you may run into, what they mean, and how to solve them. →
JD Lien |
Learn what the N+1 queries problem is by working through an example N+1 query updating it to a JOIN statement and going over how to identify them in the future. →
A quick glimpse on Support at PlanetScale and the issues we see the most often. →
Learn how to encrypt your connection strings so that not even AWS can access them. →
JD Lien |
Learn how and when to use inner joins, outer joins, left joins, and right joins in MySQL. →
Learn how to use the PlanetScale serverless driver by creating a serverless API in AWS with JavaScript. →
Learn how to use Atlas CLI with PlanetScale to define your database as code. →
Learn how to build an automated DevOps pipeline with AWS Lightsail CodeBuild and PlanetScale. →
Learn how to run commands in batch against a PlanetScale database using the PlanetScale CLI. →
Learn how to quickly get up and running with the PlanetScale CLI. →
Don’t let SQL injection attacks hurt your business. →
This database schema design guide walks you through walk through the basics of creating and designing schemas for relational databases. →
Learn how to build a Laravel CRUD application connect it to a MySQL database and seed it with data. →
Use Prisma and Next.js to automatically populate your database with data. →