Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

MySQL: Scheduled Events #8879

Open
Tracked by #16311
miramallows opened this issue Aug 24, 2021 · 3 comments
Open
Tracked by #16311

MySQL: Scheduled Events #8879

miramallows opened this issue Aug 24, 2021 · 3 comments
Labels
domain/client Issue in the "Client" domain: Prisma Client, Prisma Studio etc. kind/feature A request for a new feature. topic: database-functionality topic: mysql

Comments

@miramallows
Copy link

Problem

I'm currently swapping from raw mysql to prisma, but use mysql for scheduled events for data reset purposes on expiry.
I'm more than happy with working with raw database access / raw queries for this -- I'm only here because that page told me to consider raising an issue here for whatever reason. Please decline if you feel this is useless, sorry for wasting your time! Also I couldn't find the same issue in here, sorry!

Suggested solution

The ability to be able to create MySQL events / SQL events within the prisma client.

Alternatives

Using raw queries

Additional context

@janpio janpio added kind/feature A request for a new feature. topic: default topic: mysql labels Aug 24, 2021
@janpio
Copy link
Contributor

janpio commented Aug 24, 2021

Can you maybe provide a few links for context on the MySQL feature?

@miramallows
Copy link
Author

Hi! Of course, here you go. Sorry I didn't include it in the first place:
https://dev.mysql.com/doc/refman/8.0/en/events-overview.html

@pantharshit00 pantharshit00 added the domain/client Issue in the "Client" domain: Prisma Client, Prisma Studio etc. label Sep 13, 2021
@paulwer
Copy link

paulwer commented Feb 4, 2024

Are there any plans for such feature?

Edit: Some of other databases supported by prisma have any kind of those features:
https://www.mongodb.com/docs/atlas/app-services/triggers/scheduled-triggers/
https://github.com/citusdata/pg_cron

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
domain/client Issue in the "Client" domain: Prisma Client, Prisma Studio etc. kind/feature A request for a new feature. topic: database-functionality topic: mysql
Projects
None yet
Development

No branches or pull requests

4 participants