Find out how many connections your Light Cloud PostgreSQL database allows, see who is using them, and size your app's pool so it never runs out.
Fix 'too many connections for role' on Light Cloud PostgreSQL: check the 10-connection limit, see who holds connections, and size pool max x instances.
Read post
Run database migrations on every Light Cloud deploy: a node-pg-migrate SQL file, npm start running it before the server, and why rollbacks leave the schema alone.
Julia
Vercel alternatives for a full-stack app: Light Cloud runs the frontend, a container API and Postgres for $5 a month with a free staging password, Railway comes to about $6 once its usage is counted, while Vercel Pro is $20 a seat and $20 per project for password protection, with Postgres from a second vendor: Vercel and Neon together come to $20 to $40.
Julia
Rotate a Light Cloud PostgreSQL password safely: choose the new password, update DATABASE_URL first, rotate when the deploy finishes. 7 seconds of errors, not 2 minutes.
Julia
Import a SQL dump into a Light Cloud PostgreSQL database: upload a .sql or .sql.gz with Import dump, or stream a large dump with psql in one transaction.
Julia
Where to deploy a SaaS boilerplate such as ShipFast, Makerkit, Supastarter or Open SaaS: Light Cloud runs the Next.js or Node app plus Postgres for $5 a month, Railway comes to about $7 once its usage is counted, and Vercel, which three of the four kits recommend, needs Pro at $20 once the app takes payments, plus a database from a second vendor.
Julia
Back up a Light Cloud PostgreSQL database: download a .sql.gz dump from the Backup tab, restore it into a new database with psql, and script it with pg_dump.
Julia
Run SQL on a Light Cloud PostgreSQL database from the browser: read-only queries, joins and totals, then a quick UPDATE with Allow writes and RETURNING.
Julia
Free REST API hosting for a small Express or FastAPI app: Light Cloud is the only free plan that passes all five checks (no card, no rewrite, a few seconds to wake, never billed), up to about 4,800 requests a day. Cloudflare Workers is free for 100,000 requests a day if you write for its runtime.
Julia
Use the Light Cloud data explorer to browse PostgreSQL tables, edit and insert rows, add columns, create tables and delete rows, without installing a SQL client.
Julia