Tip

For users who doens't want to start counting at 0, please open a ticket to provide the count and your URL, and I will update it for you as soon as possible :)

Hits Counter

Due to the recent close down of hits.seeyoufarm.com, I decided to recreate the same service.
Thanks @gjbae1212 for the hardworking.

What is this?

This project allows you to create a badge like this:

to record how many visit your site have!

How to use?

Visit Hits Counter to create your badge

Follow the form to input the URL, label, pick an icon and color and click Generate.

You should see the Result section below right away.

Once you're satisfied with the result, simply copy & paste the code below to your website (HTML) or Markdown file. With the URL, you can also get the JSON result of the badge by simply toggling the JSON switch under URL.

Other Features

• Historical data of your URL
  • Predefine with your URL: https://hitscounter.dev/history?url=your_url_here

Self Hosting

This project allows you to self-host. Simply git clone this project, npm install, npm build and use follow instructions from the npm output.

The only manual setup is the database. This project is using Postgresql, and the application is connected to your database through .env file

DATABASE_URL=
DATABASE_USER=
DATABASE_PASSWORD=
DATABASE_PORT=
DATABASE=

Required Datatable

tracking_urls

Schemas

Column Name	Column Types	Default
id	UUID
url	VARCHAR
track_datatime	DATE	NOW()::DATE
total_hits	INTEGER

Required Routine

create function update_hit_count_dynamic(tablename text, customtimezone text) returns integer
    language plpgsql
as
$$
DECLARE
    new_count INTEGER;
    date_today DATE;
    row_exists BOOLEAN;
BEGIN
    EXECUTE format('SELECT (NOW() AT TIME ZONE %L)::DATE', customTimezone)
        INTO date_today;

    -- Check if the row for today exists
    EXECUTE format('SELECT EXISTS (SELECT 1 FROM %I WHERE hit_date = $1)', tablename)
        INTO row_exists
        USING date_today;

    IF NOT row_exists THEN
        -- Insert a new row for today
        EXECUTE format('INSERT INTO %I (hit_date, hit_count) VALUES ($1, 1)', tablename)
            USING date_today;
        new_count := 1;
    ELSE
        -- Update existing row and return the new count
        EXECUTE format('UPDATE %I SET hit_count = hit_count + 1 WHERE hit_date = $1 RETURNING hit_count', tablename)
            INTO new_count
            USING date_today;
    END IF;

    RETURN new_count;
END;
$$;