Overview
Floor is a typesafe, reactive, and lightweight SQLite abstraction designed for Flutter applications. It provides a clean, compile-time safe way to interact with SQLite databases by using annotations and code generation. Floor simplifies database operations with easy-to-use DAOs (Data Access Objects) and supports reactive queries through streams. Built for performance and developer experience, it integrates seamlessly into Flutter projects without requiring manual SQL writing. The library ensures type safety and reduces runtime errors by validating database schemas at compile time.
Use cases
- Offline data storage in mobile apps
- Real-time data synchronization with local database
- Managing structured app data like user profiles or settings
- Building offline-first applications
- Storing cached API responses
- Tracking user activity logs
Key features
- Typesafe database schema definitions
- Reactive queries via streams
- Code generation for DAOs
- Compile-time validation of database structure
- Lightweight and fast performance
- Easy integration with Flutter's state management
Suitable for
- Developers building offline-capable Flutter apps
- Teams prioritizing type safety and maintainability
- Projects requiring efficient local data persistence
- Apps needing real-time updates from local data
- Flutter developers seeking minimal boilerplate
Considerations
- Requires code generation setup
- Limited to SQLite as the underlying database
- No built-in support for complex joins or raw SQL
- Migration handling requires careful planning
- Not suitable for large-scale server-side databases