#Is it necessary to have SQL knowledge to learn the course "Intro to Supabase"
devout juniper
Hi SCP! Thanks for the question. There’s only a small amount of SQL in the course and it’s fairly basic. I’d recommend trying that challenge (with help from AI) but skip it if you really struggle. Have a read of aggregate functions. Let me know if you need any help
still cobalt
Hi SCP! Thanks for the question. There’s only a small amount of SQL in the cours...
Thank. @devout juniper Yeap that aggregate function bothers me a bit. Just noticed that we have a SQL course in scrimba. And I think they cover the basic SQL.
Will have a check there as well
still cobalt
@devout juniper the "Insert new data" scrim was not working for me regarding the last exercise. I think the id is an int8, which is not automatically added to supabase?
devout juniper
This is odd because the id that Supabase automatically creates on table creation is autoincrementing. Which shouldn't create conflicts. Did you leave the id and created_at columns and just add 'name' and 'value' columns? The nuclear option is just to delete the table (3 dots to right of table name in table editor) and create a new one with the same name.
still cobalt
I think I am just using your scrim and didn’t make any change
devout juniper
If it’s showing your data in the chart then it’s using your env vars and connecting to your project/table. so it won’t be to do with a conflict between my data and yours. Any luck deleting and recreating the table?
still cobalt
If it’s showing your data in the chart then it’s using your env vars and connect...
no idea.I think my table is fine on supabase.
I didn't change much in the table editor. Anyway, it is good that I get the idea how to work with the database. 👀
@devout juniper, would you create a section to cover the supabase authentication (either email or gmail), and protected route with react?
devout juniper
Exactly what I’m working on at the moment 😎
still cobalt
Cool. I am looking forward to it
devout juniper
Did you manage to continue the course after the error?
still cobalt
Did you manage to continue the course after the error?
Yeap I think it is the last exercise or some scrim at the very end of the course.
So, this does not have a huge impact
Currently I am learning email, password auth
still cobalt
I can help you.
Cool. I am just keeping learning. You didn’t have the issue in the scrim?
placid leaf
no.