showcase

Shipped: Ticket sales

I built a ticket reservation backend using Node.js, Express, and SQLite. Reviewers can verify that all acceptance criteria are met directly in the repository files and README.md: - Database & Seeding: 3 related tables (events, seats, orders) with over 10,000 seeded seat rows are implemented in db.js and seed.js. - Performance (<200ms): Optimized via a compound index (idx_seats_event_status) defined in db.js. - Concurrency Control: Race condition prevention is implemented via atomic updates checking result.changes === 0 to return a 409 Conflict if a seat is already taken (server.js). - Demonstration: Complete concurrency test commands (curl) and expected server responses (Success vs. 409 Conflict) are fully documented in the README.md. Repository: https://github.com/oliviamol/ticketbackend Built for the Verified Backend Internship · a data model and the queries on it

showcase

internship

backend-task-data

Add a comment

0/2000