Db Store — Playground

db-store-backed to-do list

To configure your own database,
  • Register with Supabase.
  • Create a new database and note down the url and the key (that usually go into an environment)
  • Within the database, create a table and configure it to be public, promote changes in realtime and has no row protection:
    -- Create table
    create table todos (
      id serial primary key,
      task text
    );
    -- Turn off row-level security
    alter table "todos"
    disable row level security;
    -- Allow anonymous access
    create policy "Allow anonymous access"
    on todos
    for select
    to anon
    using (true);
  • Fill in the url and key in the fields below and press "connect".