搜索插件、代码仓与 APP 分类

插件详情v2.0.1

drift_sqflite

基于 `sqflite` 包的纯 Flutter 实现的 drift 数据库。

AndroidiOSmacOS
近 30 天下载
1.7万
喜欢数
23
Pub 分数
160

安装插件

flutter pub add drift_sqflite

插件介绍

基于插件公开信息、社区数据与项目使用情况整理的选型参考。

Drift_sqflite 是 Drift 数据库库的 Flutter 特定实现,利用 sqflite 包进行持久化 SQL 存储。它支持查询、迁移和实时更新,可实现高效且类型安全的数据库操作。专为 Android、iOS 和 macOS 设计,可无缝集成到需要本地数据持久化的 Flutter 应用中,提供强类型和编译时检查。该包通过提供简洁、直观的 API 简化了 SQLite 的使用,同时保持高性能和可靠性。

适合场景

  • 离线优先的移动应用
  • 实时数据同步
  • 本地应用数据缓存
  • Flutter 应用中的复杂查询处理
  • Flutter 中的数据库迁移

主要特点

  • 类型安全的数据库查询
  • 编译时 SQL 验证
  • 实时数据更新
  • 支持迁移
  • 通过 sqflite 实现高效的 SQLite 集成

适合对象

  • 需要本地 SQL 数据库的 Flutter 开发人员
  • 需要强大离线功能的应用程序
  • 重视代码安全性和可维护性的团队
  • 具有复杂数据模型的项目
  • 使用 sqflite 并配有增强工具的开发者

使用建议

  • 需要了解 SQL 和 Dart
  • 仅限 sqflite 支持的平台
  • 由于生成的代码,应用大小可能会增加
  • 不适用于基于云或服务器端的数据库
  • 依赖漂移的生态系统以实现完整功能

原始 README

以下为关联源码仓库的 README 原文快照,最新内容请访问源码仓库。

Drift

Build Status Using melos

Core Generator
Main version Generator version

Drift is a reactive persistence library for Flutter and Dart, built on top of SQLite. Drift is:

  • Flexible: Drift lets you write queries in both SQL and Dart, providing fluent apis for both languages. You can filter and order results or use joins to run queries on multiple tables. You can even use complex SQL features like WITH and WINDOW clauses.
  • 🔥 Feature rich: Drift has builtin support for transactions, schema migrations, complex filters and expressions, batched updates and joins. We even have a builtin IDE for SQL!
  • 📦 Modular: Thanks to builtin support for daos and imports in SQL files, drift helps you keep your database code simple.
  • 🛡️ Safe: Drift generates type-safe code based on your tables and queries. If you make a mistake in your queries, drift will find it at compile time and provide helpful and descriptive lints.
  • ⚡ Fast: Even though drift lets you write powerful queries, it can keep up with the performance of key-value stores like shared preferences and Hive. Drift is the only major persistence library with builtin threading support, allowing you to run database code across isolates with zero additional effort.
  • Reactive: Turn any SQL query into an auto-updating stream! This includes complex queries across many tables.
  • ⚙️ Cross-Platform support: Drift works on Android, iOS, macOS, Windows, Linux and the web. This template is a Flutter todo app that works on all platforms.
  • 🗡️ Battle tested and production ready: Drift is stable and well tested with a wide range of unit and integration tests. It powers production Flutter apps.

With drift, persistence on Flutter is fun!

To start using drift, read our detailed docs.

If you have any questions, feedback or ideas, feel free to create an issue. If you enjoy this project, I'd appreciate your 🌟 on GitHub.

Sponsors

Drift is proudly Sponsored by Stream 💙 and PowerSync.


Try the Flutter Chat Tutorial  💬

Try PowerSync with Supabase

Working on this project

This repository contains a number of packages making up the drift project, most notably:

  • drift: The main runtime for drift, which provides most APIs.
  • drift_dev: The compiler for drift tables, databases and daos. It also contains a fully-featured SQL IDE for the Dart analyzer.
  • sqlparser: A SQL parser and static analyzer, written in pure Dart. This package can be used without drift to perform analysis on SQL statements. It's on pub at sqlparser.

We use melos to manage the different packages in this repository.

You can install it with dart pub global activate melos. To activate it in this repository, run dart pub get in this directory followed by melos bootstrap.

所属分类

依赖

依赖清单 3 项

源码仓库

使用此插件的项目

暂无相关数据。