Skip to content
/ f Public

a simple, self hosted URL Shortener with powerful analytics, running on NodeJS and sqlite3

Notifications You must be signed in to change notification settings

MoPaMo/f

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

f logo

⚡ Powerful Analytics

🎛️ User-friendly modern browser interface

💾 > 20 MB

🌐 Works even on microhosting services!

🏗️ Build with sqlite3 and nodeJS

🏃 Developed with speed in mind

Installing

Default installing

  1. Clone the git repo:
git clone https://github.com/MoPaMo/f.git
  1. Enter the new directory:
cd f
  1. Install the node modules:
npm install
  1. Add a .env and choose a password
echo "pwd=[your password]" > .env
  1. Create the database file in ./db/
sqlite3 db/db.db

Copy and paste these SQL commands

For the lazy: You can also just copy example.db into ./db/ and rename it to db.db

  1. Run it!
npm start # or node index.js

Details

DB structure

SQL Comands:
CREATE TABLE links (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL , token TEXT NOT NULL UNIQUE, url TEXT NOT NULL, created INTEGER);

CREATE TABLE refs (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, link_id INTEGER NOT NULL, lang TEXT, browser_name TEXT, os_name TEXT, versionName TEXT, platType TEXT, referrer TEXT, full_ua TEXT, timeHit INTEGER);
Tables:
Name Type Special
Item One Item Two Item Three

About

a simple, self hosted URL Shortener with powerful analytics, running on NodeJS and sqlite3

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published