telebot async with mysql aync question

[sudousercom]

Hi! Maybe anyone can advise, how can i use mysql async pool with telebot? All modules uses asynс loop, but i tried to use loop with scheduler, and it blocks polling, and bot becomes silent and not react on commands, thanks

[coder2020official]

Scheduler is blocking polling? What scheduler are you using, and how?

[sudousercom]

scheduler is aioscheduler, but without using loop, i take an example from async timer bot, and it works fine now. Before i check examples, i tried use loop = asyncio.get_event_loop() and this code blocks polling, in async mysql examples i see same construction, and now i am here, asking for better solution

[coder2020official]

Never tried to use aioscheduler. I've used apscheduler library and it's AsyncIOScheduler. It worked for me fine

[coder2020official]

In order to stop blocking polling, you need to create tasks

[sudousercom]

Thanks for answers about scheduler, it work s fine, maybe you can advise how to use mysql async?

[coder2020official]

https://pypi.org/project/aiomysql/