jsonl-store-pattern

What problem does it solve?

This Skill provides a robust design template for persisting structured records as an append-only JSONL store while keeping efficient lookup via multiple indexes, including Windows-safe UTF-8 handling and reliable loading.

Core Features & Use Cases

• Append-only JSONL records: Writes one JSON record per line for efficient tailing and streaming-style operations.
• Multi-index storage (master + by-X): Duplicates each record into a master file plus axis-specific indexes (e.g., by-topic, by-source) to enable fast queries.
• Windows CRLF + UTF-8 safe loading: Uses a ByteArray-to-string + line-splitting approach to avoid empty reads and parsing failures.
• Safe append with OpenAppend: Includes directory creation, JSON-safe serialization, and structured error returns for failure diagnosis.
• Pluggable debug/status checks: Verifies existence and counts to quickly detect issues such as the Windows read pitfall or JSON errors.
• Use Case: Store claim/event records for retrieval by topic and reverse-lookup by source without introducing a database dependency.

Quick Start

Use the jsonl-store-pattern to append claim records into master.jsonl and query them by topic or source using the provided iLoadJSONL and iByXPath templates.