Skip to content

maxrave-dev/kotlin-footguns / skills/data-layer-footguns

data-layer-footguns

Verified

Room/SQLite, DataStore and repository traps: migrations, NOT IN with NULLs, LIKE escaping, delete order, local-time bucketing, imports, caching, paging. Use before writing a query or migration, or when data comes back wrong.

FileKindSize
SKILL.mdskill md16.6 KB
references/bucket-local-time-in-code-not-in-sql.mdmarkdown6.7 KB
references/bulk-json-import-progress.mdmarkdown7.2 KB
references/cache-then-network.mdmarkdown6.2 KB
references/cascading-delete-ordering.mdmarkdown6.5 KB
references/clean-satellite-at-transition.mdmarkdown4.9 KB
references/continuation-token-pagination-contract.mdmarkdown7.2 KB
references/datastore-kmp-manager.mdmarkdown7.7 KB
references/encoded-continuation-tokens-local-sort.mdmarkdown8.4 KB
references/first-ever-not-first-in-window.mdmarkdown6.7 KB
references/generic-paged-db-accumulator.mdmarkdown6.3 KB
references/import-format-contract-design.mdmarkdown8.5 KB
references/inclusive-period-boundaries-and-offset-reset.mdmarkdown7.5 KB
references/like-wildcard-escaping-ids.mdmarkdown5.4 KB
references/local-listening-analytics.mdmarkdown8.1 KB
references/mirror-local-state-to-a-remote-account.mdmarkdown8.1 KB
references/order-preserving-section-mapping.mdmarkdown5.5 KB
references/remote-index-cached-as-rows-with-validator.mdmarkdown7.3 KB
references/repository-flow-conventions.mdmarkdown7.1 KB
references/room-kmp-setup.mdmarkdown7.6 KB
references/room-migrations-at-scale.mdmarkdown8.8 KB
references/room-rawquery-readonly-vacuum.mdmarkdown5.0 KB
references/search-over-a-paged-list-queries-the-source.mdmarkdown7.4 KB
references/sql-not-in-nullable-trap.mdmarkdown4.9 KB
references/stored-timestamp-is-a-local-wall-clock.mdmarkdown8.0 KB
references/ttl-keyed-json-cache-lenient-decode.mdmarkdown6.4 KB
references/unbounded-for-shares-capped-for-lists.mdmarkdown6.6 KB
deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall