Multifunctional Telegram bot (aiogram 3 + PostgreSQL)

This is my original project that I developed from scratch and currently fully support on the server. The main goal of the bot is to automate processes, gather data, and provide convenient interaction with users.

What the bot can do:

Has a user-friendly navigation system (Inline and Reply keyboards).

Collects and provides information from the database upon user request.

Has a well-thought-out state logic (FSM) that allows guiding the user step-by-step through a funnel or survey.

Technical stack ("under the hood"):

Written in Python using the modern asynchronous framework aiogram 3.x.

Database: PostgreSQL (designed the table architecture, wrote optimized SQL queries).

Fully asynchronous code, so the bot does not hang under heavy loads.

Currently, this bot is used stably by over 240 active users every month. It operates 24/7.

#python #aiogram #telegrambot #postgresql #backend #botdevelopment