Demo 15: Deploy & Database

Connected to PostgreSQL (localhost:5432/myapp)
Server version: PostgreSQL 16.2
Tables: 23 | Views: 4 | Size: 142 MB

Connection saved as: myapp-local
Use /db switch myapp-local to reconnect later.

Query Results (5 rows, 12ms)
+----+----------------+-------------------------+---------------------+
| id | name           | email                   | created_at          |
+----+----------------+-------------------------+---------------------+
| 42 | Alice Johnson  | alice@example.com       | 2026-03-12 14:22:01 |
| 41 | Bob Chen       | bob.chen@example.com    | 2026-03-11 09:15:33 |
| 40 | Carol Davis    | carol.d@example.com     | 2026-03-10 16:48:55 |
| 39 | Dan Williams   | dan.w@example.com       | 2026-03-09 11:30:22 |
| 38 | Eve Martinez   | eve.m@example.com       | 2026-03-08 08:05:10 |
+----+----------------+-------------------------+---------------------+

5 rows returned in 12ms

Table: users
=============
Column        Type            Nullable  Default          Constraints
----------    -----------     --------  ---------------  -----------
id            SERIAL          NO        nextval(seq)     PRIMARY KEY
name          VARCHAR(255)    NO                         NOT NULL
email         VARCHAR(255)    NO                         UNIQUE, NOT NULL
password_hash VARCHAR(255)    NO                         NOT NULL
role          VARCHAR(50)     YES       'user'
created_at    TIMESTAMPTZ     NO        NOW()
updated_at    TIMESTAMPTZ     YES

Indexes:
  users_pkey          PRIMARY KEY (id)
  users_email_key     UNIQUE (email)
  idx_users_role      BTREE (role)
  idx_users_created   BTREE (created_at DESC)

Foreign keys referencing this table:
  orders.user_id     -> users.id (ON DELETE CASCADE)
  sessions.user_id   -> users.id (ON DELETE CASCADE)
  profiles.user_id   -> users.id (ON DELETE CASCADE)

Row count: 1,247  |  Table size: 2.1 MB  |  Index size: 384 KB

Created migration:
  migrations/20260313_143022_add_phone_to_users.sql

Edit the file and add your UP and DOWN SQL:
  -- UP
  ALTER TABLE users ADD COLUMN phone VARCHAR(20);

  -- DOWN
  ALTER TABLE users DROP COLUMN phone;

Running migrations...
  [1/1] 20260313_143022_add_phone_to_users.sql ... OK (23ms)

Applied 1 migration. Current version: 20260313_143022

Migration Status
=================
  20260101_000001_create_users           applied    2026-01-01
  20260115_120000_add_orders_table       applied    2026-01-15
  20260201_090000_add_sessions           applied    2026-02-01
  20260313_143022_add_phone_to_users     applied    2026-03-13

4 applied, 0 pending

-- Generated by VibeCody on 2026-03-13
-- Database: myapp (PostgreSQL 16.2)

CREATE TABLE users (
    id SERIAL PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    email VARCHAR(255) NOT NULL UNIQUE,
    password_hash VARCHAR(255) NOT NULL,
    role VARCHAR(50) DEFAULT 'user',
    created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
    updated_at TIMESTAMPTZ
);

CREATE INDEX idx_users_role ON users (role);
CREATE INDEX idx_users_created ON users (created_at DESC);

CREATE TABLE orders (
    id SERIAL PRIMARY KEY,
    user_id INTEGER NOT NULL REFERENCES users(id) ON DELETE CASCADE,
    total_cents INTEGER NOT NULL,
    status VARCHAR(50) NOT NULL DEFAULT 'pending',
    created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

-- ... (23 tables total)

Saved to: .vibecli/generated/schema.sql

Generated schema for: e-commerce app
=====================================

CREATE TABLE users (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    name VARCHAR(255) NOT NULL,
    email VARCHAR(255) NOT NULL UNIQUE,
    password_hash VARCHAR(255) NOT NULL,
    created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

CREATE TABLE products (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    name VARCHAR(255) NOT NULL,
    description TEXT,
    price_cents INTEGER NOT NULL CHECK (price_cents >= 0),
    stock INTEGER NOT NULL DEFAULT 0,
    created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

CREATE TABLE orders (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    user_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE,
    status VARCHAR(50) NOT NULL DEFAULT 'pending',
    total_cents INTEGER NOT NULL CHECK (total_cents >= 0),
    created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

CREATE TABLE order_items (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    order_id UUID NOT NULL REFERENCES orders(id) ON DELETE CASCADE,
    product_id UUID NOT NULL REFERENCES products(id),
    quantity INTEGER NOT NULL CHECK (quantity > 0),
    unit_price_cents INTEGER NOT NULL
);

CREATE TABLE reviews (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    user_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE,
    product_id UUID NOT NULL REFERENCES products(id) ON DELETE CASCADE,
    rating INTEGER NOT NULL CHECK (rating BETWEEN 1 AND 5),
    body TEXT,
    created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
    UNIQUE (user_id, product_id)
);

Saved to: .vibecli/generated/ecommerce-schema.sql
Apply to database? [y/n]:

Supabase Tables (xyzcompany)
==============================
Table         Rows    RLS     Realtime
----------    -----   ------  --------
users         1,247   ON      OFF
orders        3,891   ON      ON
products      456     OFF     OFF
reviews       2,103   ON      OFF
sessions      892     ON      OFF

Warning: `products` has RLS disabled -- consider enabling it.

Suggested RLS Policies for `products`:
  1. Allow authenticated read:
     CREATE POLICY "products_select" ON products
       FOR SELECT USING (auth.role() = 'authenticated');

  2. Allow admin insert/update:
     CREATE POLICY "products_admin_write" ON products
       FOR ALL USING (auth.jwt() ->> 'role' = 'admin');

Apply policies? [y/n]:

Deploying to staging...
  [1/5] Building release binary        OK  (45s)
  [2/5] Running tests                  OK  (12s, 234 passed)
  [3/5] Building Docker image          OK  (30s)
  [4/5] Pushing to registry            OK  (8s)
  [5/5] Updating ECS service           OK  (25s)

Deployment complete!
  URL:      https://staging.myapp.com
  Image:    ghcr.io/myorg/myapp:v1.2.3-rc1
  Duration: 2m 00s