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

插件详情v1.3.1

drift_postgres

Drift 数据库包的 Postgres 实现和 API。

AndroidiOSmacOSWindowsLinux
近 30 天下载
1.6万
喜欢数
28
Pub 分数
130

安装插件

flutter pub add drift_postgres

插件介绍

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

drift_postgres 为 drift 包提供了一个 PostgreSQL 数据库实现,使 Flutter 应用程序能够在多个平台上与 PostgreSQL 数据库进行交互。它扩展了 drift 强大的基于 SQL 的数据访问层,以支持服务器端的 PostgreSQL 连接,允许开发者编写类型安全的查询并高效管理数据库模式。该包非常适合需要强大、可扩展的后端数据存储,并在客户端和服务器之间保持一致查询处理的应用程序。它支持所有主要的桌面和移动平台,确保跨平台兼容性。

适合场景

  • 将 Flutter 应用连接到 PostgreSQL 数据库
  • 使用 drift 构建可扩展的后端服务
  • 在本地和远程 PostgreSQL 实例之间同步数据
  • 使用服务器同步实现离线优先架构
  • 通过 PostgreSQL 启用实时数据更新
  • 在Flutter应用中管理复杂的数据库模式

主要特点

  • 使用 drift 进行类型安全的 SQL 查询
  • 跨平台支持 Android、iOS、macOS、Windows 和 Linux
  • 与 drift 的现有 API 无缝集成
  • 支持迁移和模式管理
  • 与 PostgreSQL 的高效数据同步
  • 内置连接池和事务处理

适合对象

  • 使用 PostgreSQL 后端构建 Flutter 应用的开发者
  • 实施离线优先或混合应用架构的团队
  • 需要高性能数据库操作的应用程序
  • 跨平台需要一致数据库逻辑的项目
  • 使用漂移进行数据建模的后端服务

使用建议

  • 需要运行中的 PostgreSQL 服务器
  • 身份验证和连接配置的附加设置
  • 不适合纯粹本地数据库的需求
  • 可能需要网络基础设施以实现远程访问
  • 仅限 PostgreSQL 特定功能和语法

原始 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.

所属分类

依赖

依赖清单 5 项

源码仓库

使用此插件的项目

暂无相关数据。