Purpose:

To maintain anonymity in a telegram group chat.

How to use the bot (in telegram):

Add the bot to the group, make the bot admin, grant all required permissions (read, edit chat/messages). That's it. Now messages are resent by bot deleting original thus partially maintaining anonymity.

NOTE:

DB structure can be optimized.
SQLite is used but you can customize the code to utilize PostgreSQL which is more suitable for real projects.
To send media group (10 images/videos in single message instead of 1 by 1) you need to make a middleware to collect by media_group_id, add the Middleware to the router, handle it in handler. \ Below is basic setup.
Use the project at your own risk as anonymity is double-edged sword.

Aiogram New Template (aiogram 3)

1. Create virtual environment and install packages

Windows

python -m venv venv && venv\bin\activate && pip install -r requirements.txt

Linux/Mac

python3 -m venv venv && source venv/bin/activate && pip3 install -r requirements.txt

2. Create .env file and copy all variables from .env_example to it and customize your self (if needed)

3. Run app.py

Windows

python app.py

Linux/Mac

python3 app.py

Set up Postgresql on server

1. Install postgresql (if needed)

sudo apt install -y postgresql postgresql-contrib

2. Log in to the postgresql shell

sudo -u postres psql

3. Create a database (in postgresql shell)

CREATE DATABASE database_name WITH template = template0 ENCODING 'UTF8' LC_CTYPE 'C' LC_COLLATE 'C';

4. Create a user (in postgresql shell)

CREATE USER user_name WITH PASSWORD 'password';

5. Set encoding (in postgresql shell)

ALTER ROLE user_name SET client_encoding TO 'utf8';

6. Restrict transactions from an unexpected db user (in postgresql shell)

ALTER ROLE user_name SET default_transaction_isolation TO 'read committed';

7. Set timezone (in postgresql shell)

ALTER ROLE user_name SET timezone TO 'UTC';

Note: If you use another timezone in your project, replace 'UTC' with yours.

8. Grant the user the right to manage the db (in postgresql shell)

GRANT ALL PRIVILEGES ON DATABASE database_name TO user_name;

9. Quit postgresql (in postgresql shell)

\q

If you have questions for this project, join and ask our community: https://t.me/+Wu3loL2thM8yZDMy