How do you feed content?

[haikalariffhalim]

I love your work but I dont know how you feed content for dev? I try to feed your data into Prisma but cant get it running properly.

[AnirudhSinghBhadauria]

I appriciate your kind words, Actually when I made this project, I also wanted to make a admin page where we can add blogs, I haven't made it yet, eventually I will, For now I have made a seeding file (path: src/utils/seeding.ts) which has a prisma function that adds blogs to particular models in the database. Basically I added blogs to database via prisma programatically. Please have a look at that file. I am using a sql database (planetscale). For better understanding I am giving you a gist that contains different models and how they look inside of databse that will help you model your database.

Data models in Sterotype - https://gist.github.com/AnirudhSinghBhadauria/50703c894e709d2806a717ce7dcdf0c7

Just model your databse accordingly using these definitions then you would be able to do it! Hope I resolved your issue!

[haikalariffhalim]

Thank you for responding, Ive been planning to use Sanity for CMS. But I noticed the Blogpost has 3 variant which is Headliner, Main Story and Side Story. All three have different components and props. Is there a way for me to create just one type of Post but can be labeled as Headliner, Main or Side that will automatically position the blogpost accordingly? Im a beginner, so there are a lot of things i need to catchup especially for backend and type validation. So I find ot difficult to feed content from Prisma. I saw many tutorial on youtube used seed.ts from Prisma but you seems to use seeding.ts from utils folder. I tried to many times prisma db seed to my PostgreSQL but it failed to update my db. I really really love your work and it will be a massive boost for my tech blog project Appreciate your feedback

…

On Mon, 22 Jan 2024 at 10:10 PM, Anirudh Singh Bhadauria < ***@***.***> wrote: I appriciate your kind words, Actually when I made this project, I also wanted to make a admin page where we can add blogs, I haven't made it yet, eventually I will, For now I have made a seeding file (path: src/utils/seeding.ts) which has a prisma function that adds blogs to particular models in the database. Basically I added blogs to database via prisma programatically. Please have a look at that file. I am using a sql database (planetscale). For better understanding I am giving you a gist that contains different models and how they look inside of databse that will help you model your database. Data models in Sterotype - https://gist.github.com/AnirudhSinghBhadauria/50703c894e709d2806a717ce7dcdf0c7 Just model your databse accordingly using these definitions then you would be able to do it! Hope I resolved your issue! — Reply to this email directly, view it on GitHub <#1 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BAZ4NCFMOA4HRM64YLJ2R33YPZXNVAVCNFSM6AAAAABCE2ID7CVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSMBUGA4DGMRXHE> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[AnirudhSinghBhadauria]

Sorry for late response,

Why I didn't had one model representing all the different kind of blogs -

1. Those three varients of blogpost have their different props and attributes, therefore, I made three different schemas mapping to three different relations in my database.

2. I could have integrated all the different varients of blogs in one model but, then there would have one big model with all the blogs in it. Now, the problem is traversing a big model is exprensive than traversing a smaller one, its like traversing 10 entries vs traversing 100. That would have resulted in bad database query times and it would largly affected the performence of the app.

3. for integrating these three models, we could just make one schema that would contain all the props of all kind of blogs.
   Now If we wanted a particular type of blog, we would only fill data of that blog and leave all the other props null, now using some conditional statements we could have figured out how to display a particular type of blog. I am not an expert and I am also trying to learn how things work, but that doesn't sound like a great idea to me. Hope these explainations made sense.

Coming to the second part,

As I said I am not an expert, but my suggestion would be that you should read documentation of Prisma. I know it maybe a little boring to read the whole documentation, but we dont need to do that (for now at least). For now learn how to connect prisma to db of your choice, how to use prisma on client side (prisma cli), how to visualize db using prisma (prisma gui), how to do CURD operations using prisma. and that good enough for starting learning prisma, as your confidence increases we can gradually learn some advance stuff. If you're stuck at any place, you can always ask chatgpt for the answer, googling always helps!

If you're using a postgres database, first make sure you have configured your .schema file properly.(https://www.prisma.io/docs/getting-started/setup-prisma/start-from-scratch/relational-databases/connect-your-database-node-postgresql)

for any seeding related issue read this,
https://www.prisma.io/docs/orm/prisma-migrate/workflows/seeding

Hope this helps,
Thank you!

[haikalariffhalim]

hye,

thank you for responding. may i know why the need to have an api route when we can pull data from component?

sorry for bugging you

appreciate your feedback