Neon PostgreSQL

Polsia apps use Neon PostgreSQL. DATABASE_URL is automatically provided.

Connection

const { Pool } = require('pg');
const pool = new Pool({ connectionString: process.env.DATABASE_URL });

Migrations

Create files in migrations/ with timestamp prefix: 1704067200000_add_products_table.js

Migration Format

module.exports = {
  up: async (pool) => {
    await pool.query(`CREATE TABLE products (...)`);
  },
  down: async (pool) => {
    await pool.query(`DROP TABLE products`);
  }
};

Key Rules

• DATABASE_URL is NOT available at build time on Render
• Run migrations in startCommand, not buildCommand
• Always use parameterized queries ($1, $2) for user input