Skip to main content

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

TraLaLa DSN

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.
TraLaLa DSN Dashboard
TraLaLa DSN 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.