Database connection does not use SSL

[ytsruh]

Azure MySQL Connect does not use SSL as the certificate couldnt be uploaded to Vercel. There seems to be a solution available here: prisma/prisma#11453

[ytsruh]

Help with using an SSL certificate:
prisma/prisma#11453

https://github.com/mysqljs/mysql#ssl-options

https://davidparks.dev/blog/planetscale-deployment-with-prisma/

Multiline env = motdotla/dotenv#196

Prisma connection string for MySQL - https://www.prisma.io/docs/concepts/database-connectors/mysql

[ytsruh]

Solution is more effort than its worth. An SSL ceriticate would need to be used and there are two options:

1. Deploy the certificate and read it as part of the file system. Would need to add to .gitignore and deploy manually/using cli to push the correct files to vercel. A .vercelignore file would need to be created to make sure that local .env is not pushed to vercel
2. Read the certificate as a string but Prisma doesnt allow for this. Prisma requires a path to the .pem file & cannot currently use a string instead

Prisma connection string for MySQL - https://www.prisma.io/docs/concepts/database-connectors/mysql

[ytsruh]

Closing this as not completed. Raised queries with both the vercel & prisma teams but there is only one workaround that is more effort than it is worth at this point