Navigation

Blog

Get the RSS feed

By Aaron Francis |

Understanding the differences between character sets and collations in MySQL.


By Brian Morrison II |

A guide on how to natively integrate your PlanetScale database into Cloudflare workers easily and securely.


By Matt Lord |

Learn the main differences between MariaDB and MySQL, why you might choose one over the other, scaling options, and how Vitess fits into the picture.


By Taylor Barnett |

Learn about safely using the expand, migrate, and contract pattern to make database schema changes without downtime and data loss.


By Aaron Francis |

There are several reasons why MySQL might not consider your index, and in this article we’ll explore some of the most common ones.


By Matthieu Napoli |

Learn how to create serverless Laravel applications by deploying them to AWS Lambda and using PlanetScale as the database.


By Shlomi Noach |

Learn how PlanetScale uses Git-like three-way diff to resolve schema change conflicts across database branches.


By Rafer Hazen |

You can now use Insights to view time-series performance data on a per-query pattern basis.


By Aaron Francis |

Everything you need to know about MySQL as an application developer, with a focus on improving query performance. After covering the high-level overview, we’ll put the learnings to the test with some hands-on examples.


By Aaron Francis |

An overview of the different ways to paginate in MySQL including limit/offset pagination and cursor pagination plus the pros and cons of each.


By Taylor Barnett |

How to prevent schema changes from being scary with database best practices and PlanetScale.


By Justin Gage |

Learn what database sharding is, how sharding works, and some common sharding frameworks and tools.


By Nick Van Wiggeren |

Learn about our latest update safe migrations and how it affects our branching workflow.


By Brian Morrison II |

Easily integrate common PlanetScale operations directly into your GitHub Actions Workflows.


By Liz van Dijk |

PlanetScale and Netlify join forces to cover how to integrate PlanetScale into Netlify Functions for common SaaS application use cases.


By Savannah Longoria |

Learn how to read the output in MySQL EXPLAIN plans so you can utilize them to improve query performance.


By Harshit Gangal |

Connection pooling reduces the overhead of establishing new database connections. Learn how connection pooling works and how it is handled in Vitess.


By 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.


By Mike Coutermarsh |

Learn about the Ruby on Rails workflow that protects your database and application from accidental downtime and data loss.


By Savannah Longoria |

What does the MySQL 5.7 EOL means for your database? Learn considerations to upgrade 8.0 and how PlanetScale can help you upgrade with no downtime or data loss.


By Anthony Herbert |

Learn how to using Python SQLAlchemy with MySQL by working through an example of creating tables, inserting data, and querying data with both raw SQL and SQLAlchemy ORM.


By Jason Long |

Learn about some of the latest enhancements we made to the Branching page in the PlanetScale dashboard.


By Vitess Engineering Team |

Vitess 16 is now generally available with updates to VDiff v2 VTOrc MySQL compatibility and more.


By JD Lien |

Learn about some of the possible downsides of using database indexes and how to remove unused database indexes in MySQL.


By Matt Robenolt |

Join PlanetScale’s Lead Infrastructure Engineer for Edge connectivity for an explainer on our findings regarding HTTP/3 and the MySQL protocol.