domains / families / software-engineering / data-layer-footguns

data-layer-footguns

separate

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.

When to use

• Room/SQLite migrations
• NOT IN with NULLs
• LIKE escaping
• delete order
• local-time bucketing
• imports
• caching
• paging

Skill page

Source