From the course: Using SQL with Python
Join today to access over 23,300 courses taught by industry experts.
Defining the project
From the course: Using SQL with Python
Defining the project
- [Instructor] Our final project is a simple, short URL service for personal or private use. I wanted a short URL service, but I didn't want to use one of the public services. I didn't like their privacy policies. I didn't want to leave my traffic in the control of an unknown entity. And frankly, it just seemed like a fun little project. I've been using this code for about 10 years now, and it's worked well for me. The code revolves around a simple one-table database that has rows for the short name and the destination URL. I call the app JURL for jump URL. So I named the table JURL. It's really just a name, no reason to overthink it. It would be easy to add support for click counts, referral URLs, and other statistical information. But for my purposes, this simple schema has served me well for many years. There are two significant components to the system, a simple CRUD application for managing the database and a jump…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.