why is this crazy? I took you 15 Minutes to set up. In my case now for example, I've started with Supabase and now I need a System to write and create Blog-Posts. Instead of building an admin panel and doing all from scratch, just do THAT and it's done. Nice video!

@CodingAfterThirty

Ай бұрын

Lol. After going through the process of making the video, I realized it was not as wild as I thought it to be initially. There are definitely use cases for this example. It is just not officially recommended by Strapi. I still prefer just using a regular Postgresql instance running on the same server as the strapi instance. Thanks for checking out the video.

It's still working.. Thank you for this i was using free postgress database from render it used to expire after 90 days but now they changed it to 30 days, keep the good work man Thank you.

If you happen to take this approach I'd suggest to not forget to enable row level security on tables, use service role key and adjust storage policy to prevent anon keys deleting objects or entries in db 🙌

@CodingAfterThirty

9 ай бұрын

Thank you. That is a very important tip.

thank you so much bro, its was very helpful

@CodingAfterThirty

9 ай бұрын

Nice, thank you 🙏. Also, I discovered another great cloud DB to use with Strapi. It’s called Neon DB, a great alternative if you just need a DB without to many extras.

@hossein5998

8 ай бұрын

Great! Thank you for sharing your discovery @@CodingAfterThirty

I don’t remember at this point, but does strapi use SQLite by default or does it need a Postgres db?

@CodingAfterThirty

10 ай бұрын

Yeah. It uses SQLite by default.

@Offiziersmesser

6 ай бұрын

@@CodingAfterThirty if i started out with sqlite and I had loaded some content which is stored in the .tmp/data.db file ,how can I transfer this data to supabase database?

I think some things got mixed up here strapi comes with sqlite database by default but what if you wanted a postgreDB as storage .That doesn't nessesarily mean data is feched from supabase on front end but when you call the strapi endpoint it feches data from the supabase db

@CodingAfterThirty

6 ай бұрын

Strapi allows you to choose multiple database options. I feel that you should use one or the other. Although this example shows how you can use Supabase, I would prefer to use it in its intended way. And yes, by default, Strapi comes with SQLite, which most people use in development. So, different environments can support other databases. I typically just stick with SQLite in dev and Postgres in production. And I prefer running my db in the same place where I deploy my app. I typically will run selfie

Thanks for this video I liked this approach. I have one stance of Strapi running on my VPS and sincerely I hate configuring the infrastructure, is there any other approach similar to the one used in this video, with simple deploy for DB and Storage? Strapi cloud isn't a good option in my case since it will be 6x more expensive due to my country's currency. Sanity seems to be a good option too, but I am more comfortable with Strapi and I like the dynamic zones approach.

@CodingAfterThirty

6 ай бұрын

I typically like using Neon DB for database, Cloudinery for files and either Render or digital ocean, but digital ocean does not have a free tear.

I'm actually considering this architecture for a large production project. My only question is whether to use strapi or supabase for auth

@CodingAfterThirty

3 ай бұрын

I personally would not use Supabase as a Strapi database. My personal opinion. But if I was my question would be? Are you using Strapi admin just to make it easy for folks to add data to your supabase instance? But your front end will be consuming supabase? If so use Supabase auth.

How do we paste richtext without losing the format to strapi. I can't see an option for such a simple thing.

@CodingAfterThirty

10 ай бұрын

The current rich text field supports markdown. On the front end you can use react markdown to parse. You can checkout github.com/strapi/nextjs-corporate-starter/blob/main/frontend/src/app/%5Blang%5D/components/RichText.tsx Where I am doing this in the front end. You can also checkout CKEditor Plug-in on the Strapi Marketplace.

Hey there thanks for the video. I'm having errors uploading media even after setting up a public bucket with a directory and editing the .env files. Do you have any suggestions for me?

@annachen5688

8 ай бұрын

never mind i had an extra space in it!

@CodingAfterThirty

7 ай бұрын

Glad you were able to find the answer. Sorry for the late response. I just saw your comment.

Impressive tips🎉 so can use supa just for the auth to protect the routes and use strapi as a rest api ???

@CodingAfterThirty

3 ай бұрын

I personally don't recommend this approach. Either use one or the other. From what I see, folks like to use supabase for all the endpoints consumed by their fronted and use Strapi as an admin panel to add data into their supabase database.

subbed

@CodingAfterThirty

7 ай бұрын

Thank you for checking out the video and your support.

Thank u for the video. love u man😘. i have a question freelancing . when we deliver product to client do we need give acess for this platform like supabase , netlify , render ect ?

