Featured

insforge-schema-patterns

Name: insforge-schema-patterns
Rating: 5 (919 reviews)
Author: InsForge

Database schema patterns for InsForge including social graphs, e-commerce, content publishing, and multi-tenancy with RLS policies. Use when designing data models with relationships, foreign keys, or Row Level Security.

TL;DR

Schema patterns for social features and multi-tenancy in InsForge with RLS.

What Is It

Social graph for follows with unique constraints
Likes table for many-to-many content interactions
Nested comments with self-referential structure
Multi-tenant data with organization scoping

Key Features

Unique constraints on follower/following pairs
RLS policies for user-based access control
Indexes for fast follow/like/comment lookups
Self-referential comments for nested replies
Organization-scoped data per tenant
Foreign key relationships with ON DELETE CASCADE
User-specific CRUD policies via RLS
Supports social and content features

How to Use

1.Use for social features like follows, likes, comments
2.Apply RLS policies to enforce user ownership
3.Use joins with inner references in queries
4.Ensure unique constraints on user-content pairs

Guardrails & Gotchas

FORBIDDEN: Allow users to follow themselves
MUST: Enforce unique (follower_id, following_id) pairs
MUST: Use RLS to restrict data access by user
MUST: Validate user ownership in insert/delete policies

GitHub Stats

Author

@InsForge

Repository

InsForge/InsForge

Stars

919

Explore More Skills

move-code-quality

@davila7

Analyzes Move language packages against the official Move Book Code Quality Checklist. Use this skill when reviewing Move code, checking Move 2024 Edition compliance, or analyzing Move packages for best practices. Activates automatically when working with .move files or Move.toml manifests.

12.4k

1.1k

1w ago

insforge-schema-patterns

Explore More Skills

move-code-quality

e2e-testing-patterns

testing-anti-patterns