Comparing Vercel Storage and Heroku
Moeki Kawakami
Posted on May 15, 2023
I tried Vercel Storage.
https://vercel.com/blog/vercel-storage
I compared it with an app that was running on Heroku.
It's Blitz.js, but please don't worry about that too much.
Diff
diff --git a/Procfile b/Procfile
deleted file mode 100644
index bc6eb1f..0000000
--- a/Procfile
+++ /dev/null
@@ -1,2 +0,0 @@
-release: npx blitz prisma migrate deploy
-web: npm run start:production
diff --git a/db/schema.prisma b/db/schema.prisma
index 0f8f549..3a35c9b 100644
--- a/db/schema.prisma
+++ b/db/schema.prisma
@@ -2,8 +2,9 @@
// learn more about it in the docs: https://pris.ly/d/prisma-schema
datasource db {
- provider = "postgresql"
- url = env("DATABASE_URL")
+ provider = "postgresql"
+ url = env("POSTGRES_PRISMA_URL") // uses connection pooling
+ shadowDatabaseUrl = env("POSTGRES_URL_NON_POOLING") // used for migrations
}
generator client {
diff --git a/package.json b/package.json
index f6484ea..a1e0358 100644
--- a/package.json
+++ b/package.json
@@ -3,14 +3,13 @@
"version": "1.0.0",
"scripts": {
"dev": "blitz dev",
- "build": "blitz build",
+ "build": "blitz prisma migrate deploy && blitz build",
"start": "blitz start",
"studio": "blitz prisma studio",
"lint": "eslint --ignore-path .gitignore --ext .js,.ts,.tsx .",
"test": "vitest run --passWithNoTests",
"test:watch": "vitest",
- "prepare": "husky install",
- "start:production": "blitz start --port $PORT"
+ "prepare": "husky install"
},
"prisma": {
"schema": "db/schema.prisma"
- Run migration with
npm run build
instead ofProcfile
- Replace with the recommended official env for Postgres URLs
Comparison between Heroku and Vercel
Comparison in this case.
Vercel | Heroku | |
---|---|---|
Migration | npm run build |
Procfile |
Deploy time | 1m30s | 4m |
Performance | Good | Good |
Pricing | Free (up to 1 Database) | $7.00 + $9.00 |
I didn't expect this comparison table to be realized.
Conclusion
It's nice. Keep up the good work, Vercel.
💖 💪 🙅 🚩
Moeki Kawakami
Posted on May 15, 2023
Join Our Newsletter. No Spam, Only the good stuff.
Sign up to receive the latest update from our blog.
Related
githubcopilot AI Innovations at Microsoft Ignite 2024 What You Need to Know (Part 2)
November 29, 2024