Search packages, repositories and app categories

Package detailsv2.4.6

sqflite

Flutter plugin for SQLite, a self-contained, high-reliability, embedded, SQL database engine.

AndroidiOSmacOS
30-day downloads
3.5M
Likes
5.6K
Pub points
160

Install package

flutter pub add sqflite

Package Overview

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

Sqflite is a Flutter plugin that provides access to SQLite, a lightweight, embedded SQL database engine. It enables local data storage with full SQL support on Android, iOS, and macOS. Designed for reliability and performance, it allows developers to manage structured data efficiently within apps. The package supports asynchronous operations and integrates seamlessly with Dart’s async/await syntax. Ideal for offline-first applications requiring persistent, relational data storage.

Use cases

  • Offline data persistence
  • Local caching of app data
  • Database-backed forms and lists
  • Storing user preferences
  • Managing complex data relationships

Key features

  • Full SQL support
  • Cross-platform compatibility
  • Asynchronous operations
  • Lightweight and embedded
  • Supports transactions

Suitable for

  • Apps needing offline functionality
  • Data-heavy applications
  • Simple to moderate database needs
  • Developers familiar with SQL
  • Projects requiring local storage

Considerations

  • Not suitable for large-scale databases
  • Manual schema management required
  • Limited real-time sync capabilities
  • No built-in migration tools
  • Requires careful handling of database versioning

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 5 items

  • path>=1.8.0 <3.0.0
  • sqflite_android>=2.4.6 <4.0.0
  • sqflite_common>=2.5.17 <4.0.0
  • sqflite_darwin>=2.4.6 <4.0.0
  • sqflite_platform_interface>=2.4.4 <4.0.0

Source repository

Projects using this package

Rankings