pull down to refresh
39 sats \ 4 replies \ @k00b 27 Jan \ parent \ on: ~Econ Monthly Check-In econ
We have some materialized views that crunch them periodically e.g. permalink to user_stats_days
This part of the project is relatively unapproachable tbh. There's a lot of implied context (bad) in the DB schema. I don't want to scare you, but in case you're confused, it's our fault.
I'll take a look if I have time (I probably won't, or will take a long time to get around to it, but the desire to contribute is there)
reply
Following up on this... does this mean
prisma/migrations/20240710001134_user_stats_refine/migration.sql was manually created? Because I couldn't find user_stats_days defined except in these migration files.Sorry if dumb question, I am not familiar with prisma, but I thought the migrations are automatically managed.
Also, if you prefer that I move dev discussion to another channel, lmk. I didn't want to pollute the github issues / discussions threads unnecessarily if this is a dumb question.
reply
This isn’t a dumb question. To modify ‘user_stats_days’ you’ll need to replace the function by performing another migration.
‘sndev prisma migrate dev —create-only’ will create an empty migration.
prisma’s docs are going to be the best place to learn about this stuff.
GitHub discussions would be great for these questions because other folks can chime in - and find them if they have the same questions.
Dumb questions are more than welcome!
reply
Thanks I'll post future questions in GitHub discussions
reply