SimplyEmu
PPrisma
•Created by SimplyEmu on 9/25/2024 in #help-and-questions
Question about interactive transactions
I'm reading the docs about interactive transactions and it mentionts to try to not do network requests inside of them. I am trying to create an entry in a playlist table which has a url to a thumbnail. I was going to name the thumbnail using a trigger so the file name can contain playlist Id.
The actual thumbnail image is uploaded to S3 after getting the playlist id to name it. I don't want the entry in the database to be created if the image upload fails. Is there a better way to go about this if interactive transactions doc says this is a bad idea?
4 replies
PPrisma
•Created by SimplyEmu on 5/1/2024 in #help-and-questions
mysql table collation
I have a database with the default collation set to
utf8mb4_0900_as_ci because i need case insensitivity but accent sensitivity. I noticed the default collation set by prisma is utf8mb4_unicode_ci. is it safe for me to manually change to the collation i need without breaking anything in Prisma? Or is there a way to have prisma set a specific collation for new tables?4 replies
PPrisma
•Created by SimplyEmu on 3/27/2024 in #help-and-questions
Deploying to Railway
I am adding prisma orm to my elysia js project. I was wondering if i needed to modify my railway custom start command to run the migration before starting the elysia app, or if railway should defaultly handle this. I tried searching before making a post but couldnt find any info of people adding this to their deployment pipeline. every tutorial had people manually doing the migration
2 replies