MySQL Statement Executed Event?

[languid hill]

is there an event for when a mysql statement is executed? i'm trying to make a /link plugin between my network and its discord

i just need to know when they have done /link sessionid

and linked their uuid

so i can give them their corresponding roles

and set their nickname

[modest star]

you would need something like redis pubSub or use timestamps and constantly check them

[valid garnet]

You might be able to do something with triggers

[languid hill]

im considering iterating every 10s through the list of linked people

and setting nickname and giving roles

but that sounds inefficient

[modest star]

10s is a pretty big delay aswell

[languid hill]

nvm have idea

[zenith token]

Depends on your db. Some DBs have a subscriber model where you can listen to changes in the tables.

[modest star]

for these sort of usecases I always use some sort of messaging system, usually redis, sockets http etc.

most dbs arent made for subscription type services

[north helm]

Depends how you are using sql?

either way as mentioned, use a messaging system, i've heard good things about RabbitMQ

[languid hill]

i fixed it

all good