{"repo":"J4NN0/j4nn0-b0t","free":true,"listed":false,"github":"https://github.com/J4NN0/j4nn0-b0t","clone":"git clone https://github.com/J4NN0/j4nn0-b0t.git","description":"Python Telegram BOT ables to store and retrive data from database (create, delete and read items from your personal list) and set alarms","language":"Python","stars":29,"topics":["python-bot","telegram","telegram-bot","telegram-bot-api","telegram-api","heroku","herokuapp","heroku-deployment","heroku-apps","python-script"],"license":"GPL-3.0","category":"chat-messaging","readme_excerpt":"J4NN0 B0T The Bot is hosted on Heroku and has been tested with Python v3.9.7 . J4NN0 BOT main features: 1. Store, delete, and view items on your private list using simple chat commands. 2. Set a timed reminder — the bot will notify you with your custom message when the time is up. Check it out on telegram: @J4NN0 Bot Demo Table of Contents - Database - Bot usage - How to host BOT on Heroku - Resources Database The bot uses a simple SQLite database consisting of a single table: REMINDERS Table Structure: - CHATID : Unique chat ID associated with the user. - USRNAME : Telegram username of the user. - ITEM : The item the user has added to their personal list. Whenever a user adds or removes items from their list, the changes are immediately reflected in the database (insertions or deletions from the REMINDERS table). To inspect or manage the database, you can use DB Browser for SQLite to easily manage CRUD operations in SQLite databases via a graphical interface. Note A local .sqlite database isn’t ideal for a finalized product. That said, SQLite was intentionally chosen for this side project to keep the setup simple and lightweight. It requires no external services, making it easy for anyone to run the bot locally or on platforms like Heroku without extra configuration. Bot usage - ⭕ Developer - /about : to see info about developer - 📝 List - /addtolist : to add one or several items to your personal list. - /rmfromlist : to remove one or several items from your personal list. ","default_branch":null,"files":null,"tree":[],"storefront":"/r/J4NN0","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/J4NN0/j4nn0-b0t/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}