Full-stack real-time chat - Data: PostgeSQL managed by Supabase @supabaseio (awsome real-time API). - Front-end: React + Vite - UI library:…
Full-stack real-time chat - Data: PostgeSQL managed by Supabase @supabaseio (awsome real-time API). - Front-end: React + Vite - UI library:…
npm install to setup dependencies
Create a .env file with VITE_SUPABASE_URL and VITE_SUPABASE_KEY (see env.example)
The following database table is required:
| Field | Type |
|---|---|
| id | BIGINT |
| username | VARCHAR |
| text | TEXT |
| country | VARCHAR |
| is_authenticated | BOOLEAN |
| timestamp | timestamp |
SQL query if not using the Supabase interface:
CREATE TABLE messages (
id bigint GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
username VARCHAR NOT NULL,
text TEXT NOT NULL,
country VARCHAR,
is_authenticated BOOLEAN DEFAULT FALSE,
timestamp timestamp default now() NOT NULL
);Note: If you're using Supabase interface, don't forget to tick Enable Realtime setting after you created the table.
Follow instrunction here
npm run dev to run server on port 3000
npm run build to build the react client
No open issues yet, or sync has not completed.