creating mysql db for nextjs app with prisma | Railway | Page 1

slim bridgeBOT Mar 16, 2024, 1:12 AM

#

Project ID: N/A

woven blaze Mar 16, 2024, 1:17 AM

#

huh

marsh pollen Mar 16, 2024, 1:17 AM

#

Hey Brody, I was able to create the database after all. and tried to delete this post.

woven blaze Mar 16, 2024, 1:18 AM

#

oh well glad you where able to figure that out, feel free to open a new help thread for any future questions

marsh pollen Mar 16, 2024, 1:19 AM

#

while I have you here, can I use the MYSQL_PRIVATE_URL as DATABASE_URL in my nextjs app and push my prisma schema into the empty db?

woven blaze Mar 16, 2024, 1:20 AM

#

yes as long as you run the needed command in the context of your railway deployment, as the private url would not be accessible publicly

#

having your app use the private url would also eliminate any database <--> service egress fees!

marsh pollen Mar 16, 2024, 1:22 AM

#

Did I hear less fees? I like the sound of that! But where would you point a person in my position, prisma schema and nextjs app are ready, I have an empty mysql db on railway, what should i do at this point?

#

any docs on that?

#

but I also want people to access the database publicly , so that private url is not usable

woven blaze Mar 16, 2024, 1:24 AM

#

the only docs for that would be the prisma docs, as theres nothing too fancy going on with railways mysql database, essentially you would use it the same way you are using planetscale's database

#

you may want to access to database publicly, and you can, but when you deploy your app to railway you should have your app use the private url

marsh pollen Mar 16, 2024, 1:28 AM

#

my app is on vercel. Can I use your database only, or am I doing it wrong?

woven blaze Mar 16, 2024, 1:29 AM

#

yes you can still use the database, but if your app is hosted outside of railway it would not be possible to use the private url, you would need to use the public url and would be subjecting yourself to egress fees on the database service

#

what environment variable(s) does your app use to connect to the database?

marsh pollen Mar 16, 2024, 1:30 AM

#

just a database_url for planetscale

#

egress fees are a big deal? sounds like I should stay with planetscale

woven blaze Mar 16, 2024, 1:32 AM

#

just 10¢ per GB, isn't planetscale shutting down their free or hobby plan?

marsh pollen Mar 16, 2024, 1:33 AM

#

yes..that's why I'm moving away

woven blaze Mar 16, 2024, 1:33 AM

#

and if anything you should bring your app on vercel over to railway!!

marsh pollen Mar 16, 2024, 1:33 AM

#

nextjs apps run okay on railway?

woven blaze Mar 16, 2024, 1:34 AM

#

they run great, they probably make for the biggest portion of languages deployed to railway

marsh pollen Mar 16, 2024, 1:35 AM

#

It would be helpful if you put out a guide on how to do the vercel+planetscale transfer to railway. Many people like me looking for a new home

woven blaze Mar 16, 2024, 1:35 AM

#

you have a good point

#

in the mean time, I can always help you step by step

marsh pollen Mar 16, 2024, 1:37 AM

#

Can you give me a checklist of what to do? Since I have a built app already, the template app you have is confusing. I have my project on github and push it to vercel

woven blaze Mar 16, 2024, 1:39 AM

#

it's quite simple, with railway, you have your app on github (check) and push to github (check) then railway does the deploying, you'd just have to do the initial setup with railway, and once done you will be amazed on how easy it is

#

wanna begin?

marsh pollen Mar 16, 2024, 1:40 AM

#

sure

woven blaze Mar 16, 2024, 1:40 AM

#

can you send a screenshot of your current railway project, the one with the database

marsh pollen Mar 16, 2024, 1:42 AM

#

oh, I only created a database there. Shouldn't I create sth else?

woven blaze Mar 16, 2024, 1:44 AM

#

see, you know what's up. I just needed to see where we were at.

go ahead and add a new empty service from that + New button

marsh pollen Mar 16, 2024, 1:45 AM

#

done! salute

woven blaze Mar 16, 2024, 1:46 AM

#

open it up and add all your needed environment variables into it's service variables

marsh pollen Mar 16, 2024, 1:47 AM

#

that'll take some time. I don't want to keep you waiting. What should i do after adding the env vars?

woven blaze Mar 16, 2024, 1:48 AM

#

I'm kinda making it up as I go along from experience

