Issues in demo folder's README #507
Description
While following the setup instructions in the demo folder’s README, I encountered a couple of issues:
- Creating a field called user return an error
The current README suggests creating thetaskstable with a column nameduser:
CREATE TABLE tasks (
id SERIAL PRIMARY KEY,
created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
user UUID NOT NULL,
title TEXT,
completed BOOLEAN DEFAULT FALSE
);However, user is a reserved keyword in Postgre, which causes an error when running this query in supabase
fix:
CREATE TABLE tasks (
id SERIAL PRIMARY KEY,
created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
"user" UUID NOT NULL,
title TEXT,
completed BOOLEAN DEFAULT FALSE
);- Incorrect SUPABASE_URL Domain
Current README:
SUPABASE_URL="https://example.supabase.com"
SUPABASE_KEY="<your_key>"
However, the correct domain should be .co not .com.
fix:
SUPABASE_URL="https://example.supabase.co"
SUPABASE_KEY="<your_key>"