Azande-news/azande-news

# Azande News A free, worldwide community news site for the Azande people of Western Equatoria, South Sudan, and the diaspora. Anyone can read; anyone who registers a free account can log in and publish a post. **What's included in this version:** - Free registration and secure login - Publishing posts with categories, and an optional cover photo - Comments under each post - A "Report this post" button so readers can flag problem content - An admin dashboard (`/admin`) to remove or delete posts, resolve reports, and promote other users to admin - Category pages so people can browse just Culture, History, etc. This guide takes you from this folder of code to a live website, using only free accounts. No credit card required anywhere. --- ## What you're setting up | Piece | Service | Cost | |---|---|---| | Website hosting | Vercel | Free | | Database + login system | Supabase | Free | | Code storage | GitHub | Free | --- ## Step 1 — Create your Supabase project (the database + login system) 1. Go to **supabase.com** and click **Start your project**. Sign up (free, no card). 2. Click **New project**. Give it a name like `azande-news`, set a database password (save it somewhere safe), pick the region closest to your main audience, and click **Create new project**. Wait ~2 minutes. 3. In the left sidebar, open **SQL Editor** → **New query**. 4. Open the file `supabase/schema.sql` from this project, copy **all** of it, paste it into the SQL editor, and click **Run**. This creates all the tables and — importantly — the security rules that: - let anyone in the world read posts, without logging in - only let a logged-in person post as themselves - only let the author (or an admin) edit or delete their own post 5. In the left sidebar, go to **Project Settings → API**. You'll need two values from this page in Step 3: - **Project URL** - **anon public** key ### Turn off email confirmation delay (optional, for easier testing) By default Supabase emails a confirm …