Why is the DatabaseService registered as a singleton?

SQLiteAsyncConnection is not thread-safe for multiple instances. A singleton ensures a single connection instance manages concurrent reads and writes safely using WAL mode.

Which SQLite package does this skill use?

It specifically utilizes the sqlite-net-pcl package by praeclarum, which is the industry standard for .NET mobile apps, along with the SQLitePCLRaw.bundle_green dependency.

How are database file paths handled across different mobile platforms?

The skill uses the Maui.Storage.FileSystem.AppDataDirectory property to ensure the database file is automatically placed in the correct platform-specific sandbox folder.

Does this skill support concurrent reads and writes?

Yes, it includes configuration for Write-Ahead Logging (WAL) via PRAGMA journal_mode=WAL, which allows readers and writers to operate without blocking each other.

MAUI SQLite Database Storage

Name: MAUI SQLite Database Storage
Author: davidortinau

bydavidortinau

•

Mobile Development

Integrates SQLite local storage into .NET MAUI applications using the sqlite-net-pcl ORM for robust offline data persistence.

This skill streamlines the implementation of local data persistence in .NET MAUI apps by providing a standardized pattern for SQLite integration. It covers the entire lifecycle of local data management, from defining data models with ORM attributes to implementing a thread-safe, lazy-initialized asynchronous database service. By leveraging Write-Ahead Logging (WAL) for performance and proper Dependency Injection (DI) patterns, it ensures reliable and efficient data handling across Android, iOS, macOS, and Windows platforms.

主な機能

01Standardized Dependency Injection (DI) singleton registration

0298 GitHub stars

03ORM data modeling with PrimaryKey and AutoIncrement attributes

04Lazy-initialized asynchronous database service pattern

05Cross-platform file path management using FileSystem.AppDataDirectory

06Write-Ahead Logging (WAL) configuration for concurrent access

ユースケース

01Implementing high-performance local caching for frequently accessed cloud data

02Building offline-first mobile applications that require local data persistence

03Managing user-generated content and local application state without a server

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add davidortinau/maui-skills maui-sqlite-database

For use in Claude.ai and ChatGPT

Download Skill