SecondThundeR / otaquiz

Anime quiz app. Built with T3 Stack. Powered by Shikimori API
https://otaquiz.ru
MIT License
2 stars 0 forks source link

refactor: update DB structure and hosting #30

Open SecondThundeR opened 8 months ago

SecondThundeR commented 8 months ago

Current DB structure has some flaw with it's size, due to saving results as JSON:

image

When size limit matters, this can be a real problem later on


Also, interesting idea to save custom game preset to see it in history page w/ button to launch the same one


Maybe we should also move to PlanetScale (5GB storage on free tier vs 500 MB storage on Supabase's free tier)

https://www.prisma.io/docs/guides/database/planetscale