supabase-realtime-math-game
Stars
5
Ecosystems:
TypeScript
This is a Next.js project bootstrapped with create-next-app.
Getting Started
First, run the development server:
npm run dev
# or
yarn dev
# or
pnpm dev
# or
bun dev
Open http://localhost:3000 with your browser to see the result.
You can start editing the page by modifying app/page.tsx. The page auto-updates as you edit the file.
This project uses next/font to automatically optimize and load Inter, a custom Google Font.
Learn More
To learn more about Next.js, take a look at the following resources:
- Next.js Documentation - learn about Next.js features and API.
- Learn Next.js - an interactive Next.js tutorial.
You can check out the Next.js GitHub repository - your feedback and contributions are welcome!
Deploy on Vercel
The easiest way to deploy your Next.js app is to use the Vercel Platform from the creators of Next.js.
Check out our Next.js deployment documentation for more details.
Notes
Postgres trigger:
CREATE OR REPLACE FUNCTION end_game(room_name text) RETURNS void AS $$
BEGIN
PERFORM pg_sleep(600); -- 600 seconds = 10 minutes
UPDATE rooms SET status='finished' WHERE room_name = room_name;
END;
$$ LANGUAGE plpgsql;
CREATE OR REPLACE FUNCTION check_all_players_ready()
RETURNS TRIGGER AS $$
BEGIN
IF (SELECT COUNT(*) FROM results WHERE room_name = NEW.room_name AND ready = false) = 0 THEN
UPDATE rooms SET status='starting' WHERE room_name = NEW.room_name;
SELECT end_game(NEW.room_name);
END IF;
RETURN NEW;
END;
$$ LANGUAGE plpgsql;
CREATE OR REPLACE TRIGGER trigger_all_players_ready
AFTER UPDATE ON results
FOR EACH ROW
EXECUTE FUNCTION check_all_players_ready();