Tagged: postgres

17 posts · all posts

• Your AI app probably has no real backup

  7 July 2026

  AI builders make it easy to ship, easy to skip backups. Here's how to check whether your app is actually backed up, and how to fix it if it isn't.

  #backups#postgres#risk
• What breaks first when your MVP gets traffic

  7 July 2026

  Your AI-built app runs fine with ten users. Here's what falls over first at a thousand, and how to fix each failure before it costs you the launch.

  #scaling#performance#postgres
• Why your free-tier project keeps pausing itself

  7 July 2026

  Backend-as-a-service platforms pause free-tier projects after inactivity. Here's why, how to unpause one, and how to stop it happening to a live app.

  #backend-as-a-service#postgres#hosting
• What backend-as-a-service costs after free tier

  7 July 2026

  The free tier is generous until it isn't. Here's what a Postgres-based backend-as-a-service platform really costs, add-ons included.

  #cost-comparison#postgres
• Migrating backend-as-a-service to Postgres

  7 July 2026

  The real decisions in a backend-as-a-service-to-Postgres move aren't the data dump. They're auth, RLS, and rollback.

  #postgres#migration
• How to back up your Lovable app (and test it)

  7 July 2026

  Lovable Cloud gives you 14 days of daily backups. Here's how to set up your own tested backup with point-in-time recovery instead.

  #backups#postgres#tutorial
• Bolt.new database connection limits, explained

  7 July 2026

  Your Bolt.new app runs fine in the editor, then falls over on launch day. Here's why database connection limits are usually the cause, and how to check yours.

  #bolt-new#database#postgres
• Fixing missing indexes in an AI-generated schema

  7 July 2026

  AI tools rarely add database indexes, so queries that were instant at 100 rows crawl at 100,000. Here's how to find the missing ones with EXPLAIN and fix them.

  #postgres#performance#indexing
• Database migrations without downtime

  7 July 2026

  A schema change can lock your table and take your app offline mid-request. Here's the additive-first pattern that keeps users working.

  #database-migrations#postgres#zero-downtime
• Lovable Cloud vs your own Postgres

  7 July 2026

  Lovable Cloud is fast and hands-off. Your own Postgres is portable and controllable. Here's an honest look at what each one costs you.

  #lovable#postgres#comparison
• Managed sharded MySQL vs self-hosted Postgres

  7 July 2026

  A managed, sharded MySQL platform vs self-hosted Postgres, compared on cost, scaling, and effort once your free tier runs out.

  #postgres#mysql#cost-comparison
• Managed Postgres providers compared

  7 July 2026

  An honest comparison of a serverless Postgres provider, a backend-as-a-service platform, a big-cloud database, and self-hosted Postgres.

  #postgres#cost-comparison#managed-database
• Migrating from NoSQL to Postgres: the guide

  7 July 2026

  Real steps to move an app off a NoSQL backend-as-a-service platform to Postgres: export, map to tables, migrate auth, cut over.

  #postgres#migration#nosql
• Point-in-time recovery for Postgres, explained

  7 July 2026

  A daily snapshot restores you to last midnight. Point-in-time recovery restores you to the second before things broke. Here's how.

  #backups#postgres#point-in-time-recovery
• Why your AI app needs PgBouncer

  7 July 2026

  AI-built apps open a new Postgres connection per request and hit the wall under load. Here's the PgBouncer config that fixes it.

  #postgres#pgbouncer#performance
• Postgres row-level security exposed: an audit

  7 July 2026

  A copy-pasteable SQL audit that finds every Postgres table with RLS off or protected by a policy that lets everyone in, in about 15 minutes.

  #security#postgres
• Postmortem: a connection exhaustion, not a hack

  7 July 2026

  How a database connection pool ran dry, why it looked like an attack, and the simple fix that would have prevented it.

  #postmortem#postgres#database#reliability