Stitch and Loop: Yarn Library

The Yarn Library is here! I have a lot of Yarns and I forget what I have so this is going to be a great change for me and I hope for you! You can now save yarn details once and reuse them across your crochet projects.

This makes it easier to keep track of the yarns you love, remember exactly what you used, and quickly add yarn details to new or existing projects without typing everything out again.

Added

• New dedicated Yarn Library page.
• Ability to add, edit, browse, and delete saved yarns.
• Yarn Library links added to desktop and mobile navigation.
• Searchable Pick from library option when adding or editing yarn on a project.
• Yarn thumbnails in the Yarn Library and project yarn picker.
• Automatic yarn saving: when you save a project, yarns with a brand are quietly added or updated in your Yarn Library.

New Yarn Details

You can now save more detailed yarn information, including:

• Brand
• Collection
• Fibre
• Yarn weight
• Recommended hook size
• Photo
• Manufacturer website URL
• Washing instructions
• Lot number
• Ball count
• Total grams

Improved Project Yarn Tracking

Project yarn entries now support a separate recommended hook size, independent of the project’s main hook size.

This is especially useful when a project uses multiple yarns or when you want to keep the yarn manufacturer’s suggested hook size for future reference.

Security & Permissions

• Tightened role and permission handling around admin access.
• Updated admin checks to use direct role lookups instead of restricted function calls.
• Restricted database role changes to prevent unwanted inserts, updates, or deletes.
• Improved access rules for yarn photos so uploaded images remain private and user-scoped.

Technical Updates

• Added yarn_library database table with row-level security policies.
• Added private yarn-photos storage bucket with user-scoped access rules.
• Added useYarnLibrary.ts hook for yarn library CRUD operations.
• Added /yarn-library route.
• Extended YarnEntry with optional hookSize.
• Added YarnLibraryItem type for saved yarn records.