#

may I ask why it would take a long time? lots of variables?

marsh pollen Mar 16, 2024, 1:49 AM

#

no, I guess I can do it in a min or two

woven blaze Mar 16, 2024, 1:51 AM

#

what did you say your app's stack was? next?

marsh pollen Mar 16, 2024, 1:53 AM

#

nextjs react (prisma trpc Clerk planetscale)

#

I added most of my env vars

woven blaze Mar 16, 2024, 1:54 AM

#

do you have the database url variable added?

marsh pollen Mar 16, 2024, 1:54 AM

#

you said it's private. so should I?

#

The database should be accessible to the public via the app

#

I can add the planetscale one for now

woven blaze Mar 16, 2024, 1:55 AM

#

for right now we would want to use the public database url for mysql on railway

marsh pollen Mar 16, 2024, 1:55 AM

#

oh MYSQL_URL then.

#

but the app will throw an error not finding the tables in it

woven blaze Mar 16, 2024, 1:57 AM

#

the variable would be DATABASE_URL=${{MySQL.MYSQL_URL}} assuming the variable you use in code is DATABASE_URL

woven blaze Mar 16, 2024, 1:57 AM

#

marsh pollen but the app will throw an error not finding the tables in it

thats okay, we arent going to deploy the app just yet, we need to run the migrations and the seed you mentioned first

marsh pollen Mar 16, 2024, 1:58 AM

#

When I switched to get the db url, all the env vars in the service are gone. there was no save button.

#

have to put them back in

woven blaze Mar 16, 2024, 1:59 AM

#

where you using the raw editor?

marsh pollen Mar 16, 2024, 1:59 AM

#

yeah, I know what happened now.

#

ok. all good now

woven blaze Mar 16, 2024, 2:00 AM

#

didnt click the update variables button?

marsh pollen Mar 16, 2024, 2:00 AM

#

yes, never mind. I thought that form was just for entry, but the editor data is supposed to persist and I deleted them when adding the db url

woven blaze Mar 16, 2024, 2:01 AM

#

ah gotcha

woven blaze Mar 16, 2024, 2:01 AM

#

woven blaze the variable would be `DATABASE_URL=${{MySQL.MYSQL_URL}}` assuming the variable ...

did you use the variable syntax i gave you?

marsh pollen Mar 16, 2024, 2:02 AM

#

like this:?
MYSQL_URL=blahblah
DATABASE_URL=${{MySQL.MYSQL_URL}}

#

or just the second line

woven blaze Mar 16, 2024, 2:03 AM

#

just the second line, i would guess you arent using MYSQL_URL in your app, so you wouldnt need it in the service variables

marsh pollen Mar 16, 2024, 2:04 AM

#

ok. done.

woven blaze Mar 16, 2024, 2:04 AM

#

deploy the changes

#

then go back into the service and give it a nice name, and generate yourself a domain

marsh pollen Mar 16, 2024, 2:06 AM

#

name done, but generate a domain how

woven blaze Mar 16, 2024, 2:06 AM

#

from its settings page

marsh pollen Mar 16, 2024, 2:07 AM

#

ah done

woven blaze Mar 16, 2024, 2:07 AM

#

can i see another screenshot of the project?

marsh pollen Mar 16, 2024, 2:07 AM

#

with the railway.internal

woven blaze Mar 16, 2024, 2:07 AM

#

that is not applicable for a next app in this context

#

quick question, how much data would you say you have in your ps database?

marsh pollen Mar 16, 2024, 2:10 AM

#

it's basically empty except for a table with 4300 rows and 5 cols that I created using a seed

woven blaze Mar 16, 2024, 2:10 AM

#

haha im not sure if i would call that empty

#

what command did you run to create the tables and add the seed data?

marsh pollen Mar 16, 2024, 2:11 AM

#

as soon as I set it up prisma should be able to see it

#

seed it

#

in my schema.prisma I have:
datasource db {
provider = "mysql"
url = env("DATABASE_URL")
relationMode = "prisma"
}

generator client {
provider = "prisma-client-js"
seed = "ts-node prisma/seed.ts"

}

#

and that seed.ts is executed to seed the db

woven blaze Mar 16, 2024, 2:12 AM

#

right but you would need to run a command to migrate (make the tables) and seed the database, its unfortunately not gonna happen magically

marsh pollen Mar 16, 2024, 2:14 AM

