Alternatives to Appwrite

Self-hosted alternatives to Appwrite

Open source projects that can replace Appwrite:

Supabase

84,090

Apache-2.0

Supabase is a powerful open-source alternative to Firebase that provides a complete backend-as-a-service platform built on PostgreSQL. It combines the reliability and features of PostgreSQL with modern developer tools, real-time capabilities, and a comprehensive suite of backend services, making it ideal for building full-stack applications.

Key Features

PostgreSQL Database:
- Full PostgreSQL database with all advanced features
- Auto-generated REST APIs from database schema
- GraphQL support through pg_graphql extension
- Row Level Security (RLS) for fine-grained access control
- Database functions and triggers
- Full-text search capabilities
Authentication & Authorization:
- Built-in user management system
- Social OAuth providers (Google, GitHub, Discord, etc.)
- Magic link authentication
- Multi-factor authentication (MFA)
- JWT token-based authentication
- Row Level Security integration
Real-time Capabilities:
- Real-time database change subscriptions
- Presence tracking for collaborative features
- Broadcast messaging between clients
- WebSocket-based connections
- Channel management and filtering
- Conflict-free replicated data types (CRDTs)
File Storage:
- S3-compatible object storage
- Image transformations and optimization
- CDN integration for global delivery
- Access policies and permissions
- Resumable file uploads
- Automatic backup and versioning
Edge Functions:
- Serverless TypeScript/JavaScript functions
- Global edge deployment
- Custom API endpoints
- Database triggers and webhooks
- Third-party integrations
- Scheduled functions
Developer Experience:
- Intuitive web dashboard
- Built-in SQL editor with autocomplete
- Auto-generated API documentation
- Comprehensive CLI tools
- Client libraries for multiple platforms
- Local development environment
Enterprise Features:
- Single sign-on (SSO) integration
- Advanced security features
- Audit logging and compliance
- Custom domains and SSL
- Priority support
- SLA guarantees

Technical Specifications

Database: PostgreSQL with extensions
API Layer: PostgREST for auto-generated APIs
Authentication: GoTrue auth server
Real-time: Custom WebSocket server
Storage: S3-compatible object storage
Functions: Deno runtime for edge functions
Deployment: Docker Compose, Kubernetes

Use Cases

Web Applications: Full-stack web apps with real-time features
Mobile Applications: Backend for iOS and Android apps
SaaS Products: Multi-tenant software-as-a-service platforms
Real-time Apps: Chat applications, collaborative tools
E-commerce: Online stores with inventory management
Content Management: Blogs, portfolios, and media platforms

Unique Advantages

PostgreSQL Power: Full SQL database with advanced features
Open Source: Transparent, customizable, and community-driven
Real-time First: Built-in real-time capabilities across all services
Developer Friendly: Excellent tooling and documentation
Firebase Compatible: Easy migration path from Firebase
Self-Hosted: Complete control over data and infrastructure

PocketBase

47,670

MIT

PocketBase is a revolutionary backend solution that packages everything you need for your next SaaS or mobile application into a single executable file. Built with Go and SQLite, it provides database management, user authentication, file storage, and an admin dashboard without the complexity of traditional backend setups.

Key Features

Single File Backend:
- Complete backend in one executable file
- Built-in web server and database
- No external dependencies required
- Easy deployment and distribution
- Portable across platforms
- Minimal resource requirements
Database Management:
- SQLite database with real-time capabilities
- Visual schema builder and editor
- Automatic API generation from schema
- Data relationships and constraints
- Built-in data validation
- Database migrations and backups
Authentication System:
- Built-in user management
- Email/password authentication
- OAuth provider integration (Google, GitHub, etc.)
- JWT token-based authentication
- Role-based access control
- Password reset and email verification
File Storage & Management:
- File upload and download APIs
- Automatic image resizing and optimization
- File type validation and restrictions
- Multiple storage backend support
- CDN integration capabilities
- Thumbnail generation
Admin Dashboard:
- Web-based administration interface
- Visual data management tools
- User and permission management
- Real-time logs and analytics
- Settings and configuration panel
- Database schema editor
Real-time Capabilities:
- WebSocket-based real-time subscriptions
- Live data updates
- Real-time collection changes
- Event-driven architecture
- Custom event handling
- Presence detection
Developer Experience:
- Auto-generated REST APIs
- Client SDKs for multiple platforms
- Hot reload during development
- Custom JavaScript hooks
- Middleware support
- Comprehensive documentation