tinbase/tinbase
Tinbase
Tinbase is a portable backend emulator designed to mirror cloud-hosted service interfaces for local development. It provides a single-binary environment that simulates database, authentication, and storage services, allowing developers to test applications using standard client libraries without requiring containerized infrastructure or external network dependencies.
The project distinguishes itself by embedding a full-featured relational database engine and a security policy enforcement layer directly within the application runtime. By intercepting and translating standard backend requests, it maintains parity with cloud-hosted environments, including the ability to execute server-side logic, manage schema migrations, and enforce row-level security policies locally.
The platform includes a comprehensive suite of tools for managing the development lifecycle, such as real-time event streaming, background task scheduling, and an administrative dashboard for database management. It also incorporates features for data privacy and compliance, including automated retention policies, user erasure management, and system audit logging.
Features
- Local Emulation Environments - Simulates cloud-based backend services locally to test database, authentication, and storage logic without external dependencies.
- Local Development Environments - Provides a local development environment that simulates cloud-hosted backend services without requiring containerized infrastructure.
- Schema-Managed Querying - Executes SQL queries, manages schema migrations, and enforces row-level security policies within a portable environment.
- Database Query Interfaces - Enables standard create, read, update, and delete operations on data using query parameters for filtering and aggregation.
- Local Database Development Tools - Ships a portable database server supporting SQL migrations and real-time streaming for rapid local prototyping.
- Embedded Database Engines - Embeds a full-featured relational database engine directly within the application process to eliminate external infrastructure requirements.
- Backend Service Emulators - Emulates a full suite of cloud backend services in a single binary to eliminate external network dependencies.
- Row-Level Security - Enforces database-level access policies by injecting authenticated user contexts directly into query execution.
- API Compatibility Layers - Intercepts and translates standard backend requests into local database operations to maintain parity with cloud-hosted service interfaces.
- Database Execution Engines - Runs database operations using native, WebAssembly, or in-memory engines to support local development and portable deployment.
- Database Schema Migrations - Applies SQL migrations and seed files using standard conventions to ensure local database structures remain portable.
- Backend Compatibility Layers - Provides a compatibility layer that mirrors cloud-hosted backend interfaces for standard client library testing.
- Real-time Data Synchronization - Streams database events to clients and supports private channels with authorization to enable reactive application features.
- Local Function Execution - Runs server-side code locally by resolving dependencies and providing environment variables to ensure consistent behavior.
- Embedded - Provides a full-featured database backend directly within local environments to enable development without external network dependencies.
- In-Process Task Schedulers - Executes background jobs and cron tasks within the application runtime to handle asynchronous workflows without external message brokers.
- Real-Time Database Streaming via WebSockets - Broadcasts database changes and presence updates to connected clients in real-time using standard WebSocket protocols.
- User Authentication Flows - Manages user identity verification, multi-factor authentication, and session state locally.
- Database Schema Migrations - Automates database versioning and state synchronization by applying SQL scripts and generating type definitions.
- Compatibility Endpoints - Provides standard API endpoints for authentication, storage, and data access that mirror cloud-hosted backend interfaces.
- Real-time Sync Engines - Broadcasts database changes and presence updates over WebSockets to build reactive features that sync instantly across clients.
