This directory contains comprehensive examples demonstrating SQLite Sync in various environments and use cases. Each example showcases offline-first data synchronization across multiple devices using SQLite AI's sync capabilities.
Basic CLI Example - Getting Started
- Command-line demonstration using SQLite CLI
- Shows fundamental SQLite Sync concepts and workflow
- Multi-device collaborative editing with conflict resolution
- Offline scenarios and network synchronization
- Perfect for understanding core sync mechanics
Advanced Web App - Production Patterns
- React/TypeScript web application with Vite
- Demonstrates secure authentication with Access Tokens
- Row-Level Security (RLS) implementation for data isolation
- Multi-user scenarios (athletes and coaches)
- WASM SQLite with sync extension
- Production-ready security patterns
Swift iOS/macOS Integration
- Cross-platform Swift app for iOS and macOS
- CloudSync XCFramework integration guide
- Native mobile and desktop sync capabilities
- Xcode project setup and security configuration
React Native/Expo Mobile App
- Cross-platform mobile app (iOS/Android)
- Expo framework with SQLite sync
- Simple task management with categories
- Offline-first mobile development patterns
- Note: Uses basic connection strings for demo purposes only
- Begin with:
simple-todo-db/for core concepts - Production web apps: Use
sport-tracker-app/patterns - Native mobile: Choose
swift-multiplatform-app/orto-do-app/
Each example includes detailed setup instructions, code explanations, and security considerations. See the individual README files for specific implementation details.
Note: For generic extension loading guides please refer to the SQLite Extension Guide repository