This Telegram bot can help you organise subscription, for example, if you have a news web site. This Telegram bot can be used either in private chats or in groups. In groups only admins or creators can set up subscriptions.
The main purpose of this Telegram bot is that now you can deliver your content emediately after publication to interested subscribers.
The bot uses MySQL db to store Telegram users and groups ids. Also news categories are stored there as well. It's been written on Python with python-telegram-bot library.