#

yes, as i showed above it's a seed script that is run by prisma that gets the data from a .csv file

woven blaze Mar 16, 2024, 2:14 AM

#

but what command do you run to start the migration and seed?

#

like npx prisma migrate deploy for example

marsh pollen Mar 16, 2024, 2:15 AM

#

oh, that!

#

let me see...

#

npx prisma db seed

woven blaze Mar 16, 2024, 2:16 AM

#

okay cool, thats what i was looking for

#

can you go ahead and install the railway cli please https://docs.railway.app/guides/cli#installing-the-cli

marsh pollen Mar 16, 2024, 2:17 AM

#

done.

woven blaze Mar 16, 2024, 2:17 AM

#

then make sure you are on the latest with railway --version latest being 3.5.2 iirc

marsh pollen Mar 16, 2024, 2:18 AM

#

it is 3.5.2

#

no iirc

woven blaze Mar 16, 2024, 2:18 AM

#

perfect

marsh pollen Mar 16, 2024, 2:18 AM

#

don't know what iirc means

woven blaze Mar 16, 2024, 2:18 AM

#

if i remember correctly

marsh pollen Mar 16, 2024, 2:19 AM

#

pardon my ignorance!

woven blaze Mar 16, 2024, 2:19 AM

#

no worries at all

#

you have a local .env file right?

marsh pollen Mar 16, 2024, 2:20 AM

#

yes

woven blaze Mar 16, 2024, 2:21 AM

#

for now, can you remove the DATABASE_URL line from it

marsh pollen Mar 16, 2024, 2:21 AM

#

done

woven blaze Mar 16, 2024, 2:21 AM

#

we will have the railway cli inject the new database url when we run migrations and seeds

#

we also dont want to really be storing database credentials in a plaintext file

#

run railway login if you havent already

#

and then run railway link in a terminal open inside of your apps project folder, follow the steps to link to your cooli service

marsh pollen Mar 16, 2024, 2:27 AM

#

ok

woven blaze Mar 16, 2024, 2:27 AM

#

let me know when thats done!

marsh pollen Mar 16, 2024, 2:30 AM

#

sorry, on it.

#

got an error. have to do it with --browserless

#

is that ok?

woven blaze Mar 16, 2024, 2:32 AM

#

yeah, but what error did you get?

marsh pollen Mar 16, 2024, 2:33 AM

#

never mind. I should select my service as the service right? not the database..

#

for linking

woven blaze Mar 16, 2024, 2:34 AM

#

correct

marsh pollen Mar 16, 2024, 2:34 AM

#

ok. seems like linking was done

woven blaze Mar 16, 2024, 2:34 AM

#

are you in your apps project folder? the same folder you are pushing to github

marsh pollen Mar 16, 2024, 2:35 AM

#

yes

woven blaze Mar 16, 2024, 2:36 AM

#

and what command did you say you use to run migrations?

marsh pollen Mar 16, 2024, 2:37 AM

#

my vercel app is connected to github, so to update the website, I just push to github. I don't do any migrations. sorry if I'm misunderstanding. I'm in business not web dev.

woven blaze Mar 16, 2024, 2:38 AM

#

im talking in the context of database migrations

marsh pollen Mar 16, 2024, 2:38 AM

#

npx prisma db push

woven blaze Mar 16, 2024, 2:38 AM

#

woven blaze like `npx prisma migrate deploy` for example

is this the correct command?

marsh pollen Mar 16, 2024, 2:38 AM

#

with db push, I let prisam use the schema to create the db

woven blaze Mar 16, 2024, 2:38 AM

#

marsh pollen npx prisma db push

then you would want to run railway run npx prisma db push

marsh pollen Mar 16, 2024, 2:39 AM

#

done

woven blaze Mar 16, 2024, 2:39 AM

#

did the command go well?

marsh pollen Mar 16, 2024, 2:40 AM

#

yes

woven blaze Mar 16, 2024, 2:40 AM

#

and now run your seed command through railway run in the same way

marsh pollen Mar 16, 2024, 2:41 AM

#

it's running

woven blaze Mar 16, 2024, 2:42 AM

#

do you own a custom domain thats in use with vercel?

marsh pollen Mar 16, 2024, 2:42 AM

#

yes

woven blaze Mar 16, 2024, 2:42 AM

#

who is the domain with?

