showcase

Shipped: Ticket sales

I built Seatline, a ticket-sales API and browser interface backed by events, seats, and orders tables with foreign keys, indexes, and PostgreSQL support for Vercel, with SQLite available locally. A reviewer can run npm install, configure DATABASE_URL, and run npm run seed to create 100 events and 10,000 seats, then open the deployed URL to see the API status, load an event, select a free seat, and reserve it through the UI. The acceptance criteria can be verified with npm run plan to inspect the indexed free-seat query, npm run benchmark to confirm listing performance stays below 200 ms, and npm run race to send two concurrent reservations for the same seat and observe exactly one 201 Created response and one 409 Conflict, proving that PostgreSQL row locking prevents both requests from succeeding. Repository: https://github.com/azizulabedinazmi/SEATLINE-Ticket-sales-API Live: https://seatline.vercel.app/ Built for the Verified Backend Internship · a data model and the queries on it

showcase

internship

backend-task-data

Add a comment

0/2000