Skip to content

Instantly share code, notes, and snippets.

@yaya1426
Created April 26, 2026 22:24
Show Gist options
  • Select an option

  • Save yaya1426/f59d7849a302a99fff3424ea4f1f8428 to your computer and use it in GitHub Desktop.

Select an option

Save yaya1426/f59d7849a302a99fff3424ea4f1f8428 to your computer and use it in GitHub Desktop.
Act as a Senior Software Engineer and build a simple Ticket Booking System backend using Express.js and SQLite.
Requirements:
- REST API only, no frontend
- Use SQLite with automatic table creation and seed data
- Support users, events, and bookings
- Let users browse events and book tickets
- Prevent overbooking
- Calculate booking price
- Allow booking cancellation and return seats back to the event
- Keep cancelled bookings in the database
You can choose the database schema, API endpoints, and folder structure, but keep the project clean, simple, maintainable, and beginner-friendly.
Include:
- request validation
- centralized error handling
- proper HTTP status codes
- JSON responses
- README with setup instructions and sample requests
Generate the full working project code.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment