Search packages, repositories and app categories

Package detailsv2.5.17

sqflite_common

Dart wrapper on SQLite, a self-contained, high-reliability, embedded, SQL database engine.

AndroidiOSWebmacOSWindowsLinux
30-day downloads
4.5M
Likes
76
Pub points
160

Install package

flutter pub add sqflite_common

Package Overview

Package selection guidance compiled from public package information, community data, and project usage.

sqflite_common provides a Dart wrapper for SQLite, enabling reliable, embedded SQL database operations across multiple platforms. It serves as a foundational layer for persistent data storage in Flutter applications, supporting Android, iOS, Web, macOS, Windows, and Linux. The package abstracts SQLite's complexity, offering a consistent API for database creation, querying, and management. Designed for high reliability and performance, it is ideal for apps requiring offline data handling with structured storage.

Use cases

  • Offline data persistence
  • Cross-platform local databases
  • App state management
  • Data caching
  • User-generated content storage
  • Transactional data operations

Key features

  • Platform-agnostic SQLite access
  • Consistent Dart API
  • Support for transactions
  • Asynchronous database operations
  • Lightweight and embeddable
  • Robust error handling

Suitable for

  • Flutter apps needing local SQL storage
  • Developers targeting multiple platforms
  • Apps requiring reliable offline functionality
  • Projects with structured data models
  • Teams preferring lightweight database solutions

Considerations

  • Requires additional setup for complex queries
  • Limited to SQL-based data modeling
  • Not suitable for large-scale server-like databases
  • Manual schema migration may be needed
  • Performance depends on query optimization

Original README

Original README snapshot from the linked source repository. Visit the repository for the latest content.

sqflite

pub package

SQLite plugin for Flutter. Supports iOS, Android and MacOS.

  • Support transactions and batches
  • Automatic version management during open
  • Helpers for insert/query/update/delete queries
  • DB operation executed in a background thread on iOS and Android
  • Linux/Windows/DartVM support using sqflite_common_ffi

Documentation

Categories

Dependencies

Dependency list 3 items

Source repository

Projects using this package