Comments (4)
To create our database steps:
- Signing up with Supabase through GitHub
- Clicking new project and adding it to our organization
- Naming it whatever they want, a password that they should keep since it won't be shown ever again, and them selecting a region that works best for them which is close to them
- It will take some time for the project to be fully scaffold so they need to wait before the next step.
- Going over to their SQL Editor
- Selecting "New Query"
- Copying our SQL queries and clicking the "RUN" button:
-- Create public profile table that references our auth.user
create table public.profiles (
id uuid references auth.users not null,
created_at timestamptz not null default current_timestamp,
email varchar not null,
primary key (id)
);
-- Create public notes table
create table public.notes (
id uuid not null default uuid_generate_v4(),
title text,
body text,
created_at timestamp default current_timestamp,
updated_at timestamp default current_timestamp,
profile_id uuid references public.profiles not null,
primary key (id)
);
-- inserts a row into public.users
create or replace function public.handle_new_user()
returns trigger
language plpgsql
security definer set search_path = public
as $$
begin
insert into public.profiles (id, email)
values (new.id, new.email);
return new;
end;
$$;
-- trigger the function every time a user is created
drop trigger if exists on_auth_user_created on auth.user;
create trigger on_auth_user_created
after insert on auth.users
for each row execute procedure public.handle_new_user();
- Lastly going over to Authentication and Settings, and switching off "Enable email confirmations" for our project.
from kpop-stack.
Was just about to open this same issue :) Would be good to add this to the top somewhere:
npx create-remix --template netlify-templates/kpop-stack
And you can use this for the header image in the README and the social image in this repo's settings :)
Feel free to change it however you like. Just a suggestion :)
from kpop-stack.
Also, I love the choice for music sub-genre 👏
from kpop-stack.
lol, just noticed #33 😅
from kpop-stack.
Related Issues (20)
- Sign up not working HOT 4
- Gatita
- RLS doesn't work out of the box
- Upgrade to React 18 support with hydrateRoot HOT 8
- Hhhh
- Nhatnguyen
- Kkkk
- -
- Runtime.HandlerNotFound: server.handler is undefined or not exported
- Issue with creating user, cannot read properties of null HOT 7
- Adds maintenance tooling
- npx create-remix --template netlify-templates/kpop-stack is not working HOT 3
- Improve DX for local development
- /join trying to create a user - Cannot read properties of null (reading 'id') HOT 11
- Improve the initial infrastructure for the database HOT 2
- Dependency Dashboard
- Issue with Tailwind on a fresh install HOT 4
- How to setup RLS? HOT 4
- Mac M1 Issue with puppeteer HOT 1
- Question: What build script should i tell netlify to use? HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from kpop-stack.