Live on your own VPS in minutes

Docker Compose deployment

The repository ships a production Dockerfile and docker-compose.yml for the app plus Redis. One command and you are running.

git clone https://github.com/udai7/hotel_management.git
cd hotel_management
cp .env.example .env
docker compose up --build

Provision & migrate Postgres

Initialize a PostgreSQL database on Supabase and run the SQL migrations in supabase/migrations/ in order.

The core schema 20260227135007_initial_schema.sql creates tables, indexes, RLS policies, triggers, and helper functions such as accept_order_safe for race-free inventory.

Seed and create a superadmin

Run supabase/seed.sql to populate rooms and the starter menu, then seed_bookings.sql for 5,200 mock bookings to exercise the charts and archives. Signups default to the admin role — elevate one to superadmin:

UPDATE public.users
SET role = 'superadmin'
WHERE email = 'you@email.com';

Configure environment variables

Create .env.local in the app root with your Supabase, Redis, and Turnstile keys.

NEXT_PUBLIC_SUPABASE_URL=https://xxx.supabase.co
NEXT_PUBLIC_SUPABASE_ANON_KEY=your-anon-key
SUPABASE_SERVICE_ROLE_KEY=your-service-key
REDIS_URL=redis://127.0.0.1:6379

Build the Next.js server

Compile the optimized production bundle and start it on port 3000.

npm install
npm run build
npm run start

Daemonize with systemd, then Nginx + SSL

Keep Next.js running on boot with a systemd unit, then expose it through Nginx on ports 80/443 secured with Let's Encrypt.

sudo systemctl enable --now hotel
sudo apt install nginx certbot python3-certbot-nginx -y
sudo certbot --nginx -d hotel.yourdomain.com