$ -weight: 500;">npm -weight: 500;">install @planetscale/database
-weight: 500;">npm -weight: 500;">install @planetscale/database
-weight: 500;">npm -weight: 500;">install @planetscale/database
import { connect } from "@planetscale/database"; const conn = connect({ host: "aws.connect.psdb.cloud", username: "YOUR_USERNAME", password: "YOUR_PASSWORD",
}); // Query
const results = await conn.execute("SELECT * FROM users WHERE email = ?", [ "[email protected]",
]);
console.log(results.rows); // Insert
await conn.execute( "INSERT INTO users (name, email) VALUES (?, ?)", ["Alex", "[email protected]"]
);
import { connect } from "@planetscale/database"; const conn = connect({ host: "aws.connect.psdb.cloud", username: "YOUR_USERNAME", password: "YOUR_PASSWORD",
}); // Query
const results = await conn.execute("SELECT * FROM users WHERE email = ?", [ "[email protected]",
]);
console.log(results.rows); // Insert
await conn.execute( "INSERT INTO users (name, email) VALUES (?, ?)", ["Alex", "[email protected]"]
);
import { connect } from "@planetscale/database"; const conn = connect({ host: "aws.connect.psdb.cloud", username: "YOUR_USERNAME", password: "YOUR_PASSWORD",
}); // Query
const results = await conn.execute("SELECT * FROM users WHERE email = ?", [ "[email protected]",
]);
console.log(results.rows); // Insert
await conn.execute( "INSERT INTO users (name, email) VALUES (?, ?)", ["Alex", "[email protected]"]
);
import mysql.connector conn = mysql.connector.connect( host="aws.connect.psdb.cloud", user="YOUR_USERNAME", password="YOUR_PASSWORD", database="mydb", ssl_ca="/etc/ssl/cert.pem"
) cursor = conn.cursor(dictionary=True)
cursor.execute("SELECT * FROM users WHERE email = %s", ("[email protected]",))
users = cursor.fetchall()
print(users)
import mysql.connector conn = mysql.connector.connect( host="aws.connect.psdb.cloud", user="YOUR_USERNAME", password="YOUR_PASSWORD", database="mydb", ssl_ca="/etc/ssl/cert.pem"
) cursor = conn.cursor(dictionary=True)
cursor.execute("SELECT * FROM users WHERE email = %s", ("[email protected]",))
users = cursor.fetchall()
print(users)
import mysql.connector conn = mysql.connector.connect( host="aws.connect.psdb.cloud", user="YOUR_USERNAME", password="YOUR_PASSWORD", database="mydb", ssl_ca="/etc/ssl/cert.pem"
) cursor = conn.cursor(dictionary=True)
cursor.execute("SELECT * FROM users WHERE email = %s", ("[email protected]",))
users = cursor.fetchall()
print(users)
# Install CLI
-weight: 500;">brew -weight: 500;">install planetscale/tap/pscale # Create a branch
pscale branch create mydb add-orders-table # Switch to branch and modify schema safely
pscale shell mydb add-orders-table
> CREATE TABLE orders (
> id BIGINT AUTO_INCREMENT PRIMARY KEY,
> user_id BIGINT NOT NULL,
> amount DECIMAL(10,2),
> created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
> ); # Create a deploy request (like a PR for your schema)
pscale deploy-request create mydb add-orders-table # Deploy — zero downtime, no locks
pscale deploy-request deploy mydb 1
# Install CLI
-weight: 500;">brew -weight: 500;">install planetscale/tap/pscale # Create a branch
pscale branch create mydb add-orders-table # Switch to branch and modify schema safely
pscale shell mydb add-orders-table
> CREATE TABLE orders (
> id BIGINT AUTO_INCREMENT PRIMARY KEY,
> user_id BIGINT NOT NULL,
> amount DECIMAL(10,2),
> created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
> ); # Create a deploy request (like a PR for your schema)
pscale deploy-request create mydb add-orders-table # Deploy — zero downtime, no locks
pscale deploy-request deploy mydb 1
# Install CLI
-weight: 500;">brew -weight: 500;">install planetscale/tap/pscale # Create a branch
pscale branch create mydb add-orders-table # Switch to branch and modify schema safely
pscale shell mydb add-orders-table
> CREATE TABLE orders (
> id BIGINT AUTO_INCREMENT PRIMARY KEY,
> user_id BIGINT NOT NULL,
> amount DECIMAL(10,2),
> created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
> ); # Create a deploy request (like a PR for your schema)
pscale deploy-request create mydb add-orders-table # Deploy — zero downtime, no locks
pscale deploy-request deploy mydb 1 - Schema branching — create a branch, modify schema, merge when ready
- Zero-downtime migrations — deploy schema changes without locking tables
- Built on Vitess — horizontal sharding that scales to billions of rows
- Serverless driver — connect from edge/serverless without connection pooling
- MySQL compatible — works with any MySQL client, ORM, or tool
- Insights — query analytics and performance monitoring built in - 30+ Free APIs Every Developer Should Bookmark
- Algolia Has a Free Tier
- MongoDB Atlas Has a Free Tier
- Auth0 Has a Free Tier
- Cloudinary Has a Free API
- OpenAI Has a Free API Tier
- Firebase Has a Free Tier
- Supabase Has a Free Tier
- Stripe Has a Free API
- Vercel Has a Free Tier
- Telegram Has a Free Bot API
- Resend Has a Free API
- Upstash Has a Free API
- Neon Has a Free API