marsh pollen Mar 16, 2024, 2:42 AM

#

it's with Google domains. I need your DNS values I guess

woven blaze Mar 16, 2024, 2:43 AM

#

you would need to use cloudflare's nameservers first

marsh pollen Mar 16, 2024, 2:43 AM

#

should i create a cloudflare account?

woven blaze Mar 16, 2024, 2:44 AM

#

yes please, but we can hold off on that if you want, because you can test your app with the railway public domain for now

marsh pollen Mar 16, 2024, 2:44 AM

#

yes, I'll hold off on that. make sure things run smoothly first

#

but why cloudflare. They have to be my cdn?

woven blaze Mar 16, 2024, 2:45 AM

#

because they support root level cnames, google domains does not

marsh pollen Mar 16, 2024, 2:45 AM

#

Are you saying I'll need to transfer my domains too?

#

from Google to Cloudflare

#

?

woven blaze Mar 16, 2024, 2:46 AM

#

nope, the domain can stay on google domains, you would only need to use cloudflare's nameservers

#

theres a guide for that made by cloudflare

marsh pollen Mar 16, 2024, 2:47 AM

#

I've used them as a CDN before.

woven blaze Mar 16, 2024, 2:47 AM

#

then you already have an account right? so thats good!

marsh pollen Mar 16, 2024, 2:48 AM

#

I see my tables replicated on your end

woven blaze Mar 16, 2024, 2:48 AM

#

sweet

marsh pollen Mar 16, 2024, 2:48 AM

#

the seeding is still going on.

#

I need to connect my github project to railway somehow, right?

#

it was connected to vercel before

woven blaze Mar 16, 2024, 2:48 AM

#

yeah but first, does the service have a domain?

marsh pollen Mar 16, 2024, 2:50 AM

#

I have added my domain names to vercel if that's what you mean. not sure what you mena

#

mean

woven blaze Mar 16, 2024, 2:50 AM

#

right now im talking in the context of your railway service

marsh pollen Mar 16, 2024, 2:50 AM

#

I haven't adde a domain on railway yet

woven blaze Mar 16, 2024, 2:50 AM

#

do you have railway public domain added to the service?

#

if not, go ahead and generate one, from its settings page

marsh pollen Mar 16, 2024, 2:52 AM

#

generated. shows 'nothing here yet' when I navigate to it

woven blaze Mar 16, 2024, 2:52 AM

#

thats normal, there isnt anything there yet

marsh pollen Mar 16, 2024, 2:52 AM

#

Will i need the private networking or should i disable it

woven blaze Mar 16, 2024, 2:53 AM

#

you dont need to touch that

#

does the service have all the needed variables for your app?

marsh pollen Mar 16, 2024, 2:53 AM

#

I believe so./

woven blaze Mar 16, 2024, 2:54 AM

#

i guess we will soon find out eh?

marsh pollen Mar 16, 2024, 2:54 AM

#

moment of truth

woven blaze Mar 16, 2024, 2:54 AM

#

do you have the correct github linked to your railway account?

marsh pollen Mar 16, 2024, 2:54 AM

#

I don't think so, railway has access to my github but I have not linked the proejct to it yet

woven blaze Mar 16, 2024, 2:55 AM

#

go into the service settings and connect your repo

marsh pollen Mar 16, 2024, 2:56 AM

#

connected

woven blaze Mar 16, 2024, 2:56 AM

#

and it will now deploy

marsh pollen Mar 16, 2024, 2:57 AM

#

I hope so, but the public url doesn't show anything yet: https://cooli-production.up.railway.app/

woven blaze Mar 16, 2024, 2:57 AM

#

thats normal, nothing is there yet

marsh pollen Mar 16, 2024, 2:58 AM

#

that's the last bit, I guess. What should i do?

woven blaze Mar 16, 2024, 2:58 AM

#

wait until the deploy finishes

#

go check the status

marsh pollen Mar 16, 2024, 2:58 AM

#

and the seed is still ongoing. taking longer than I thought

woven blaze Mar 16, 2024, 2:58 AM

#

as long as the tables are there lol

marsh pollen Mar 16, 2024, 2:58 AM

#

It says my project has no deploys. Should I manually do it?

woven blaze Mar 16, 2024, 2:59 AM

#

have you connected your github repo to the service?

marsh pollen Mar 16, 2024, 2:59 AM

