- Angular frontend data entry form with a Supabase PostgreSQL database backend
- Note: to open web links in a new window use: ctrl+click on link
- Supabase is an open-source alternative to Firebase, but uses PostgreSQL instead of document database. Database is realtime & can use SQL joins. Realtime notifications via Websockets. RESTful API requires no backend code.
- RxJS was not required for Observables etc.
- Angular v16
- Supabase public v2 Postgres alternative to Firebase
- Bootstrap v5 responsive styling, including ready-made forms
- Font Awesome v4 free icons
npm ito install dependencies then...- Create free account with Supabase and create table using SQL option. Do not enable RLS (Row Level Security)
- Add Supabase credentials to
utils/initSupabase.ts ng servefor a dev server. Navigate tohttp://localhost:4200/- app will automatically reload if you change any of the source filesnpm run lintto eslint typescript,npm run lint:fixto eslint and fixnpm run prettierto check and fix code formattingng build --prodfor a build folder
ng testto execute the unit tests via Karma.ng e2eto execute the end-to-end tests via Protractor.
- This creates a table in Supabase SQL option
create table todos (
id bigint generated by default as identity primary key,
name text check (char_length(name) > 0),
done boolean default false,
);- Supabase user interface is cool to work with and they have SQL templates to create tables etc.
- Status: Working
- To-Do: Add fields like created & updated dates. Set strict mode to true and correct type error
- To-Do: use Angular routing to add more Supabase tables etc. or remove
- Diligent Dev: Supabase - The Open-source Alternative to Firebase
- Fireship: Is Supabase Legit? Firebase Alternative Breakdown
- This project is licensed under the terms of the MIT license.
- Repo created by ABateman, email:
gomezbateman@yahoo.com