Flutter FutureBuilder using Supabase query

Question

I'm unable to get Supabase queries working with flutter. Here is an example of the code:

child: FutureBuilder<PostgrestResponse<dynamic>>(
   future: supabase.from('products').select().execute(),
      builder: (context, snapshot) {
         if (snapshot.connectionState != ConnectionState.active) {
            return const Center(
               child: SizedBox(
                  child: CircularProgressIndicator(),
                      width: 60,
                      height: 60,
                  ),
               );
            } else {
               return GridView.builder(
                  gridDelegate:
                      SliverGridDelegateWithFixedCrossAxisCount(
                        crossAxisCount: gridColumns,
                        crossAxisSpacing: 10,
                        mainAxisSpacing: 10,
                      ),
                      itemCount: snapshot.data!.length, // this line is causing an error
                      ...

I have no idea how to turn the length of the snapshot. It is was to turn this to streambuilder it would work. So really all i'm after is a basic example of using a futurebuilder with supabase.

Ali Bayram · Accepted Answer · 2022-01-07 05:45:54Z

0

You can use if (snapshot.hasData) instead of checking snapshots connection state. Because it would be not including any data and connection state is not active.

So you can change your code as;

child: FutureBuilder<PostgrestResponse<dynamic>>(
   future: supabase.from('products').select().execute(),
      builder: (context, snapshot) {
         if (!snapshot.hasData) {
            return const Center(
               child: SizedBox(
                  child: CircularProgressIndicator(),
                      width: 60,
                      height: 60,
                  ),
               );
            } else {
               return GridView.builder(
                  gridDelegate:
                      SliverGridDelegateWithFixedCrossAxisCount(
                        crossAxisCount: gridColumns,
                        crossAxisSpacing: 10,
                        mainAxisSpacing: 10,
                      ),
                      itemCount: snapshot.data!.length, // this line is causing an error
                      ...

answered Jan 7, 2022 at 5:45

Ali Bayram

7,9912 gold badges24 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jake Anderson Over a year ago

Thanks Mehmet, ok made that change but still unsure how you would output an itemCount for the builder?

Ali Bayram Over a year ago

Can you show inside your PostgrestResponse class, probably you need to get length of some property inside it

Kathirvel Chandrasekaran · Accepted Answer · 2022-08-14 06:34:32Z

0

While debugging the code, the response is coming as snapshot.data.data

So, the count value can be obtained by

itemCount: snapshot.data.data?.length,

answered Aug 14, 2022 at 6:34

Kathirvel Chandrasekaran

662 silver badges5 bronze badges

Collectives™ on Stack Overflow

Flutter FutureBuilder using Supabase query

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related