23/04/04(supabase

참고

https://velog.io/@jaybon/supabase-postgreSql-%EC%82%AC%EC%9A%A9%ED%95%B4%EB%B3%B4%EA%B8%B0-Feat.-flutter

DBever에 Postgre로 DB만들기

supabase 테이블 만들기

supabase API가져오기

flutter에 supabase dependencies에 pub get

flutter code

데이터 가져오기 테스트

main.dart

import 'package:flutter/material.dart';
import 'package:supabase_flutter/supabase_flutter.dart';

Future<void> main() async{
  Supabase.initialize(
    url: "https://frouspwowclieepzubsn.supabase.co",
    anonKey:
    "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6ImZyb3VzcHdvd2NsaWVlcHp1YnNuIiwicm9sZSI6ImFub24iLCJpYXQiOjE2ODA1NzIyMTcsImV4cCI6MTk5NjE0ODIxN30.OHrbR7NwzJmKiCN1c2zhCSLcH5zmCKqZgMYj3FNZwic"
  );
  runApp(MyApp());
}

class MyApp extends StatelessWidget {
  const MyApp({Key? key}) : super(key: key);

  @override
  Widget build(BuildContext context) {
    //select문
    Supabase.instance.client.from("todo").select().then((value){
      print(value);
    });
    return const Placeholder();
  }
}

데이터 추가 후 가져오기

실시간으로 데이터 가져오기

import 'package:flutter/material.dart';
import 'package:supabase_flutter/supabase_flutter.dart';

Future<void> main() async{
  Supabase.initialize(
    url: "https://frouspwowclieepzubsn.supabase.co",
    anonKey:
    "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6ImZyb3VzcHdvd2NsaWVlcHp1YnNuIiwicm9sZSI6ImFub24iLCJpYXQiOjE2ODA1NzIyMTcsImV4cCI6MTk5NjE0ODIxN30.OHrbR7NwzJmKiCN1c2zhCSLcH5zmCKqZgMYj3FNZwic"
  );
  runApp(MyApp());
}

class MyApp extends StatelessWidget {
  const MyApp({Key? key}) : super(key: key);

  @override
  Widget build(BuildContext context) {
    //select문 정적으로 가져오기
    /*Supabase.instance.client.from("todo").select().then((value){
      print(value);
    });*/

    // 실시간으로 가져오기 - stream.listen
    Supabase.instance.client.from("todo").stream(primaryKey: ["idx"]).listen((event) {
      print(event);
    });
    return const Placeholder();
  }
}

ㅇㅇㅇ

return MaterialApp(
      home: Scaffold(
        body: SafeArea(
          child: StreamBuilder<List<Map<String, dynamic>>>(
            stream: Supabase.instance.client.from("todo").stream(primaryKey: ["idx"]),
            builder: (context, snapshot) {
              return ListView(
                children: snapshot.data?.map((e) => Text(e["content"])).toList() ?? [],
              );
            }
          ),
        ),
      ),
    );