@CodingAfterThirty

6 ай бұрын

That’s a good question, it is really up to you, and how you setup the agreement. If I were to build a project for a client. I would use tech that would be easy for none developers. Like a headless CMS like Strapi that I show in this video. I would also not use Supabase if I am using Strapi. I would also deploy the project an a platform that is easier to use or manage. Like digital ocean app or Strapi cloud. And frontend in Netlify or Vercel. After I finish the product I would give them one of these options. 1. Turn over the project to them and be done. 2. Turn over the project to them and stay as a retainer, where if they need help they can hire me hourly. And I personally would not hold any accounts. I would instead, when need to update something, would log into users account instead. That way the majority of responsibility is on them.

@hostbybits-webhostingforre6845

Ай бұрын

Deliver the product and provide access to it. If the client agrees to ongoing maintenance, ensure you have an account for your access. Some freelancers retain access and occasionally disappear, leaving clients unable to update or upgrade their products. This is a bad practice that can result in clients losing their product due to the lack of updates/upgrades

I am encountering this error when I run npm run develop (I am using npm for my repo). it stops at 'loading strapi' and displays this error: KnexTimeoutError: Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call? any help?

@Offiziersmesser

6 ай бұрын

It seems like my uni wifi was blocking the connection, I switched to my mobile hotspot and it worked.

@CodingAfterThirty

6 ай бұрын

That is interesting. I am glad you were able to figure it out. Sometimes you may get pulling connections do to not having proper configuration or closing previous connections.

I watched the first 5 minutes. Are you saying that DB as a service is the same as Strapi (CMS)? Or I missed something?

@CodingAfterThirty

9 ай бұрын

Lol. I think I made sense at 5 min and 30 seconds. I think the point I tried to make is that they both serve slightly different needs. And one should chose accordingly, and not use both. Although, I have seen few projects where folks use Supabase as there preferred database and API and only use Strapi’s admin panned to add data to supabase. But Strapi is an api for your backend, so why use Strapi and Supabase together. I don’t get it.

@user-ww4ff2mk2z

9 ай бұрын

@@CodingAfterThirty I don't fully agree with you, but that's okay :) Keep creating awesome content!

@CodingAfterThirty

9 ай бұрын

@@user-ww4ff2mk2z I respect that. Also, feel free to share your reason here, it can help others. Just because I have an opinion , doesn't mean that it is the only one. ( or right ) lol.

help me, i can't create web services because "Add credit card to verify your identity."

@CodingAfterThirty

4 ай бұрын

I am not sure if this is something new they started to do. If so I guess the only way to get past it is you add your credit card. I typically don't use Superbase as often and never had it ask for a credit card in the past.

So why do we need Strapi if Subabase can do everything?

@CodingAfterThirty

10 ай бұрын

You don’t get an admin area to manage content creation and ability to customize back end through controllers, policies, middleware and services. And create custom plugins. And you are right depending on your project you would pick the best technology. In your case it might be Supabase. For stuff that I build, revolves around lots of content. And Strapi makes sense for me. To be honest. Depending on the project requirements I would pick what ever tech makes sense. Lol. I like both Strapi and Supabase. Just like I like Remix and Next. At the end of the day, I build things for customers. They are the boss. Great point though.

@alsherifkhalaf7385

9 ай бұрын

The opposite direction, why Supabase when Strapi can do everything that Supabase can do ?

@CodingAfterThirty

9 ай бұрын

@@alsherifkhalaf7385 I think if you just need a database and an API supabase is amazing. But if you have alot of content that many people need to manage, editors, publishers and so on, Strapi is the way to go. Also supabase supports vector data storage, which is really exciting. I am currently using pinecone, and it is pricey for my particular project. I don't mind spending money where it matters, but at the moment supabase vector storage makes sense. So i am in the process of converting one of my ai plugins to supabase.

@alsherifkhalaf7385

9 ай бұрын

@@CodingAfterThirty I agree, Strapi is better when you need a dashboard with nice ui and many editing features .

Strapi cloud is too expensive for small projects

@CodingAfterThirty

10 ай бұрын

Yes. That is why I like the fact there are many options to host you project. I think Render and Digital Ocean are great choices. I use both those platforms. I think picking the right hosting based on project needs is important.

Where's the repo? 🤔

@CodingAfterThirty

3 ай бұрын

Unfortunately, it went missing but here is a project setttign where I used a different PostgreSQL DB but based on the setting. You just need to update the env to point to your supabase db. github.com/PaulBratslavsky/strapi-free-deploy-render-elephant-cloudinary/blob/main/config/database.js