#

yes. should i do a git push to initiate it?

woven blaze Mar 16, 2024, 2:59 AM

#

is your stuff still blue?

#

if so, you would need to click the deploy button after you make any changes

marsh pollen Mar 16, 2024, 3:01 AM

#

just did it. it's building now.

woven blaze Mar 16, 2024, 3:01 AM

#

awsome

marsh pollen Mar 16, 2024, 3:02 AM

#

deployment failed. could it be due to the seeding being underway?

#

RROR: failed to solve: process "/bin/bash -ol pipefail -c npm ci" did not complete successfully: exit code: 1

Error: Docker build failed

woven blaze Mar 16, 2024, 3:02 AM

#

please send your full build logs using this https://bookmarklets.up.railway.app/log-downloader/

marsh pollen Mar 16, 2024, 3:03 AM

#

how? copy the contents of that page and paste here?

woven blaze Mar 16, 2024, 3:04 AM

#

woven blaze please send your full build logs using this <https://bookmarklets.up.railway.app...

follow the 3 steps listed here

#

your lock file is out of sync, i guess vercel doesnt care about that or is fixing it for you.

to fix it properly run npm i --package-lock-only and then push your changes, once you push your changes railway will auto deploy the new code for you

marsh pollen Mar 16, 2024, 3:08 AM

#

I think I'd better disconnect from vercel too at this point

woven blaze Mar 16, 2024, 3:08 AM

#

good idea!!

marsh pollen Mar 16, 2024, 3:09 AM

#

seeding done

woven blaze Mar 16, 2024, 3:10 AM

#

awsome

marsh pollen Mar 16, 2024, 3:12 AM

#

new git push triggered deployment. but that package lock line generated this:

#

railway is serverfull right?

woven blaze Mar 16, 2024, 3:14 AM

#

if serverfull is the opposite of serverless, yes

#

did you push your changes to github?

marsh pollen Mar 16, 2024, 3:15 AM

#

yes, the new deployment failed

woven blaze Mar 16, 2024, 3:15 AM

#

new logs please

#

your lock file is still out of sync

marsh pollen Mar 16, 2024, 3:20 AM

#

you mean the package-lock.json file?

#

and out of sync with what?

woven blaze Mar 16, 2024, 3:22 AM

#

with your package.json

woven blaze Mar 16, 2024, 3:22 AM

#

woven blaze your lock file is out of sync, i guess vercel doesnt care about that or is fixin...

^

marsh pollen Mar 16, 2024, 3:23 AM

#

would it be recreated if i delete the package-lock.json?

#

and run that npm i --package-lock-only

#

?

#

it's not registering any changes. git status shows an up to date branch after I run the above command.

woven blaze Mar 16, 2024, 3:26 AM

#

are you pushing to the correct branch?

marsh pollen Mar 16, 2024, 3:26 AM

#

it's always main. yes

#

just pushed again

woven blaze Mar 16, 2024, 3:27 AM

#

delete your lock file and run that command I gave you again

marsh pollen Mar 16, 2024, 3:28 AM

#

that regenerated a fresh file finally. pushing now.

#

failed again. log attached.

woven blaze Mar 16, 2024, 3:30 AM

#

somehow you arent syncing your lock file

marsh pollen Mar 16, 2024, 3:31 AM

#

what if i delete my node_modules folder and do an npm install?

woven blaze Mar 16, 2024, 3:31 AM

#

instead lets just tell railway to not care about that.
add this nixpacks.toml file to your project.

[phases.install]
  cmds = ['npm install']

marsh pollen Mar 16, 2024, 3:32 AM

#

so I create a file named nixpacks.toml and add this to it in my root directory?

woven blaze Mar 16, 2024, 3:32 AM

#

yes

marsh pollen Mar 16, 2024, 3:33 AM

#

new deploy building

#

no failure 3 min in. still deploying

woven blaze Mar 16, 2024, 3:36 AM

#

good sign

marsh pollen Mar 16, 2024, 3:37 AM

#

yeah. no error. deployed.

#

database working

#

I guess all is set ! wow! I can't believe it!

#

I can't thank you enough

woven blaze Mar 16, 2024, 3:42 AM

#

one last step

#

now that you have ran migrations and done the seeding, we want to switch your app over to use the private url for the database

#

your DATABASE_URL service variable should now be ${{MySQL.MYSQL_PRIVATE_URL}}

