Made with Supabase ⚡
- ✨ Curated list of projects
- ? Show the world your creation using Supabase
- ? Search by tags, for Supabase service
- ? Hackathon submission (during event period)
? About The Project
As the name suggest, this project is a collection of projects that made with Supabase! It was heavily inspired by other “Made with xxx” website, and I wanted to curate all the submission for the first ever Supabase Hackathon initially.
Also, I thought that this would be a great opportunity to use Supabase Database and Storage to showcase Supabase!
Therefore, Made with Supabase is also, made with Supabase ⚡!
It turns out that this project gained a lot of attention from Supabase users, as well as not-yet Supabase user ?. It grew from 10+ projects to 100+ now! Supa awesome!!! ? I believe it has potential to grow, thus I’ve decided to Open Source it, and welcome your contributions!
? Built With
? Supabase Schema/Script
create table products ( id uuid default uuid_generate_v4() primary key, title text, email text, description text, categories ARRAY, url text, github_url text, twitter text, instagram text, images ARRAY, slug text, supabase_features ARRAY, approved boolean, created_at timestamp default now() ); -- enable RLS alter table products enable row level security;
create table views ( id uuid default uuid_generate_v4() primary key, created_at timestamp default now(), ip_address text, product_id uuid references products (id) on delete cascade ); -- enable RLS alter table views enable row level security;
select products.id, products.title, products.description, products.categories, products.url, products.github_url, products.twitter, products.instagram, products.images, products.slug, products.supabase_features, products.approved, products.created_at, count(views.id) as views from products left join views on products.id = views.product_id where products.approved = true group by products.id;
select s.tags, count(*) as count from ( select unnest(products.categories) as tags from products where products.approved = true) s group by s.tags;
create or replace function public.get_related_products(parent_id uuid) returns setof products_view language plpgsql as $$ begin return query select * from products_view where id <> parent_id order by random(); end; $$
create or replace function public.get_tags(tag text) returns setof products_view language plpgsql as $$ begin return query select * from products_view where tag % any(categories); end; $$
create or replace function public.get_supabase_tags(tag text) returns setof products_view language plpgsql as $$ begin return query select * from products_view where tag like any(supabase_features); end; $$
? Local Development
npm install --global yarn
- Clone the repo
git clone https://github.com/zernonia/madewithsupabase.git
- Install NPM packages
- Setup your Supabase environment
SUPABASE_URL=<SUPABASE_URL> SUPABASE_KEY=<SUPABASE_KEY> SUPABASE_SERVICE=<SUPABASE_SERVICE_KEY>
- Run Development instance
This project is just for fun, but if you have any crazy idea for Realtime function, feel free to contribute, or create request for the features. Any contributions you make are greatly appreciated.
- Fork the Project
- Create your Feature Branch (
git checkout -b feature/AmazingFeature)
- Commit your Changes (
git commit -m 'Add some AmazingFeature')
- Push to the Branch (
git push origin feature/AmazingFeature)
- Open a Pull Request
Not Associated with Supabase.
Distributed under the MIT License. See
LICENSE for more information.
Zernonia – @zernonia
If you like my work, please buy me a coffee ?