Does this skill support SQL injection prevention?

Yes, the skill strictly enforces the use of parameterized queries with Dapper to prevent SQL injection vulnerabilities and ensure secure data handling.

Is the generated code performance-optimized?

Yes, it uses asynchronous I/O patterns (async workflows) and proper connection disposal to ensure high performance and resource efficiency.

Can I implement event-driven architectures with this skill?

Absolutely. It includes patterns for event types, appending events to JSONL logs, and rebuilding application state from event streams.

Which database engine is primarily used?

The skill focuses on SQLite, providing a lightweight yet powerful SQL solution that works seamlessly with F# and the Dapper micro-ORM.

Where is the persistence code typically located?

Following standard F# project structures, this skill targets and manages code within the src/Server/Persistence.fs file.

F# Data Persistence Patterns

Name: F# Data Persistence Patterns
Author: heimeshoff

byheimeshoff

•

数据库管理

Implements robust data storage solutions using SQLite with Dapper, JSON files, or event sourcing patterns in F# projects.

This skill provides specialized implementation patterns for managing data persistence in F# backend applications, specifically targeting the src/Server/Persistence.fs file structure. It enables Claude to set up SQLite databases using Dapper for high-performance CRUD operations, implement simple JSON file storage for lightweight requirements, or architect complex event-sourced systems. By emphasizing asynchronous I/O, parameterized queries for security, and proper resource management, it ensures that your data access layer is both performant and maintainable.

主要功能

01Lightweight JSON file persistence for simple storage or configuration needs

02SQLite integration with Dapper for high-performance SQL operations

03Full event sourcing architecture including event logging and state rebuilding

041 GitHub stars

05Transactional support for ensuring data integrity during multi-step operations

06Standardized async CRUD patterns for domain entity management

使用场景

01Implementing file-based data storage for prototypes or small datasets

02Building a SQL-backed repository for domain entities in a web API

03Creating an audit log or event-driven system using event sourcing patterns

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add heimeshoff/cinemarco fsharp-persistence

For use in Claude.ai and ChatGPT

Download Skill