Telegram Channels Monitor

Telegram monitoring tool for public channels that can be viewed via WEB preview. Extracts data about messages and media files and stores all data in a database. No tokens or bots are required for monitoring. Just launch the app and collect information non-stop in the database.

🌟 Features

1. Parsing recent messages from public Telegram channels
2. Extracting metadata and media attachments
3. Storing data in SQLite database
4. Support for forwarded messages and replies
5. Configurable data collection parameters

🛠 Installation

1. Ensure Python 3.12+ is installed (recommendation)
2. Clone repository

git clone 'https://github.com/aIligat0r/tpm.git'

or

pip install telegram-pm

⚙️ Configuration

Configurations (file .env or telegram_pm/config.py)

Parsing configurations:

• TELEGRAM_PARSE_REPEAT_COUNT - Number of requests (default 5). 20 messages per request. (1 iter - last 20 messages)
• TELEGRAM_SLEEP_TIME_SECONDS - Number of seconds after which the next process of receiving data from channels will begin (default 60 seconds)
• TELEGRAM_SLEEP_AFTER_ERROR_REQUEST - Waiting after a failed requests (default 30)

HTTP configurations:

• HTTP_RETRIES - Number of repeated request attempts (default 3)
• HTTP_BACKOFF - Delay between attempts for failed requests (default 3 seconds)
• HTTP_TIMEOUT - Waiting for a response (default 30 seconds)

🚀 Usage

1. Build application:

Build docker image:

docker build -t tpm .

Create poetry env:

• Install poetry:

pip install poetry

• Create poetry env and install packages:

poetry install

2. Launching the app

Options	Description	Required
--db-path	Path to db file (if sqlite). Else path to dir (if csv)	❌ required
--channels-filepath/--chf	File of channel usernames (file where in each line Telegram username)	❌ required (or usernames --channel/--ch)
--channel/--ch	List of usernames that are passed by the parameter	❌ required (or file of channels --channels-filepath/--chf)
--verbose/--v	Verbose mode	➖
--format/--f	Data saving format (csv, sqlite)	➖
--help/--h	Help information	➖

Poetry:

poetry run tpm --ch freegaza --ch BREAKINGNewsTG --db-path .\tg.db --v

or

poetry run tpm --channels-filepath /path/to/monitoring_usernames.txt --db-path .\tg.db

Docker:

docker run -it --rm tpm --ch freegaza --db-path test_tg.db --v

or (if you want to transfer usernames in a file, then you need to mount the paths)

$ mkdir ~/tpm_data/  # create a folder for data
$ cp /path/to/channel/usernames.txt ~/tpm_data/usernames.txt  #  copy the file with the user names to the previously created folder
$ chmod 666 ~/tpm_data_dir/telegram_messages.sqlite && chmod 666 ~/tpm_data_dir/usernames.txt  # grant access to use this folder from the container

docker run -it --rm \
    -v ~/tpm_data_dir/telegram_messages.sqlite:/data/telegram_messages.sqlite \
    -v ~/tpm_data_dir/usernames.txt:/data/usernames.txt \
    tpm --db-path /data/telegram_messages.sqlite --chf /data/usernames.txt

Python:

from telegram_pm.run import run_tpm


run_tpm(
    db_path="tg.db",                    # Path to db file (if sqlite). Else path to dir (if csv)
    channels=["channel1", "channel2"],  # Channels list
    verbose=True,                       # Verbose mode

    # Configuration (optional)
    format="sqlite",                    # Data saving format (csv, sqlite)
    tg_iteration_in_preview_count=5,    # Number of requests (default 5). 20 messages per request. (1 iter - last 20 messages)
    tg_sleep_time_seconds=60,           # Number of seconds after which the next process of receiving data from channels will begin (default 60 seconds)
    tg_sleep_after_error_request=30,    # Waiting after a failed requests (default 30)
    http_retries=3,                     # Number of repeated request attempts (default 3)
    http_backoff=3,                     # Delay between attempts for failed requests (default 3 seconds)
    http_timeout=60,                    # Waiting for a response (default 30 seconds)
    http_headers={                      # HTTP headers
        "User-Agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36"
    }
)

🗃️ Database Structure

The tables will be named as usernames. Each table is a username that was passed in the running parameters.

Field	Type	Description
id	INTEGER	Channel ID
url	TEXT	Message URL
username	TEXT	Channel username
date	TEXT (ISO 8601)	Message date
text	TEXT	Message text
replied_post_url	TEXT	Replied message URL
urls	JSON	URLs from text
photo_urls	JSON	Photo URLs
video_urls	JSON	Video URLs
created_at	CURRENT_DATETIME (ISO 8601)	Record creation time
url_preview	TEXT	Text from preview URL
round_video_url	TEXT	URL to round video message
files	JSON	List of file names and their description
tags	JSON	List of tags from a message body
forwarded_from_url	TEXT	URL of the channel from which the message was forwarded
forwarded_from_name	TEXT	Name of the channel from which the message was forwarded

⚠️ Limitations

Works only with public channels

🧮 Example of work

Verbose mode:

View database

📜 License

MIT License