Official Planetscale
(cloud MySql) driver for StoreCraft
on any platforms.
npm i @storecraft/database-planetscale
- First, login to your planetscale account.
- Create a database.
- Copy the
connection string
.
import 'dotenv/config';
import http from "node:http";
import { App } from '@storecraft/core'
import { NodePlatform } from '@storecraft/core/platform/node';
import { NodeLocalStorage } from '@storecraft/core/storage/node'
import { PlanetScale } from '@storecraft/database-planetscale'
import { migrateToLatest } from '@storecraft/database-planetscale/migrate.js'
const app = new App(
{
auth_admins_emails: ['admin@sc.com'],
auth_secret_access_token: 'auth_secret_access_token',
auth_secret_refresh_token: 'auth_secret_refresh_token'
}
)
.withPlatform(new NodePlatform())
.withDatabase(
new PlanetScale(
{
url: process.env.PLANETSCALE_CONNECTION_URL,
useSharedConnection: true
}
)
)
.withStorage(new NodeLocalStorage('storage'))
await app.init();
await migrateToLatest(app.db, false);
const server = http.createServer(app.handler).listen(
8000,
() => {
console.log(`Server is running on http://localhost:8000`);
}
);
Author: Tomer Shalev <tomer.shalev@gmail.com>