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

•

Database Management

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

About

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.

Key Features

Lightweight JSON file persistence for simple storage or configuration needs
SQLite integration with Dapper for high-performance SQL operations
Full event sourcing architecture including event logging and state rebuilding
1 GitHub stars
Transactional support for ensuring data integrity during multi-step operations
Standardized async CRUD patterns for domain entity management

Use Cases

Implementing file-based data storage for prototypes or small datasets
Building a SQL-backed repository for domain entities in a web API
Creating an audit log or event-driven system using event sourcing patterns

About

Key Features

Lightweight JSON file persistence for simple storage or configuration needs
SQLite integration with Dapper for high-performance SQL operations
Full event sourcing architecture including event logging and state rebuilding
1 GitHub stars
Transactional support for ensuring data integrity during multi-step operations
Standardized async CRUD patterns for domain entity management

Use Cases

Implementing file-based data storage for prototypes or small datasets
Building a SQL-backed repository for domain entities in a web API
Creating an audit log or event-driven system using event sourcing patterns