Implement SQLite and JSON file persistence with async CRUD in F#.
npx skills add https://github.com/heimeshoff/Cinemarco --skill fsharp-persistence
Please help me install this Agent Skill. Skill: fsharp-persistence Source: https://github.com/heimeshoff/Cinemarco/tree/main/.claude/skills/fsharp-persistence Command: npx skills add https://github.com/heimeshoff/Cinemarco --skill fsharp-persistence
This Skill provides practical patterns for data persistence in F# apps, including SQLite with Dapper, JSON file storage, and event sourcing options. It helps you implement robust, asynchronous I/O, with safe, testable persistence layers.
Use this skill to create a Persistence.fs with CRUD operations in src/Server/Persistence.fs and example usage.
High-intent search queries and answers about installing and using this skill.
SQLite persistence in F# uses Dapper for parameterized queries and async I/O. Define repository functions for Create, Read, Update, Delete operations, initialize the database schema on startup, and execute queries asynchronously to maintain responsiveness in server-side applications.
SQLite with Dapper provides indexed, queryable storage with transactional safety for larger datasets and complex queries. JSON file storage offers lightweight, schema-free snapshots ideal for small datasets and quick prototyping, with easier versioning but no query indexing.
Event sourcing in F# with SQLite appends immutable events to a log and rebuilds domain state from the event stream. This Skill provides event envelope patterns and sample event types to implement append-only persistence, enabling audit trails and state replay.
A testable persistence layer uses repository-style data access with async functions separated from business logic. This Skill demonstrates how to isolate database operations into dedicated modules, enabling unit tests with in-memory or file-based storage without hitting live databases.
Asynchronous I/O is essential for server-side F# applications to prevent thread blocking during database calls. Dapper-based async queries allow concurrent requests to execute without starving other operations, improving throughput and responsiveness.
JSON file storage lacks indexing, concurrency control, and queryable data structures. It suits small datasets and snapshots but becomes impractical at scale, with no built-in transactions or multi-user safety compared to SQLite's ACID guarantees.
The-Tech-IdeaConfigure BeepDM datasource connections with a centralized typed model.
jyasuuExport and import RabbitMQ broker configurations and publish messages to exchanges with routing keys.
Azeem-2Provide production-ready async SQLModel/SQLAlchemy patterns for database design and operations.
huidgeDesign and optimize relational and NoSQL database schemas, indexes, and Redis caching patterns.
