Supabase PostgreSQL

create table practice_projects (
  id bigint generated always as identity primary key,
  name text not null unique,
  created_at timestamptz not null default now()
);

create table practice_tasks (
  id bigint generated always as identity primary key,
  project_id bigint not null references practice_projects(id),
  title text not null,
  completed boolean not null default false,
  priority smallint not null default 2 check (priority between 1 and 3),
  due_at timestamptz,
  created_at timestamptz not null default now()
);

insert into practice_projects (name) values ('Course'), ('Personal');

insert into practice_tasks (project_id, title, priority)
select id, 'Connect to Supabase', 1
from practice_projects
where name = 'Course';

insert into practice_tasks (project_id, title, priority)
select id, 'Review PostgreSQL constraints', 2
from practice_projects
where name = 'Course';

select p.name as project, t.title, t.priority, t.completed
from practice_projects p
join practice_tasks t on t.project_id = p.id
order by t.priority, t.id;

begin;

update practice_tasks
set completed = true
where title = 'Connect to Supabase';

select title, completed from practice_tasks;

rollback;

select title, completed from practice_tasks;

select current_database(), current_user, current_schema();
select version();
show timezone;
show search_path;

select table_schema, table_name
from information_schema.tables
where table_schema = 'public'
order by table_name;

select constraint_name, constraint_type
from information_schema.table_constraints
where table_name = 'practice_tasks'
order by constraint_type, constraint_name;

drop table if exists practice_tasks;
drop table if exists practice_projects;

Phase 08 SQL Lab

Run in order against the TaskFlow development Supabase project only:
  00_practice_schema.sql
  01_seed_and_query.sql
  02_transaction_practice.sql
  03_inspect.sql
  04_cleanup.sql

These are temporary learning tables. They are NOT the production TaskFlow schema.

DATABASE_URL=

TaskFlow - Phase 08 Supabase setup reference

This folder intentionally contains NO real credentials.

Expected private local file (not included):
  apps/api/.env

Documented variable:
  DATABASE_URL

Use the exact connection string copied from the Supabase Connect dialog.
For local persistent development on IPv4-only networks, the Session pooler is a practical choice.
Use SSL. Do not expose the connection string to browser code.