Skip to main content
Donate to the Python Software Foundation or Purchase a PyCharm License to Benefit the PSF! Donate Now

link-shortening website and database system

Project description

ovipositor

Flask link-shortening service and database system

credits

  • name by Ellis Kay

introduction

Ovipositor is a link-shortener web program. A long URL is entered, together with an optional shortlink and an optional comment. When creating a shortlink, the long URL and the shortlink are saved to a database. When an attempt is made to use a shortlink, the specified shortlink is searched for in the database and, if the shortlink is in the database, there is a redirect to its corresponding long URL.

setup

sudo apt-get install sqlite
sudo pip install ovipositor

usage

Ovipositor can be set running in a simple way:

./ovipositor.py

Ovipositor is under development and can become slow if left running for extended times, so it can make some sense to have it restart regularly:

while true; do
    ./ovipositor.py --restartregularly
done

ovipositor database structure

There is one table in an ovipositor database called “shortlinks”. This table has 6 fields:

table field description
comment shortlink descriptive comment
count shortlink usage count
IP IP address that created the shortlink
URL long URL to which the shortlink corresponds
shortlink shortlink text
timestamp shortlink creation timestamp

examining databases

A database can be examined using datavision view_database_SQLite.py.

changing from YOURLS to ovipositor

An export dump should be made of the YOURLS MySQL database and the dump should be converted to an SQLite3 database. This can be done using mysql2sqlite.

The YOURLS SQLite database then can be converted to an ovipositor database using the script convert_YOURLS_SQLite_database_to_ovipositor_database.py.

convert_YOURLS_SQLite_database_to_ovipositor_database.py --help

convert_YOURLS_SQLite_database_to_ovipositor_database.py \
    --databaseyourls=linkdb.db                           \
    --databaseovipositor=ovipositor.db

The YOURLS database contains three tables, “yourls_url”, “sqlite_sequence” and “yourls_options”. The tables have the following fields:

  • yourls_url
    • clicks
    • ip
    • keyword
    • timestamp
    • title
    • url
  • sqlite_sequence
    • name
    • seq
  • yourls_options
    • option_id
    • option_name
    • option_value

In changing from YOURLS to ovipositor, the following database table and field conversions are made:

yourls_url ovipositor
yourls_url shortlinks
clicks count
ip IP
keyword shortlink
url URL
timestamp (datetime.datetime) timestamp (datetime.datetime)
title comment

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, size & hash SHA256 hash help File type Python version Upload date
ovipositor-2018.1.15.2350.tar.gz (6.2 kB) Copy SHA256 hash SHA256 Source None

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page