TraLaLa DSN
A web application designed for interactive contests during live TV broadcasts. The application generates unique QR codes tied to specific point values defined by the organizer, featuring a controlled display cadence. Participants scan the codes to claim their points, validating their entries simply using their phone numbers.
- PHP
- MYSQL
- CODEIGNITER 3
- HTMX
- BOOTSTRAP
- JS
- CSS
February 2025
Completed
3 weeks

Key Highlights:
- The codes generated by the application seamlessly integrate into the client's broadcasting render workflow, while final prize drawings are securely handled via a trusted third-party service (randompicker.com).
- The system supports multiple validation criteria for codes (e.g., maximum scan limits, strict time windows). These can be pre-generated for the entire duration of a campaign or generated dynamically on demand.
- The administration panel couples Bootstrap for a clean, intuitive UI with HTMX to deliver real-time data updates directly to the dashboard.

Asymmetric Architecture Optimised for Broadcasting
The ultimate challenge in a live television environment is that traffic spikes instantly when thousands of people scan the screen at the exact same second. To absorb this high-concurrency shock, I completely decoupled the application's logic. The public-facing side utilizes absolutely no JavaScript or CSS libraries, allowing the final landing page to deliver a total payload of just 59.9 kB, with the raw server-rendered HTML document accounting for a mere 1.7 kB
An footprint this small allows the server to process requests and free up memory slots in just a few milliseconds. The result? The project runs comfortably on highly affordable, shared infrastructure (currently hosted in a CHROOT environment on a plan equivalent to a PersonalPro package), effortlessly sustaining 200,000 unique daily visitors with a theoretical peak capacity of 10,000 requests per second.
Why CodeIgniter 3?
CodeIgniter 3 stays incredibly close to native PHP. Without the significant boot-time overhead introduced by modern framework abstractions, it excels at high-performance tasks. Compared to writing pure native PHP, it also provides a much cleaner, more structured, and developer-friendly environment to build upon.
TraLaLa DSN is the perfect example of an engaging project built within a tight timeframe that solves a highly specific business need. Viewers get a seamless, low-friction way to win prizes, while the broadcaster gains a highly reactive administration area and realistic analytics regarding their TV audience.
Thinking about improving your business with a web system?
The consultation is free. Pricing is hourly or per project.
I can help you see if what you're proposing is viable and give you an approximate cost.





