JavaScript SDK: マネージドデータベース

const db = await api.databases.create({
    name: "my-db",
    type: "postgres", // "mongo" | "mysql" | "redis" | "postgres"
    version: "17",    // a full version or a prefix
    memory: 1024,     // MB, a whole number
});

console.log(db.id, db.connection_url, db.cluster);
console.log(db.password);    // shown only here: save it
console.log(db.certificate); // base64 PEM (private key, then certificate), or null

const db = await api.databases.get(databaseId);

console.log(db.id, db.name, db.type, db.ram, db.port, db.cluster, db.created_at);

await api.databases.update(databaseId, { name: "orders", ram: 2048 });

await api.databases.start(databaseId);
await api.databases.stop(databaseId);

const status = await api.databases.status(databaseId);
console.log(status.running, status.cpu, status.ram); // true "0.5%" "120.4MB"

const raw = await api.databases.status(databaseId, { raw: true });
console.log(raw.cpu, raw.ram); // 0.5 120.4

for (const { id, running, cpu, ram } of await api.databases.statusAll()) {
    console.log(id, running, cpu, ram); // cpu and ram only while running
}

const [latest] = await api.databases.metrics(databaseId);
console.log(latest.date, latest.cpu, latest.ram);

const certificate = await api.databases.certificate(databaseId);
const pem = atob(certificate);

const password = await api.databases.resetCredentials(databaseId, "password");
await api.databases.resetCredentials(databaseId, "certificate"); // ""

await api.databases.delete(databaseId);