تشغيل أي مهارة في Manus بنقرة واحدة

flutter-db

النجوم٦

التفرعات٢

آخر تحديث٣١ مارس ٢٠٢٦ في ١٢:٤١

Local database and persistence selection for Flutter including SharedPreferences, SecureStorage, Hive, and Drift. Use when implementing offline storage, encrypted data persistence, or choosing between key-value and relational local databases.

التثبيت

التثبيت باستخدام Codex أو Claude انسخ هذا Prompt والصقه في Codex أو Claude أو مساعد آخر ليراجع صفحة Skill ويثبّتها لك.

تشغيل في Manus

المصدر

Poorgramer-Zack

Poorgramer-Zack/dart-expert-skills

فتح مستودع GitHub عرض مستودعات المنشئ

تنزيل

تشغيل في Manus

المهن ذات الصلةSOC

استنادا إلى تصنيف SOC المهني

مطوّرو البرمجياتمهن الحاسوب والرياضيات·SOC 15-1252

مستكشف الملفات

6 ملفات

SKILL.md

readonly

name	flutter-db
description	Local database and persistence selection for Flutter including SharedPreferences, SecureStorage, Hive, and Drift. Use when implementing offline storage, encrypted data persistence, or choosing between key-value and relational local databases.
metadata	{"last_modified":"2026-03-12 11:18:17 (GMT+8)"}

Database Architecture Guide (Flutter)

Goal

Implement robust, scalable, and secure local persistence strategies for Flutter applications. This skill ensures developers choose the optimal storage engine—balancing simple key-value settings, encrypted sensitive data, high-performance NoSQL object stores, and complex relational databases.

Process

🚀 High-Level Workflow

Selecting the right persistence layer depends on data sensitivity, complexity, and relationship depth.

Phase 1: Key-Value Persistence (Simple & Secure)

Use lightweight stores for settings and sensitive credentials.

Shared Preferences Guide - Non-sensitive settings and flags using static wrappers.
Secure Storage Guide - Encrypted storage for tokens and passwords.

Phase 2: High-Performance Object Storage (NoSQL)

For local-first apps requiring fast read/write of large datasets without complex relations.

Hive CE (Synchronous NoSQL) - Blazing fast object store for local caching and offline data.

Phase 3: Complex Relational Schemas (SQL)

For apps requiring strict data integrity, transactions, and complex queries.

Drift (Reactive SQL) - Type-safe relational database built on top of SQLite.

📚 Documentation Library

Refer to these specialized resources to implement your chosen persistence strategy:

Constraints

Type Safety: Prohibit raw dynamic data access. Always use generated classes (Drift) or typed static wrappers (SharedPreferences/SecureStorage).
Sensitivity Awareness: Force use of Secure Storage for any tokens, passwords, or PII. Never store sensitive data in SharedPreferences or unencrypted Hive boxes.
Singleton Access: Access storage instances via DI (Riverpod) or strictly defined static classes to prevent key fragmentation.
Performance Balance: Use NoSQL (Hive) for high-frequency reads and SQL (Drift) for complex relationships. Don't over-engineer simple apps with SQL.

المزيد من هذا المستودع

نفس المستودع

routing-with-autoroute

Poorgramer-Zack/dart-expert-skills

Implements type-safe Flutter routing using AutoRoute v11 with code generation and @RoutePage annotations. Activates when setting up AutoRoute navigation, configuring AutoRouterConfig or RootStackRouter, generating route files with build_runner, using @RoutePage, @PathParam, or @QueryParam annotations, implementing AutoTabsRouter for bottom navigation tabs, adding navigation guards with AutoRouteGuard, setting up nested or child routes, handling type-safe route parameters, or migrating from string-based Navigator routing to compile-time-verified routes. Ideal for large apps requiring refactoring confidence and zero string-based routing errors.

2026-04-276

implementing-flutter-bloc

Poorgramer-Zack/dart-expert-skills

Implements BLoC (v9.x) event-driven state management for Flutter with unidirectional data flow using the flutter_bloc package. Use when implementing Bloc/Cubit classes, mapping Events to States, consuming state with BlocBuilder/BlocListener/BlocConsumer, applying event transformers (restartable/droppable/sequential) for concurrency control, setting up BlocProvider/MultiBlocProvider DI, integrating Freezed for sealed union types and exhaustive pattern matching, or testing with blocTest. Ideal for enterprise apps requiring business logic separation, precise concurrency control (search debouncing, form deduplication), or event replay debugging.

2026-04-276

persisting-data-with-drift

Poorgramer-Zack/dart-expert-skills

