Traversy Media who created a Supabase crash course 👀

Hey guys, I shared out my side project on Twitter https://twitter.com/CarloMiguelDy/status/1418539062927904778 Built with supabase and Flutter!

This is a tweet about a slack clone prototype using Godot Engine and Supabase I've made in less than half an hour. I'm still updating this! https://twitter.com/fenixhub/status/1414662499325071367

I'm currently migrating a project from a django based backend to supabase. The migration is quite nice, because I can continue using Django and I'm replacing the API routes step by step. Also the Django Admin is a huge plus, but the supabase web access is sufficient for admin users to quickly check data or fix some typos or even create new data sets 🙏 Website -> https://www.eightyfourrooms.com

Hey everyone - I built and launched https://toadli.co/ on Supabase earlier this year, looking to sell it to someone interested in scaling it because I don't have time to maintain and grow it. If anyone is interested LMK!

Hey everyone! I'm building Notabase, a personal knowledge base for networked thinking, and Supabase is a key part of my stack. The fact that we both have "base" in our names is purely a coincidence 😅 Check it out here! https://notabase.io/

If it's notabase, does that make it an acid? 😉

Hey folks, I've been building Dots on top of Supabase for over 6 months and we just launched on ProductHunt! I'd appreciate any support on the launch and happy to discuss everything we've done in supabase including Auth, RLS, RPCs, and more! https://www.producthunt.com/posts/dots-7

This is cool: https://dev.to/zernonia/supabase-schema-visualizer-no-installation-login-49kg

We just released a case study on @User 's open source app (built with Flutter) https://supabase.io/blog/2021/07/27/spot-flutter-with-postgres

Thanks everyone who was involved for doing a case study of Spot 🎉

Hi guys! We're making a free webwide emoji-based username service to let you be unique on the web! Supabase is of great help to reduce our costs and provide our upcoming users with the best service!

Really liked the design, maybe add the profile button on navbar since it is hard to notice where it currently is.

Thanks a lot for the feedback, will give it a try ✨

Can I redeem this reddit clone i made a while back for 2000xp? 😄 (https://github.com/lawrencecchen/threaded-comments) (demo: https://debussy.vercel.app/)

Hi folks, I just want to share with you a little story, i'm migrating a private app from firebase to supabase, from the beginning I know supabase doesn't have functions yet and thought the migration will take longer and by then the function (workflow) will come out however, the migration process didn't take long which is awesome of course, but I had a usecase using firebase where i had a function that listens to a db insert and triggers a push notification using fcm, due to security reasons of course, the user device table is private and only accessible by`creator_id = auth.uid()` therefore I decide to go the kinda impossible undocumented way, using procedure function with triggers & pgsql-http to try out if this is possible, after few hours of try and error, I was able to figure this out and make it work. here is some code that achieved that

Trigger: 

create trigger notification_inserted
after
insert
  on notifications FOR EACH ROW EXECUTE PROCEDURE on_notification_created();

on_notification_created basically, construct some data and eventually call this method below::

create
or replace function send_push(
  push_token text,
  title text,
  body text,
  ref_id uuid,
  creator_id uuid,
  n_type text
) returns void as $$
  SELECT
  status,
  content
  FROM
    http(
      (
        'POST',
        'https://fcm.googleapis.com/fcm/send',
        ARRAY [ http_header(
          'Authorization',
          'key=myawesomekey'
        ),
        http_header('Content-Type', 'application/json') ],
        'application/json',
        (
          select
            get_fcm_body(
              push_token,
              title,
              body,
              ref_id,
              creator_id,
              n_type
            )
        )
      ) :: http_request
    );
$$ language sql;

I believe this is worth mentioning as alot of who is switching from firebase will definitely want this until workflow is implemented. happy supabase'ing.

Nice solution you have there, @Kosh. Hope anyone who wanted to use FCM with Supabase can now use this as an alternative.

and in case you wondering, here is what get_fcm_body does,

create
or replace function get_fcm_body(
  push_token text,
  title text,
  body text,
  ref_id uuid,
  creator_id uuid,
  n_type text
) returns json AS $$
declare
  notification json;
  n_data json;
begin
    notification := json_build_object(
      'title', title,
      'body', body,
      'clickAction', 'FLUTTER_NOTIFICATION_CLICK',
      'sound', 'default',
      'tag', ref_id::text
    );

    n_data := json_build_object(
      'title', title,
      'body', body,
      'type', n_type,
      'refId', ref_id,
      'creatorId', creator_id::text
    );
    
return json_build_object(
    'to', push_token,
    'notification', notification,
    'data', n_data
);
end;
$$ language plpgsql;

https://codernews.ml/supabase-an-open-source-for-you-to-make-the-future/ I made a post in CoderNews I'm a Author in it.

Full stock research dashboard built with supabase. Streaming prices with realtime!

working on a website where you can sign up and find groups for games you play :) you can subscribe to games to make them appear in your home page and sidepanel, later down the road i might make it so you can receive certain notifications for your subbed games (working on the side panel now)

Created https://checkify.io with Supabase. A super simple uptime checker for small to medium websites which can’t afford the enterprise solutions.

awesome!

thoughts on the "darkmode" and the rounded corners?

any all constructive criticism is welcome^

The public proxy for https://www.npmjs.com/package/@dhaiwat10/react-link-preview uses Supabase to cache new results & retrieve cached ones 🙂

So i build a little Discord Bot which can create Custom User Channels and its using the Postgre Database from Supbase as the Backend

I built this tool called

supabase_addons

to help Flutter devs analize their apps with Supabase. Access to visualize your data Access to get started on the package