Launch your community platform with Supabase and Once UI in 15 minutes

Launch now

View demo

No algorithm between you and your community

What people post is what others see. No invisible ranking. No engagement farming. Just signal, not manipulation.

Read docs

Your platform. Not rented reach.

Own the rules, the data, and the direction. Shape the culture intentionally instead of adapting to someone else’s roadmap.

Built to evolve with you

Multiple post formats, adaptable layouts, and a feed that grows with your use case — from tight-knit groups to expanding ecosystems.

Auth

Secure, extensible sign-in powered by Supabase. Your users, your database, your control.

Profile

Customizable profiles designed for clarity — not vanity metrics. Highlight what matters to your community.

Followers

Follow, connect, and build networks without algorithmic interference shaping visibility.

Participation

Define roles that reflect real responsibility. Admins, moderators, contributors — clearly scoped and assigned.

Health

Built-in moderation tools that scale with growth, so culture doesn’t erode as participation increases.

Recognition

Surface meaningful contributions, not just noise. Reward consistency, depth, and impact.

CREATE OR REPLACE FUNCTION hub_new_follower_notify()
RETURNS TRIGGER LANGUAGE plpgsql AS $$
DECLARE
  v_follower_username text;
  v_follower_slug text;
  v_notification_id uuid;
BEGIN
  SELECT p.username, p.slug INTO v_follower_username, v_follower_slug
  FROM profiles p WHERE p.id = NEW.follower_id;

  INSERT INTO hub_notifications(type, actor_id, resource_type, resource_id, context)
  VALUES (
    'new_follower',
    NEW.follower_id,
    'profile',
    NEW.following_id,
    jsonb_build_object(
      'follower_id', NEW.follower_id,
      'follower_username', v_follower_username,
      'follower_slug', v_follower_slug
    )
  ) RETURNING id INTO v_notification_id;

  INSERT INTO hub_notification_recipients(notification_id, user_id, delivered_at)
  SELECT v_notification_id, NEW.following_id, now()
  FROM (
    SELECT coalesce(us.allow_in_app, true) AS allow_in_app
    FROM hub_user_notification_settings us