marsh pollen Mar 16, 2024, 3:43 AM

#

oh, ok

woven blaze Mar 16, 2024, 3:44 AM

#

one you change that, click deploy and let ne know if anything fails

marsh pollen Mar 16, 2024, 3:45 AM

#

You mentioned sth about not keeping the .env values in a text file. What's the alternative? I have added it to my gitignore though.

#

and the new deploy failed:

woven blaze Mar 16, 2024, 3:48 AM

#

okay i think i know what to do for this error

woven blaze Mar 16, 2024, 3:48 AM

#

marsh pollen You mentioned sth about not keeping the .env values in a text file. What's the a...

we will come back to this question

#

add a new service variable DATABASE_URL_DIRECT=${{MySQL.MYSQL_URL}} but this time hold your alt key while clicking the deploy button

#

holding the alt key stops it from doing a new deployment, since we dont want a new deployment just yet

marsh pollen Mar 16, 2024, 3:52 AM

#

done

woven blaze Mar 16, 2024, 3:53 AM

#

marsh pollen in my schema.prisma I have: datasource db { provider = "mysql" url ...

under your url field, add another field named directUrl with its value set to env("DATABASE_URL_DIRECT")

marsh pollen Mar 16, 2024, 3:53 AM

#

I have these now:
DATABASE_URL=${{MySQL.MYSQL_PRIVATE_URL}}
DATABASE_URL_DIRECT=${{MySQL.MYSQL_URL}}

woven blaze Mar 16, 2024, 3:53 AM

#

perfect

visual cosmos Mar 16, 2024, 4:11 AM

#

Hun

#

A

marsh pollen Mar 16, 2024, 4:12 AM

#

Hi

visual cosmos Mar 16, 2024, 4:12 AM

#

I have these now:
DATABASE_URL=${{MySQL.MYSQL_PRIVATE_URL}}
DATABASE_URL_DIRECT=${{MySQL.MYSQL_URL}}

visual cosmos Mar 16, 2024, 4:12 AM

#

marsh pollen Hi

Hy

marsh pollen Mar 16, 2024, 4:13 AM

#

Brody had to leave?

woven blaze Mar 16, 2024, 4:13 AM

#

do you two know each other?

marsh pollen Mar 16, 2024, 4:13 AM

#

No, he just joined the chat!

woven blaze Mar 16, 2024, 4:14 AM

#

uh strange

marsh pollen Mar 16, 2024, 4:14 AM

#

I thought he replace you

woven blaze Mar 16, 2024, 4:14 AM

#

i dont know them

#

i dont know why they repeated something you said either, sorry about that

marsh pollen Mar 16, 2024, 4:15 AM

#

Isn't he a member of railway support?

woven blaze Mar 16, 2024, 4:15 AM

#

nope

marsh pollen Mar 16, 2024, 4:15 AM

#

his role is "support access"

woven blaze Mar 16, 2024, 4:16 AM

#

that just means they they can chat in #1006629907067064482 forums

#

same as you

#

and for transparency i dont work for railway

marsh pollen Mar 16, 2024, 4:16 AM

#

you are not railway support either, right?

woven blaze Mar 16, 2024, 4:16 AM

#

correct

marsh pollen Mar 16, 2024, 4:17 AM

#

thanks for your help man. you were saying

woven blaze Mar 16, 2024, 4:17 AM

#

always happy to help

woven blaze Mar 16, 2024, 4:18 AM

#

woven blaze under your `url` field, add another field named `directUrl` with its value set t...

did you make this change?

marsh pollen Mar 16, 2024, 4:18 AM

#

yes

#

DATABASE_URL=${{MySQL.MYSQL_PRIVATE_URL}}
DATABASE_URL_DIRECT=${{MySQL.MYSQL_URL}}

seems equivalent to what we had earlier:

DATABASE_URL=${{MySQL.MYSQL_URL}}

woven blaze Mar 16, 2024, 4:22 AM

#

okay can you show me your new shema.prisma file

marsh pollen Mar 16, 2024, 4:22 AM

#

datasource db {
provider = "mysql"
url = env("DATABASE_URL")
relationMode = "prisma"
}

generator client {
provider = "prisma-client-js"
seed = "ts-node prisma/seed.ts" //shouldn't this be .js(mar 15, 24) No!!! it worked as-is in deploying to railway

}

woven blaze Mar 16, 2024, 4:23 AM

#

woven blaze under your `url` field, add another field named `directUrl` with its value set t...

please make these changes

marsh pollen Mar 16, 2024, 4:25 AM

#

I thought you were talking about the env variables in railway settings. made the change in the schema file now

woven blaze Mar 16, 2024, 4:25 AM

#

lets see the new schema file please

marsh pollen Mar 16, 2024, 4:25 AM

#

datasource db {
provider = "mysql"
url = env("DATABASE_URL")
directUrl = env("DATABASE_URL_DIRECT") //added for railway
relationMode = "prisma"
}

generator client {
provider = "prisma-client-js"
seed = "ts-node prisma/seed.ts" //shouldn't this be .js(mar 15, 24) No!!! it worked as-is in deploying to railway

}

woven blaze Mar 16, 2024, 4:26 AM

#

looks good, push the changes

marsh pollen Mar 16, 2024, 4:30 AM

#

should i have these in my railway env vars?
DATABASE_URL=${{MySQL.MYSQL_PRIVATE_URL}}
DATABASE_URL_DIRECT=${{MySQL.MYSQL_URL}}

#

I misunderstood you, but you were ok with these.

woven blaze Mar 16, 2024, 4:30 AM

#

yeah, those are what should be in the service variables

marsh pollen Mar 16, 2024, 4:31 AM

#

but isn't this circumventing the private_url? when we add the public one?

woven blaze Mar 16, 2024, 4:32 AM

#

from your schema.prisma file -

  url          = env("DATABASE_URL")
  directUrl    = env("DATABASE_URL_DIRECT") //added for railway

the directUrl is used for generation, migrations, and seeding and such, but url will be used for all other in app database calls

#

heres the prisma docs for that https://www.prisma.io/docs/orm/reference/prisma-schema-reference#fields

marsh pollen Mar 16, 2024, 4:34 AM

#

it failed this time:

#

📎 build_logs_cooli_1710563653.log

woven blaze Mar 16, 2024, 4:36 AM

#

can you remove the postinstall script in your package.json?

marsh pollen Mar 16, 2024, 4:39 AM

#

deploying after making this change

#

failed again

📎 build_logs_cooli_1710564183.log

woven blaze Mar 16, 2024, 4:47 AM

#

it seems like the architecture of your app prevents you from using the private url since the private network is not available during build

#

you will have to go back to using the public url

#

DATABASE_URL=${{MySQL.MYSQL_URL}}

marsh pollen Mar 16, 2024, 4:50 AM

#

ah. ok. I reversed the changes.

woven blaze Mar 16, 2024, 4:51 AM

#

i know railway but i unfortunately dont have enough experience with prisma to be able to advise on the needed changes you would have to make so that the public url is used at build and the private url is used during runtime

marsh pollen Mar 16, 2024, 4:52 AM

#

no worries. I'll look into that.

woven blaze Mar 16, 2024, 4:52 AM

#

sounds good

marsh pollen Mar 16, 2024, 4:53 AM

#

about the .env file, you said there's a better way of storing that information?

#

I didn't understand why, cause the .env file is in the dev environment only.

woven blaze Mar 16, 2024, 4:54 AM

#

do you have different stuff in there as opposed to what you have in railway?

marsh pollen Mar 16, 2024, 4:54 AM

#

no, it's the same stuff, used for dev.

#

localhost

woven blaze Mar 16, 2024, 4:56 AM

#

if thats true, then you can get rid of the local .env and use railway run <your command here> as that will run the given command with all your railway service variables now available to the command you ran

#

its better because everything is stored securely in railway instead of a plaintext file

marsh pollen Mar 16, 2024, 4:58 AM

#

Thank you for all your help. I'm in a comfortable place to figure out the rest of the details.

woven blaze Mar 16, 2024, 4:58 AM

#

awsome, but dont feel shy if you have any more questions

#

i assume your latest deployment is working again?

marsh pollen Mar 16, 2024, 4:59 AM

#

yes

woven blaze Mar 16, 2024, 5:00 AM

#

great!

marsh pollen Mar 16, 2024, 5:02 AM

#

Hey, I got you some coffee. not much but a small token of appreciation. I hadn't realized you weren't railway support.

woven blaze Mar 16, 2024, 5:03 AM

#

wow thank you so much, that means a lot ❤️

marsh pollen Mar 16, 2024, 5:03 AM

#

Have a good one.

woven blaze Mar 16, 2024, 5:06 AM

#

you too!!

marsh pollen Mar 16, 2024, 1:37 PM

#

Hi @woven blaze About that custom domain with cloudflare, I added the two DNS records from cloudflare to my Google Domains DNS list and then added the CNAME @ root value from railway to cloudflare with a Full DNS setup. Am I missing something 'cause it's not working.

woven blaze Mar 16, 2024, 3:21 PM

#

show me what you have put into your nameservers in Google domains please

marsh pollen Mar 16, 2024, 5:08 PM

#

Here they are @woven blaze

woven blaze Mar 16, 2024, 5:09 PM

#

yeah that looks good, what is the status of your custom domain in your railway service settings?

marsh pollen Mar 16, 2024, 5:14 PM

#

Record not yet detected

woven blaze Mar 16, 2024, 5:15 PM

#

okay, show me your dns settings in cloudflare

#

can i see the public networking section of your railway service too

#

hmmm, something is not quite right with your dns

marsh pollen Mar 16, 2024, 5:24 PM

#

yeah. after refreshing, this is what I'm seeing. so my setup must have been done correctly:

#

Thank you. I guess I'll have to deal with cloudflare now. Can you please delete the last image you shared, the less publicly shared the better.

woven blaze Mar 16, 2024, 5:27 PM

#

no problem

marsh pollen Mar 16, 2024, 5:44 PM

#

should I use the same address from railway for this?

woven blaze Mar 16, 2024, 5:45 PM

#

railway doesnt have anything to do mail servers

marsh pollen Mar 16, 2024, 6:06 PM

#

my www address resolves now. I changed my custom domain to www.blahblah.com but blahblah.com is not resolving. Do I have to upgrade my railway plan or add a redirect rule on cloudflare?

woven blaze Mar 16, 2024, 6:07 PM

#

show me your current cloudflare dns settings please

marsh pollen Mar 16, 2024, 6:10 PM

#

woven blaze Mar 16, 2024, 6:10 PM

#

and your domains in railway

marsh pollen Mar 16, 2024, 6:10 PM

#

woven blaze Mar 16, 2024, 6:10 PM

#

you dont have the non www domain there

marsh pollen Mar 16, 2024, 6:11 PM

#

seems like I can either have www or the one without. I have to upgrade for more.

woven blaze Mar 16, 2024, 6:11 PM

#

do you need a www domain?

#

its 2024 and www is a thing of the past for most cases

marsh pollen Mar 16, 2024, 6:12 PM

#

I understand, but it's expected.

woven blaze Mar 16, 2024, 6:13 PM

#

i would have to disagree with that

#

but to have two domains you would need to be on hobby

marsh pollen Mar 16, 2024, 6:15 PM

#

isn't the trial plan same as the hobby plan?

#

I'll get the hobby anyway.

woven blaze Mar 16, 2024, 6:17 PM

#

nope, different names, different plans

marsh pollen Mar 16, 2024, 6:18 PM

#

realistically, If 50 people are using the website, what kind of bill should i be expecting? I access the website without any data in it and spent 10c so far. It seems to me I need to get back to planetscale and accept their new plan.

woven blaze Mar 16, 2024, 6:19 PM

#

billing isnt based on how many users your site has, its based on how much resources your services use

marsh pollen Mar 16, 2024, 6:20 PM

#

more users = more resources, right? bandwidth , database calls, etc

woven blaze Mar 16, 2024, 6:21 PM

#

that is true, there is a lose correlation

#

it looks like planetscale's cheapest plan is now 39$ a month, your next app and mysql database should never come near 39$ with light to moderate usage

marsh pollen Mar 16, 2024, 6:25 PM

#

I'll give it a go anyway. Will see how things evolve.

woven blaze Mar 16, 2024, 6:25 PM

#

whats the current estimated costs say?

marsh pollen Mar 16, 2024, 6:33 PM

#

not sure. I'd better start using it and decide later. I already am on hobby plan.

woven blaze Mar 16, 2024, 6:35 PM

#

well then go check lol https://railway.app/account/usage

marsh pollen Mar 16, 2024, 6:38 PM

#

great! thanks. Can this name be changed?

#creating mysql db for nextjs app with prisma