neon-new

import { instantPostgres } from "neon-new/sdk"; import fs from 'fs'; import path from 'path'; async function setupDatabase() { const dotEnvPath = path.resolve(process.cwd(), '.env'); // Ensure .env file exists for the SDK to write to if (!fs.existsSync(dotEnvPath)) { fs.writeFileSync(dotEnvPath, ''); } console.log("Creating a new Neon database..."); const result = await instantPostgres({ referrer: process.env.NEON_APP_REFERRER || "checklist-day-example", // REQUIRED for SDK usage dotEnvFile: ".env", dotEnvKey: "DATABASE_URL", envPrefix: "PUBLIC_", settings: { logicalReplication: false, }, }); console.log("Database created successfully!"); console.log(`Pooled Connection String: ${result.databaseUrl}`); console.log(`Direct Connection String: ${result.databaseUrlDirect}`); console.log(`Claim URL (expires in 72h): ${result.claimUrl}`); console.log(`Credentials saved to ${dotEnvPath}`); // To connect, you would typically use a PostgreSQL client library (e.g., 'pg'): // import { Client } from 'pg'; // const client = new Client({ connectionString: result.databaseUrl }); // await client.connect(); // const res = await client.query('SELECT NOW()'); // console.log('Database time:', res.rows[0].now); // await client.end(); } setupDatabase().catch(console.error);