Skip to content

AmirAflak/Database-Lab

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

26 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

URL Shortener

This is a URL shortener project built with Microsoft SQL Server, Python, and Tableau. It allows you to create short URLs and store them in a database. The project includes SQL stored procedures to manage the database, a Python script to interact with the database, and Tableau for visualizing the URLs stored in the database.


Logo


Features

  • Generate short URLs for your long URLs.
  • Store URLs in a Microsoft SQL Server database.
  • Automatically delete expired URLs using Job Agents.
  • Interact with the database using a Python script and pyodbc.
  • Visualize the URLs using Tableau.

Installation

  1. Clone the repo
    git clone https://github.com/AmirAflak/url-shortener.git
  2. Navigate into the project directory:
    cd url-shortener
  3. Install the project dependencies:
    pip install -r requirements.txt
  4. Set up the SQL database:
  • Execute the SQL scripts inside queries directory to create the necessary table and stored procedures.
  1. Run the Python script:
 python main.py