Clearing some confusions at 5:30. Hasura is not a database, it is a way for you to spin up a GraphQL API or REST API that connects to a database that contains structured data (i.e columnar or row-based aka relational db) with just some clicks and modifications. Supabase and Firebase are BaaS-es that offer serverless database as part of their service.
Do you know how to handle storage bucket files with Supabase? I'm having a hard time trying, can't find solutions around x.X. Basically i want to display images dinamically, every crud tutorial around only show text.
Mr Joy, this was a great video. Personally, I prefer the pocketbase approach for various reasons but I like running the front end code serverlessly. Is it possible to run svelte kit on vercel together with a pocketbase backend that runs on my own linux server?
@@JoyofCodeDev Yes. I'm using Supabase only, and it's great because it's an easy way to have a database and authorization out of the box. But I'm struggling to make it type-safety and would prefer to have all my schema structure accessible in VS Code than need to check it on Supabase platform. It looks like Prisma could solve this (and Lucia could help with the auth).
Apparently the vercel adapter doesn't support node 19? do I have to downgrade my version of node or is there a way to update svelte/adapter-vercel to allow node 19 to work?
You can change it in the settings but only major versions are supported: vercel.com/docs/concepts/functions/serverless-functions/runtimes/node-js#node.js-version.
I seem to be getting the same errors you got in the video.The project consistently works while using a local postgres db, but once Supabase is introduced errors regularly show up.
I'm curious are you using the same region? When I tried it out I used the default region and had no issues but it seems there's a problem with Supabase. I also wonder if the issue is related to connection pooling.
@@JoyofCodeDev Yes, it was indeed a connection pooling issue, just figured it out. We need to add ?pgbouncer=true after the DATABASE_URL env variable. Awesome content btw, always a joy to see more of these videos of yours. Thanks for making it happen.
@@JoyofCodeDev actually even with the connection pooling I have the same problem and I can't even register a new user in the app. I have "can't reach database server at..." in the logs. Even the prisma db push works only sometimes. I'm testing from the same region in Germany
Vercel already caches static assets forever and ISR is their mechanism for busting the cache for individual pages instead of having to redeploy your site when you make a change.
Thanks for the great videos. Please add how to get the env file to work with node adapter. Using dotenv gives an error when building a docker image. Says env variable not included in role up
I'm not familiar with Docker but sounds like something you should do in the configuration and make sure you're using SvelteKit to manage environment variables: github.com/CodingGarden/listd.
May I ask.. What's the problem with SSG +CSR for dynamic content, however SSR only and only if you have something like e-commerce where you'd have to build the content every so often? SSR sounds redundant to most of the usecases to me
The problem is you don't have SEO and it's a worse user experience because of loading spinners everywhere but using server-side rendering your site works before JavaScript and then you can use progressive enhancement.
Please Post a video on how to deploy svelte kit with `adaptor-node` to an aws lightsail / ec2 server and with the shared hosting service that supports node.
when can one do anything interesting ? what a nightmare simple straightforward things are in modern development....I think we as developers are still stuck in the assembly coding era as far as developer experience is concerned.....atleast thanks to svelte who are a bit considerate to humans....other technologies are just down right anti-human...I hate this command line culture and millions of fragile config files, spent half day getting pnpx to run on my system
There is an annoying latency with supabase - too bad vercel does not support in some way (storage) Sqlite as it could be a great fast solution. @JoyofCodeDev what do you think?
I forgot that you should add `?pgbouncer=true` to the end of `DATABASE_URL` because I skipped over connection pooling which was causing issues.
This series has been invaluable.
Thank you! 😄
Completed!! Thank you friend.. as a new developer learned a lot of things from you!
Kiitos!
Thank you! 🙏
Clearing some confusions at 5:30.
Hasura is not a database, it is a way for you to spin up a GraphQL API or REST API that connects to a database that contains structured data (i.e columnar or row-based aka relational db) with just some clicks and modifications. Supabase and Firebase are BaaS-es that offer serverless database as part of their service.
That makes a lot of sense because I didn't understand their marketing.
I have been watching your videos since few months, Your content is very useful and the way you present it is absolutely awesome. Its cozy and warm.
Thank you! 😄
Bro, I guess I know you. And I believe you too.
@@DevBishwasBh Absolutely dai !
Third
First in my heart.
@@JoyofCodeDev hahahah
Do you know how to handle storage bucket files with Supabase? I'm having a hard time trying, can't find solutions around x.X. Basically i want to display images dinamically, every crud tutorial around only show text.
Mr Joy, this was a great video. Personally, I prefer the pocketbase approach for various reasons but I like running the front end code serverlessly. Is it possible to run svelte kit on vercel together with a pocketbase backend that runs on my own linux server?
Thanks for your great tutorials! Is there a tutorial where you introduce prisma?
Not yet. 🤫
Great content, Matt! Would love one video explaining how to use Sveltekit and Supabase with Prisma. In this case, you're not using Supabase Auth?
Do you mean how to set up Prisma? I'm only using Supabase for the database and Lucia for auth.
@@JoyofCodeDev Yes. I'm using Supabase only, and it's great because it's an easy way to have a database and authorization out of the box. But I'm struggling to make it type-safety and would prefer to have all my schema structure accessible in VS Code than need to check it on Supabase platform. It looks like Prisma could solve this (and Lucia could help with the auth).
I would love to! 🙂
Apparently the vercel adapter doesn't support node 19? do I have to downgrade my version of node or is there a way to update svelte/adapter-vercel to allow node 19 to work?
You can change it in the settings but only major versions are supported: vercel.com/docs/concepts/functions/serverless-functions/runtimes/node-js#node.js-version.
Another great video and a subject that tutorials often forget about! Which autocomplete are you using in your terminal?
I use github.com/zsh-users/zsh-autosuggestions.
@@JoyofCodeDev thank you!
I seem to be getting the same errors you got in the video.The project consistently works while using a local postgres db, but once Supabase is introduced errors regularly show up.
I'm curious are you using the same region? When I tried it out I used the default region and had no issues but it seems there's a problem with Supabase. I also wonder if the issue is related to connection pooling.
@@JoyofCodeDev Yes, it was indeed a connection pooling issue, just figured it out. We need to add ?pgbouncer=true after the DATABASE_URL env variable.
Awesome content btw, always a joy to see more of these videos of yours. Thanks for making it happen.
@@JoyofCodeDev actually even with the connection pooling I have the same problem and I can't even register a new user in the app. I have "can't reach database server at..." in the logs. Even the prisma db push works only sometimes. I'm testing from the same region in Germany
This is very helpful
Thank you! 😄
How did you get the suggestions as you are typing in terminal like copilot?
I use the github.com/zsh-users/zsh-autosuggestions plugin.
Is it a good idea to use Cache-Control headers together with Vercel ISR?
Vercel already caches static assets forever and ISR is their mechanism for busting the cache for individual pages instead of having to redeploy your site when you make a change.
Thanks for the great videos. Please add how to get the env file to work with node adapter. Using dotenv gives an error when building a docker image. Says env variable not included in role up
I'm not familiar with Docker but sounds like something you should do in the configuration and make sure you're using SvelteKit to manage environment variables: github.com/CodingGarden/listd.
May I ask..
What's the problem with SSG +CSR for dynamic content, however SSR only and only if you have something like e-commerce where you'd have to build the content every so often? SSR sounds redundant to most of the usecases to me
The problem is you don't have SEO and it's a worse user experience because of loading spinners everywhere but using server-side rendering your site works before JavaScript and then you can use progressive enhancement.
Awesome video man! Keep it up 🤌
Great 🎉🎉🎉🎉
Please Post a video on how to deploy svelte kit with `adaptor-node` to an aws lightsail / ec2 server and with the shared hosting service that supports node.
Supposedly the startup time for prisma on the edge network is extremely slow because of prisma's large size.
Yeah, I've heard about that but I have not run into any issues for my personal projects.
A tutorial on how you built the website
I have an entire video on making a Markdown blog with SvelteKit: ua-cam.com/video/RhScu3uqGd0/v-deo.html.
Can we get please the source code for each video in the series.
You can find the post in the description.
What do you think of Payload CMS SvelteKit?
Never heard of it.
I love your tutorials but I can't find how to deploy a sveltekit app on github pages
My favorite type of 99 .....
free 99
first
Be careful not to leak this to anyone 😅
This is obsolete now
when can one do anything interesting ? what a nightmare simple straightforward things are in modern development....I think we as developers are still stuck in the assembly coding era as far as developer experience is concerned.....atleast thanks to svelte who are a bit considerate to humans....other technologies are just down right anti-human...I hate this command line culture and millions of fragile config files, spent half day getting pnpx to run on my system
It's strange that the browser
caches because you have a tick on the "do not cache" in developer tools. ua-cam.com/video/uAF4Yd-gddo/v-deo.html
That's because you're not using the disk cache but a CDN.
There is an annoying latency with supabase - too bad vercel does not support in some way (storage) Sqlite as it could be a great fast solution. @JoyofCodeDev what do you think?
Vercel introduced storage but I haven't tried it: vercel.com/blog/vercel-storage.
@@JoyofCodeDev Yeah they do - actually pretty nice - I use vercel-postgres but for some reason they dont add Sqlite as well.