Update How to Migrate to PlanetScale’s Serverless Database

Main Contents:

How to Migrate to PlanetScale’s Serverless Database is an article under the topic Data Science Many of you are most interested in today !! Today, let’s InApps.net learn How to Migrate to PlanetScale’s Serverless Database in today’s post !

Read more about How to Migrate to PlanetScale’s Serverless Database at Wikipedia

You can find content about How to Migrate to PlanetScale’s Serverless Database from the Wikipedia website

Lee Robinson

Lee Robinson is a developer, writer, and creator who works closely with Vercel customers and helps grow the Next.js community through education and training. Before joining Vercel, he scaled web development at a $10B retailer. In his free time, he enjoys playing music, photography/videography and has his own YouTube channel with over 16,000 subscribers.

As a developer, I’m always trying to learn new technologies through experimentation and building. I’ve recently been interested in serverless databases, which promise faster deployment, higher scalability, and improved developer experience. After testing multiple offerings, I decided to move my personal website from using Firebase and Redis to PlanetScale, a new serverless database platform built on MySQL and Vitess, an open-source platform built to power YouTube.

Here’s why I chose PlanetScale:

Database Branching: I’m able to use my database with the same mental model as Git. For each change to my database schema, I open a deploy request. Then, I can merge those changes back into my main database branch.
Prisma Support: In combination with Prisma, it’s so easy to handle database migrations.
Connectionless: Since PlanetScale is serverless, it’s built to withstand thousands of simultaneous connections. You can almost consider this connectionless as I don’t need to worry about pooling or other common objections.
Deploy in 10 Seconds: After testing 13 databases, PlanetScale was the fastest to deploy. After using it for a few weeks and monitoring performance, I’m seeing APIs resolve in ~150ms on average (see results below).

Firebase and Redis

My site previously used Google Firebase and Redis for real-time blog post views and my guestbook. The primary decision for choosing these technologies was to learn. Both Firebase and Redis (through Upstash) are easy to get started, scale without thinking, and work great in serverless environments. However, I wanted to move to something SQL-based (either MySQL or PostgreSQL) for a new learning experience.

Rebuilding SQL

I found myself writing JavaScript in places where SQL has the functionality built-in. For example, I used Firebase to fetch JSON object views and then summed the values together to find the total number of views.

<br /><br /><br /><br /><br />
const snapshot = await db.ref(‘views’).once(‘value’);</p><br /><br /><br /><br />
<p>const views = snapshot.val();</p><br /><br /><br /><br />
<p>const allViews = Object.values(views).reduce((total, value) =&gt; total + value);</p><br /><br /><br /><br />
<p>With SQL, you can use SUM() instead. </p><br /><br /><br /><br />
<p>SELECT SUM(count) as total</p><br /><br /><br /><br />
<p>FROM views;

const snapshot = await db.ref(‘views’).once(‘value’);

const views = snapshot.val();

const allViews = Object.values(views).reduce((total, value) => total + value);

With SQL, you can use SUM() instead.

SELECT SUM(count) as total

FROM views;

Same thing with sorting. Before I was using JavaScript sort and now I can use ORDER BY. Although Firebase does have something similar, I did not use it.

<br /><br /><br /><br /><br />
SELECT * FROM guestbook</p><br /><br /><br /><br />
<p>ORDER BY updated_at DESC;

SELECT * FROM guestbook

ORDER BY updated_at DESC;

SQL is boring, proven technology. It’s been around for years and will continue to be around for many more. I’ve used it before in prior jobs, but still felt I could understand it better. I also enjoy using PostgreSQL (and recommend Supabase) and strongly considered that solution as well.

I’m also a strong believer in using tools I recommend. Without actually getting my hands dirty in code and running an application in production, it’s hard to confidently recommend a product to others. After using the PlanetScale Vercel Integration, I was blown away. I could deploy an entire full-stack application in just a few clicks. And as I mentioned at the start, database migrations aligned with my mental model.

Migrating Existing Data

There may be better ways to do this, but my hacky solution to migrate data into PlanetScale was as follows:

Export JSON data from my Firebase Realtime Database
Export JSON data from my Redis cluster using HVALS and TablePlus
Create a new database branch in PlanetScale for the schema migration adding the tables
Create two new API routes, which loaded the JSON data and INSERT INTO MySQL
Verify on the database branch the APIs correctly process and migrate the data
Create a deploy request with the new schema changes and merge it into main
Finally, hit the APIs to migrate the JSON data into main
Done!

Here are the two scripts I used, for reference.

<br /><br /><br /><br /><br />
import db from ‘lib/planetscale’;</p><br /><br /><br /><br />
<p>import guestbookData from ‘data/guestbook’;</p><br /><br /><br /><br />
<p>export default async function handler(req, res) {</p><br /><br /><br /><br />
<p>  const toISOString = (unixTimestampInMs) =&gt;</p><br /><br /><br /><br />
<p>    new Date(unixTimestampInMs).toJSON().slice(0, 19).replace(‘T’, ‘ ‘);</p><br /><br /><br /><br />
<p>  let query = `INSERT INTO guestbook (email, updated_at, body, created_by)</p><br /><br /><br /><br />
<p>    VALUES `;</p><br /><br /><br /><br />
<p>  const escapeStr = (str) =&gt;</p><br /><br /><br /><br />
<p>    str</p><br /><br /><br /><br />
<p>      .replace(/\/g, ‘\\’)</p><br /><br /><br /><br />
<p>      .replace(/$/g, ‘\$’)</p><br /><br /><br /><br />
<p>      .replace(/’/g, “\'”)</p><br /><br /><br /><br />
<p>      .replace(/”/g, ‘\’);</p><br /><br /><br /><br />

Rate this post

Phu Nguyen

As a Senior Tech Enthusiast, I bring a decade of experience to the realm of tech writing, blending deep industry knowledge with a passion for storytelling. With expertise in software development to emerging tech trends like AI and IoT—my articles not only inform but also inspire. My journey in tech writing has been marked by a commitment to accuracy, clarity, and engaging storytelling, making me a trusted voice in the tech community.