A school transportation management system built with SvelteKit and Supabase.
This application is configured for deployment on Vercel with Supabase for data storage.
- Create a Vercel account at vercel.com
- Create a Supabase account at supabase.com and set up a new project
- Install the Vercel CLI:
npm install -g vercel
Create the following tables in your Supabase project:
-
studentstable with columns:id(text, primary key)data(jsonb)
-
busestable with columns:id(text, primary key)data(jsonb)
-
incidentstable with columns:id(text, primary key)data(jsonb)
You need to set up the following environment variables in your Vercel project:
VITE_SUPABASE_URL: Your Supabase project URLVITE_SUPABASE_ANON_KEY: Your Supabase anonymous key (public)
- Login to Vercel CLI:
vercel login - Link to your Supabase project by adding the environment variables
- Deploy to Vercel:
vercel - For production deployment:
vercel --prod
Alternatively, you can connect your GitHub repository to Vercel for automatic deployments.
- Clone the repository
- Install dependencies:
npm install - Create a
.env.localfile with your Supabase credentials:VITE_SUPABASE_URL=your_supabase_url_here VITE_SUPABASE_ANON_KEY=your_supabase_anon_key_here - Run the development server:
npm run dev
This application uses Supabase for persisting data. The stores (students, buses, incidents) are automatically synchronized with your Supabase database when running in a browser environment.