Uploaded August 2026 | Updated November 2026, 2 hours ago
If you want to join Dr. Chuck's new online offering visit django.dr-chuck.com
Registration will be open August-October 2026.
In this video, I use Cursor AI to add a lightweight UTM tracking system to django.dr-chuck.com
The goal is simple: determine whether visitors arrived through a QR code, LinkedIn post, YouTube video, or another campaign—without installing a full analytics platform or setting up a database server.
We build the tracker using PHP and a small local SQLite database. It records each UTM code, the number of visits, and the first and most recent usage dates. We also add a 250-code limit so that the database cannot grow indefinitely, plus optional password protection for the results page.
Along the way, I test the system locally, deploy it to production, inspect the generated code, and explain why SQLite is such a useful piece of technology for small, fast, self-contained applications.
You can explore my experimental Campus Aligned Open Course (CLOC) in Django at:
django.dr-chuck.com
Try adding your own tracking value to the URL:
django.dr-chuck.com/?utm=42
The course runs alongside my University of Michigan on-campus web development course and gives online students access to the course schedule, Canvas materials, teaching assistants, and office hours.
This is another experiment in my long-running effort to use the Internet, open source software, and open educational resources to improve teaching.
Like, subscribe, and follow along as I continue building the course and sharing the process.
If you want to join Dr. Chuck's new online offering visit django.dr-chuck.com
Registration will be open August-October 2026.
In this video, I use Cursor AI to add a lightweight UTM tracking system to django.dr-chuck.com
The goal is simple: determine whether visitors arrived through a QR code, LinkedIn post, YouTube video, or another campaign—without installing a full analytics platform or setting up a database server.
We build the tracker using PHP and a small local SQLite database. It records each UTM code, the number of visits, and the first and most recent usage dates. We also add a 250-code limit so that the database cannot grow indefinitely, plus optional password protection for the results page.
Along the way, I test the system locally, deploy it to production, inspect the generated code, and explain why SQLite is such a useful piece of technology for small, fast, self-contained applications.
You can explore my experimental Campus Aligned Open Course (CLOC) in Django at:
django.dr-chuck.com
Try adding your own tracking value to the URL:
django.dr-chuck.com/?utm=42
The course runs alongside my University of Michigan on-campus web development course and gives online students access to the course schedule, Canvas materials, teaching assistants, and office hours.
This is another experiment in my long-running effort to use the Internet, open source software, and open educational resources to improve teaching.
Like, subscribe, and follow along as I continue building the course and sharing the process.










