Reading channels in TG bot and recording in the database
The previous project caused some difficulties in understanding, so I will try to describe it in more detail.
A bot is required that will collect existing messages in the Telegram groups/channels that I am subscribed to. The channels can be both public and private, and they can be chats or groups. These messages should be saved in a database. The solution should be accessible to other users. Naturally, security is important.
Explanations:
- BOT - a software solution that will perform the necessary actions.
- Group - here I often write groups, but these can also be channels and chats. Importantly, these can be private groups, but most often they are regular public channels.
- DB - it doesn't really matter which one, but it must be an SQL database. I think PostgreSQL or MySQL would be best, but it's not critical.
- Messages are usually text, sometimes photos. Video and audio do not need to be collected. We parse those messages that appeared since the last parsing by the bot.
- The solution should be accessible to other users - this means that a user can connect very easily, like subscribing to a group, or for example filling out an application form. But it is completely unsuitable for it to work only by installing some software on a server or computer.
- Security - the user does not worry that the bot will have the ability to read their messages; the bot can only see which groups the user is subscribed to and be able to parse them.
Now, this is roughly how I see it
There are three people, each of whom is subscribed to 20 different groups. Person 1 (P1) chooses to parse channels from the first to the eighth, once a day. P2 chooses to parse 5 groups every hour. P3 chooses to parse all groups once a day.
As a result, we have 3 tables in the database, and each table contains saved messages from the groups selected by that user. Here is a caveat: I wrote that 3 tables are created; perhaps for speed or convenience, it will be one table with selection by ID. What to save in the database besides text and photos I have not thought through yet, but I consider this not the most important question at the moment.
Next, there is a task to make it so that the user can receive summarized information about the groups they have selected. But that is already the second stage.
ATTENTION!!! I am looking for someone who can implement this, not to hear that I haven't thought something through. I am sure many questions will arise, but everything can be discussed and a solution found. At the same time, if there is CONSTRUCTIVE criticism or questions, please write, I am ready to listen and respond if necessary.
-
1294 25 1 Good day, there is an almost ready solution. The script is written in Python. The script monitors the groups/chats you have selected.
-
238 1 0 Good afternoon.
Middle Node.js developer with 4+ years of commercial experience.
Stack: Node.js, TS, Express, Sequelize, MongoDB, Telegram API, Telegraf.
I have a similar project that parses closed and open channels and groups.
(I haven't tested it on chats as there was no task).
This software can be tailored to your specific task.
-
3853 24 0 Good day,
I am ready to take on your project. I can develop a bot to collect messages from Telegram groups/channels into your database. The solution will ensure security and accessibility for other users. Parsing only text messages and photos with subsequent saving. I am ready to discuss all the details and configure the bot's operation according to your requirements.
My rate is $16 per hour.
Sincerely,
Maxim
-
449 3 1 1 I am interested in implementing this project and have the necessary skills to complete it. I have experience in developing Telegram bots, working with APIs (Telegram Bot API and MTProto), as well as creating reliable systems based on PostgreSQL/MySQL.
Why I can be useful:
Telegram bot development: I will implement a bot that will collect messages from open and closed groups/channels, taking into account all your requirements.
Data storage: I will organize the SQL database structure for fast and secure message storage.
Parsing setup: I will implement the ability to select groups, data collection frequency, and other user settings.
Security: I will pay special attention to protecting user data and ensure that the bot only has access to permitted information.
Accessibility: The solution will be convenient for use by other users without complex settings.
Work plan:
… Discussion of all details and nuances of the project.
Implementation of the bot with basic functionality.
Database setup and parsing logic.
Testing and making necessary adjustments.
Completion of the project with full technical support.
I am ready to discuss the project and start working! I look forward to your response.
-
1341 23 0 Good afternoon! I already have experience working with the Telegram API, so I will ensure quality execution of the task. Let's get in touch and discuss all the details.
-
1993 12 0 Good day
I can definitely implement that, I have done it multiple times
Write to me
-
417 9 0 Hello, I am ready to take on the development of this bot. I have experience working with the Telegram API and Postgres. A clear technical specification with key points is available. I look forward to collaborating.
-
573 9 0 I have worked a lot with Telegram, writing bots. Feel free to contact me, I will do it in NodeJs.
The technical specifications are quite clear, except for how the bot will receive the channels: Either connect the bots to user accounts, which is not really good, or create a separate bot and users will send the necessary channels to it?
-
Реалізуємо, але ризиковано, завжди є ризик втратити акаунт через блокування його телеграмом.
-
Решение должно быть доступно для других пользователей - это значит что пользователь может подключится очень легко, как подписать на группу, или например заполнить форму заявки. Но совершенно не подходит что бы это работало только к примеру установив некое ПО на сервер ли компьтютер.
це ж нереально ) -
Current freelance projects in the category Bot Development
Telegram bot
53 USD
I need code for a Telegram bot that will take messages from one channel, modify them to fit my design, and post them in two other channels. In one channel, from 1 to 6 posts, and in the other channel, all posts. Bot Development ∙ 1 hour 13 minutes back ∙ 30 proposals |
Tik Tok Live node.je
16 USD
It is necessary to write a mini program based on the TT-live-connector library, so that when launched, it reads the Gifts being sent and displays a smooth and beautiful animation through a regular web page. 3D Modeling, Bot Development ∙ 1 hour 50 minutes back ∙ 13 proposals |
I am looking for a strong specialist in trading bots and agents.
250 USD
It is important to start - TODAY I need a person who has experience in writing trading bots on DEXs (needed on the BSC network) with an understanding of transaction costs, gas, etc. I want to test several trading strategies on a real trading agent I need to quickly… Cryptocurrency & Blockchain, Bot Development ∙ 22 hours 1 minute back ∙ 24 proposals |
Creation of a TikTok farm with income generation
601 USD
Looking for a person who can write software for a TikTok farm, so we can generate traffic and earn income. We are seeking a ready-made solution with a full cycle. Python, Bot Development ∙ 2 days back ∙ 16 proposals |
Pocket Option trading bot
71 USD
I need a bot and your expertise who has already been able to create a similar bot when the bets are correct, they are read from Pocket Option I am interested in Brent Oil I do not need a beginner or someone who will just write code for the sake of it I need someone who knows… AI & Machine Learning, Bot Development ∙ 3 days back ∙ 19 proposals |