Dear James, can you please make a video describing these points in working with Supabase: real-time update (like Firebase), push notifications, search (like Algolia in Firebase).
Supabase is cool, I like it but everything presented here is postgres function - not supabase. For enums / types highly recommend creating an enums schema and a table for the enums type with a simple name(pk) and description field. For example for a payment status enumerated field you would create an enums.payment_status table with name values of 'PENDING', 'PAID', 'DECLINED' with optional descriptions for each name value. Then in your orders table your payment_status field can be a foreign key relationship to the enums.payment_status and automatically inherit the values aailable there. Set constraints for UPDATE to CASCADE and DELETE to RESTRICT or SET NULL based on your needs. This allows you to modify your enums at will. The postgres native ENUMs provided here in supabase are a nightmare to deal with in production IF you need to change the nomenclature or add/remove any of the enums.
I concur that Postgresql enums should be used judiciously. I think the main disadvantages are: 1) Inconvenient to modify (requires scheme update). 2) Sort order is fixed at time of creation (if you create your own lookup table you can create a column with the required sort order). 3) Non standard SQL, thus causing portability issues. 4) Enums can’t be used as primary keys or foreign key constraints.
One process Firebase does that doesn't seem to work the same way with Supabase is the Real-time updates within a Flutterflow app when data in the database changes (without refreshing the screen app screen firebase updates automatically change the data in the ui). Would love to see a video on how to do that with Supabase's real-time (if its possible) Great content though! Keep it up!
Also James, I recon it's a strategy of your to mark your timeline anonymously. However it makes it difficult to find certain points when re-watching your videos. Maybe have another look at that strategy? Nevertheless; thank you for your time and efforts.
Hey James Thanks for this amazing video, My question is that How I able to make social media app with advertise like instagram has? because I do not want to show google ads so how I can connect two database and show data simultaneously that is for users and second one is for advertisers in flutterflow home page in listview?
Thank you James for creating your great tutorials. I really appreciate your way of explaining things. Thanks to you I at last started to understand Flutterflow. I have a question relating to setting constraints on the level of Supabase table instead of Flutterflow. I am just wondering if it is not redundant since sometimes we need to display error message for app user. We can do so by setting constraints in Flutterflow and generating error message when constraint condition is not met. In such a case it seems that setting conditions in Supabase is superflous. Could you please advice me on that issue?
Hi you have brilliant tutorials and helpful info. Could you do a simple tutorial for room estimator, for example width * length = sum, with a button to calculate. Thank you
Hi James Great work, We are using Flutterflow with supabase and need to do database filters/ queries. What is the best and latest methods for doing this, for example I want to find all records in our clients table where the surname is ‘Smith’ and the first name is ‘Johm’ case insensitive OR the surname is ‘Smith’ and the date of birth is 01/01/2000 etc It seems such a simple ask, but I’ve been all over the forums etc and can’t find the way to do this . Could you do a detailed video on this or can someone help ?
Great videos, keep them up. I have a couple of questions, can I trap subabase errors in FF and the second, can you show us how to enable users in subabase to reset their password inside FF. TIA
I haven’t used it yet but am in the process of making a project and plan on using that. I had the same question before I chose supabase for this project.
@@nathangrace8581 i just implemented Onesignal integration, i think it'll work but i didn't test it on real device yet, will update you if it works. The custom code i used can be found on the flutterflow community website.
👍VIEW/CLONE ALL MY NOCODE APPS + support my work: www.patreon.com/jamesnocode
👍GET MY NEW TRAINING - MASTERING FLUTTERFLOW: masteringflutterflow.com
00:00 Intro
01:04 Feature 1 - PostgreSQL Composite Primary Keys
05:01 Feature 2 - PostgreSQL Check Constraints
07:46 Feature 3 - PostgreSQL Enum Type
11:22 Feature 4 - Use Postgres to make HTTP requests. (IMHO not a good idea)
16:58 Feature 5 - Supabase Wrappers - Loading data from firebase
21:56 MC
Been loving supabase so far..
Dear James, can you please make a video describing these points in working with Supabase: real-time update (like Firebase), push notifications, search (like Algolia in Firebase).
no push notifications, limited realtime db, extremely limited concurrent connection and no algolia integration :D
Great and very useful video!
Powerful tools. Thanks for sharing.
Supabase is cool, I like it but everything presented here is postgres function - not supabase.
For enums / types highly recommend creating an enums schema and a table for the enums type with a simple name(pk) and description field. For example for a payment status enumerated field you would create an enums.payment_status table with name values of 'PENDING', 'PAID', 'DECLINED' with optional descriptions for each name value. Then in your orders table your payment_status field can be a foreign key relationship to the enums.payment_status and automatically inherit the values aailable there. Set constraints for UPDATE to CASCADE and DELETE to RESTRICT or SET NULL based on your needs.
This allows you to modify your enums at will. The postgres native ENUMs provided here in supabase are a nightmare to deal with in production IF you need to change the nomenclature or add/remove any of the enums.
I concur that Postgresql enums should be used judiciously. I think the main disadvantages are: 1) Inconvenient to modify (requires scheme update). 2) Sort order is fixed at time of creation (if you create your own lookup table you can create a column with the required sort order). 3) Non standard SQL, thus causing portability issues. 4) Enums can’t be used as primary keys or foreign key constraints.
One process Firebase does that doesn't seem to work the same way with Supabase is the Real-time updates within a Flutterflow app when data in the database changes (without refreshing the screen app screen firebase updates automatically change the data in the ui). Would love to see a video on how to do that with Supabase's real-time (if its possible)
Great content though! Keep it up!
Also James, I recon it's a strategy of your to mark your timeline anonymously. However it makes it difficult to find certain points when re-watching your videos. Maybe have another look at that strategy?
Nevertheless; thank you for your time and efforts.
Now that API auth is possible, what do you prefer; Supabase or Xano? Pros and cons?
Hi James! I wanna know would you do a video about how to make api key private on supabase cloud?
Hey James Thanks for this amazing video,
My question is that How I able to make social media app with advertise like instagram has?
because I do not want to show google ads so how I can connect two database and show data simultaneously that is for users and second one is for advertisers in flutterflow home page in listview?
Thank you James for creating your great tutorials. I really appreciate your way of explaining things. Thanks to you I at last started to understand Flutterflow. I have a question relating to setting constraints on the level of Supabase table instead of Flutterflow. I am just wondering if it is not redundant since sometimes we need to display error message for app user. We can do so by setting constraints in Flutterflow and generating error message when constraint condition is not met. In such a case it seems that setting conditions in Supabase is superflous. Could you please advice me on that issue?
Hi you have brilliant tutorials and helpful info. Could you do a simple tutorial for room estimator, for example width * length = sum, with a button to calculate. Thank you
Hi James
Great work,
We are using Flutterflow with supabase and need to do database filters/ queries. What is the best and latest methods for doing this,
for example I want to find all records in our clients table where the surname is ‘Smith’ and the first name is ‘Johm’ case insensitive OR the surname is ‘Smith’ and the date of birth is 01/01/2000 etc
It seems such a simple ask, but I’ve been all over the forums etc and can’t find the way to do this .
Could you do a detailed video on this or can someone help ?
Can you make a video on how we can use supabase with cloud function?
Can you do a video of weweb + supabase?
Great videos, keep them up.
I have a couple of questions, can I trap subabase errors in FF and the second, can you show us how to enable users in subabase to reset their password inside FF.
TIA
If i switch to supabase, am i just gonna forget push notifications, or is there an alternative?
I haven’t used it yet but am in the process of making a project and plan on using that. I had the same question before I chose supabase for this project.
Onesignal + supabase makes it possible....there is a tutorial on this on youtube as well...
@@nathangrace8581 i just implemented Onesignal integration, i think it'll work but i didn't test it on real device yet, will update you if it works.
The custom code i used can be found on the flutterflow community website.
Supabase integrates With onesignal for that
Any ideas on how to make images show up in a messages table? Not sure how to make an image in a bucket automatically populate its URL to a table
Please I need materials on Supabase and Bubble
How to add Rich text in table?