> ## Documentation Index
> Fetch the complete documentation index at: https://docs.weventures.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# BaaS & Databases

> Backend-as-a-Service platforms and database solutions

## Backend as a Service (BaaS)

<Tabs>
  <Tab title="Supabase">
    ### Supabase

    **Open-source Firebase alternative built on PostgreSQL**

    Complete backend platform with auth, database, storage, edge functions, and real-time subscriptions.

    **Best for:**

    * SQL-first applications with complex queries
    * Open-source projects avoiding vendor lock-in
    * Real-time features with PostgreSQL power
    * Row-Level Security requirements

    **Key Features:**

    * PostgreSQL database with auto-generated REST & GraphQL APIs
    * Built-in auth with JWT + social logins
    * Real-time subscriptions via PostgreSQL CDC
    * Edge Functions (Deno runtime)
    * Storage with CDN

    **Pricing:** Free tier (500MB DB, 2GB bandwidth, 100K MAU) • \$0.00325/MAU beyond free tier

    [Documentation](https://supabase.com/docs) • [Get Started](https://supabase.com)
  </Tab>

  <Tab title="Firebase">
    ### Firebase

    **Google's comprehensive app development platform**

    Fully-managed BaaS with NoSQL database, auth, hosting, functions, and deep Google ecosystem integration.

    **Best for:**

    * Mobile-first applications (iOS/Android)
    * Real-time collaborative features
    * Rapid MVP development
    * Google Cloud ecosystem integration

    **Key Features:**

    * Firestore (NoSQL document database)
    * Firebase Authentication
    * Cloud Functions
    * Realtime Database
    * Analytics & Crashlytics

    **Pricing:** Pay-as-you-go (reads/writes/deletes) • Costs can be unpredictable at scale

    [Documentation](https://firebase.google.com/docs) • [Get Started](https://firebase.google.com)
  </Tab>

  <Tab title="Appwrite">
    ### Appwrite

    **Self-hosted backend server for web, mobile & flutter**

    Open-source BaaS with 30+ SDKs, built-in auth, database, storage, and functions.

    **Best for:**

    * Self-hosted requirements
    * Multi-platform apps
    * Complete data ownership
    * Privacy-focused applications

    **Pricing:** Free (self-hosted) • Cloud: \$15/month

    [Documentation](https://appwrite.io/docs) • [Get Started](https://appwrite.io)
  </Tab>

  <Tab title="PocketBase">
    ### PocketBase

    **Single-file backend in Go**

    Ultra-lightweight BaaS with SQLite, auth, and real-time. Perfect for side projects.

    **Best for:**

    * Side projects and MVPs
    * Embedded/edge deployments
    * Minimal infrastructure needs

    **Pricing:** 100% free & open-source

    [Documentation](https://pocketbase.io/docs) • [Get Started](https://pocketbase.io)
  </Tab>

  <Tab title="Convex">
    ### Convex

    **Backend application platform with reactive database**

    TypeScript-first backend with reactive queries, actions, and scheduled functions.

    **Best for:**

    * TypeScript-heavy projects
    * Real-time collaborative apps
    * Serverless architectures

    **Pricing:** Free (2GB storage, 1M function calls/month)

    [Documentation](https://docs.convex.dev) • [Get Started](https://convex.dev)
  </Tab>
</Tabs>

## SQL Databases

<CardGroup cols={2}>
  <Card title="PostgreSQL" icon="database">
    **Most advanced open-source database**

    ACID-compliant, powerful querying, extensions (pgvector for embeddings).

    * Free & open-source
    * Extensions ecosystem
    * Production-ready
    * Used by Supabase, Neon, etc.

    [Website](https://postgresql.org)
  </Card>

  <Card title="Neon" icon="bolt">
    **Serverless PostgreSQL**

    Auto-scaling, branching, generous free tier. Instant databases.

    * Free: 0.5GB storage
    * Database branching
    * Serverless architecture
    * Fast cold starts

    [Website](https://neon.tech)
  </Card>

  <Card title="PlanetScale" icon="planet">
    **MySQL-compatible serverless database**

    Branching workflows, horizontal scaling, Vitess-powered.

    * Database branching
    * Horizontal scaling
    * MySQL compatible
    * Free tier available

    [Website](https://planetscale.com)
  </Card>

  <Card title="MySQL" icon="database">
    **World's most popular open-source database**

    Fast, reliable, used by Facebook, Twitter, YouTube.

    * Free & open-source
    * Widely adopted
    * Fast performance
    * Large ecosystem

    [Website](https://mysql.com)
  </Card>
</CardGroup>

## NoSQL Databases

<CardGroup cols={2}>
  <Card title="MongoDB" icon="leaf">
    **Document-based NoSQL database**

    Flexible schemas, horizontal scaling, cloud-native (Atlas).

    * Document database
    * Atlas (managed service)
    * Powerful queries
    * Flexible schema

    [Website](https://mongodb.com)
  </Card>

  <Card title="Redis" icon="bolt">
    **In-memory data structure store**

    Caching, pub/sub, session storage. Sub-millisecond latency.

    * In-memory speed
    * Ultra-fast reads/writes
    * Pub/Sub messaging
    * Caching layer

    [Website](https://redis.io)
  </Card>

  <Card title="DynamoDB" icon="aws">
    **AWS fully managed NoSQL**

    Serverless, single-digit millisecond latency at any scale.

    * AWS ecosystem
    * Auto-scaling
    * Serverless
    * Single-digit ms latency

    [Website](https://aws.amazon.com/dynamodb)
  </Card>
</CardGroup>

## ORMs & Query Builders

<CardGroup cols={2}>
  <Card title="Prisma" icon="crystal-ball">
    **Next-generation TypeScript ORM**

    Type-safe database client, schema migrations, great DX.

    * TypeScript-first
    * Type-safe queries
    * Multiple databases
    * Auto-generated client

    [Website](https://prisma.io)
  </Card>

  <Card title="Drizzle ORM" icon="droplet">
    **Lightweight TypeScript ORM**

    SQL-like syntax, zero overhead, edge-ready. Faster than Prisma.

    * Lightweight & fast
    * TypeScript support
    * Edge-compatible
    * SQL-like syntax

    [Website](https://orm.drizzle.team)
  </Card>
</CardGroup>

## Comparison: BaaS Platforms

| Feature       | Supabase              | Firebase               | Convex            | PocketBase       |
| ------------- | --------------------- | ---------------------- | ----------------- | ---------------- |
| **Database**  | PostgreSQL (SQL)      | Firestore (NoSQL)      | Reactive DB       | SQLite           |
| **Auth**      | JWT + RLS             | Firebase Auth          | Built-in          | Built-in         |
| **Real-time** | PostgreSQL CDC        | Firestore sync         | Reactive          | Built-in         |
| **Pricing**   | \$0.00325/MAU         | Pay-per-operation      | \$0/month starter | Free (self-host) |
| **Self-host** | ✅ Yes                 | ❌ No                   | ❌ No              | ✅ Yes            |
| **Best for**  | SQL apps, open-source | Mobile apps, rapid MVP | TypeScript apps   | Side projects    |

## Decision Guide

<Steps>
  <Step title="Need SQL and open-source?">
    Choose **Supabase** for PostgreSQL power with modern DX
  </Step>

  <Step title="Building a mobile app?">
    Choose **Firebase** for best mobile integration
  </Step>

  <Step title="Want minimal infrastructure?">
    Choose **PocketBase** for single-file deployment
  </Step>

  <Step title="TypeScript-first with reactivity?">
    Choose **Convex** for type-safe reactive backend
  </Step>

  <Step title="Need custom API control?">
    Skip BaaS, use **FastAPI** or **NestJS** with your own database
  </Step>
</Steps>