Implements type-safe reactive SQL persistence in Flutter using Drift v2.32 (formerly Moor) built on SQLite with automatic code generation. Activates when defining table schemas with Drift DSL, writing type-safe join or subquery operations, handling schema migrations with MigrationStrategy, using reactive watch() streams for live UI updates, implementing ACID transactions, defining foreign key constraints or cascade deletes, enabling WAL mode for write performance, troubleshooting generated .g.dart type mismatches, migrating from sqflite or sqlite3 v2 to v3, using DAOs for query separation, or building offline-first apps requiring strong relational data integrity and compile-time SQL verification.

2026-04-276

routing-with-gorouter

Poorgramer-Zack/dart-expert-skills

Implements declarative Flutter routing using GoRouter v17 with URL-based navigation, deep linking, and authentication guards. Activates when configuring GoRoute path patterns, setting up StatefulShellRoute for persistent bottom navigation state, implementing ShellRoute for shared nested layouts, adding redirect guards with loop prevention (idempotent redirects), configuring deep links for iOS (FlutterDeepLinkingEnabled) or Android (intent-filters), debugging redirect loops or navigation stack issues, handling 404 error routes with errorBuilder, using named routes with path/query/extra parameters, or migrating from imperative Navigator.push to declarative routing. Ideal for Flutter web apps requiring URL bar synchronization, mobile apps with universal links or app links, or multi-level navigation hierarchies.

2026-04-276

managing-hive-storage

Poorgramer-Zack/dart-expert-skills

Hive CE (Community Edition v2.19.x) NoSQL object database for Flutter providing blazing-fast key-value and object storage with TypeAdapters. Use this skill when implementing offline-first architecture, high-performance local data caching, NoSQL document-style object stores, custom TypeAdapter serialization for complex objects, lazy loading boxes for memory efficiency, encrypted boxes (HiveAES encryption), database compaction for size optimization, storing large datasets without SQL schema overhead, implementing local-first sync patterns, or migrating from SQLite to NoSQL. Supports primitive types, custom objects, lists, and maps. Ideal for apps requiring ultra-fast read/write operations (microsecond latency), object persistence without ORM complexity, or local-first data architecture.

2026-04-276

implementing-riverpod

Poorgramer-Zack/dart-expert-skills

Implements Riverpod (v3.3.x) compile-safe state management for Flutter apps. Use when implementing @riverpod code generation providers, handling AsyncValue loading/error/data states, using ref.watch/ref.read/ref.listen, setting up ProviderScope, writing Notifier/AsyncNotifier classes, using FutureProvider/StreamProvider, applying autoDispose and family modifiers, combining providers, testing providers in isolation, scoping rebuilds with Consumer instead of ConsumerWidget, using ref.watch with select() for field-level precision, migrating from StateNotifierProvider or Riverpod 2.x patterns, handling Notifier resource lifecycle with ref.onDispose, or using experimental Mutation and offline persistence APIs.

2026-04-276

name	flutter-db
description	Local database and persistence selection for Flutter including SharedPreferences, SecureStorage, Hive, and Drift. Use when implementing offline storage, encrypted data persistence, or choosing between key-value and relational local databases.
metadata	{"last_modified":"2026-03-12 11:18:17 (GMT+8)"}

Database Architecture Guide (Flutter)

Goal

Process

🚀 High-Level Workflow

Selecting the right persistence layer depends on data sensitivity, complexity, and relationship depth.

Phase 1: Key-Value Persistence (Simple & Secure)

Use lightweight stores for settings and sensitive credentials.

Shared Preferences Guide - Non-sensitive settings and flags using static wrappers.
Secure Storage Guide - Encrypted storage for tokens and passwords.

Phase 2: High-Performance Object Storage (NoSQL)

For local-first apps requiring fast read/write of large datasets without complex relations.

Hive CE (Synchronous NoSQL) - Blazing fast object store for local caching and offline data.

Phase 3: Complex Relational Schemas (SQL)

For apps requiring strict data integrity, transactions, and complex queries.

Drift (Reactive SQL) - Type-safe relational database built on top of SQLite.

📚 Documentation Library

Refer to these specialized resources to implement your chosen persistence strategy:

Constraints

Type Safety: Prohibit raw dynamic data access. Always use generated classes (Drift) or typed static wrappers (SharedPreferences/SecureStorage).
Sensitivity Awareness: Force use of Secure Storage for any tokens, passwords, or PII. Never store sensitive data in SharedPreferences or unencrypted Hive boxes.
Singleton Access: Access storage instances via DI (Riverpod) or strictly defined static classes to prevent key fragmentation.
Performance Balance: Use NoSQL (Hive) for high-frequency reads and SQL (Drift) for complex relationships. Don't over-engineer simple apps with SQL.