Admin Cockpit Gateway

Our Cloud CozySync architecture evaluates transactions based on a client-side ISO modification flag (cozylife_last_local_change) in comparison with the database row state:

• Client newer: Client updates are pushed to D1 backups automatically during idle/manual sync runs.
• Server newer: Client local databases are wiped and loaded with server states (prompting an atomic interface refresh).
• No changes: Server signals matches without updating resources.

CozyLife leverages **Dexie.js** transactions to prevent database state pollution. Restoring databases runs in a 'rw' transaction across db.pots, db.contacts, db.meetings, db.todos, db.gamification:

await db.transaction('rw', db.pots, db.contacts, db.meetings, db.todos, db.gamification, async () => {
  await db.pots.clear();
  // Bulk additions...
});

This guarantees that if the network fails midway, local database consistency is preserved perfectly.

Execute database queries, DDL migrations, or audit operations directly from your terminal inside the workspace using Wrangler CLI tools:

# Run schema migration on local wrangler database
npx wrangler d1 execute cozylife-db --local --file=./schema.sql

# Check registered user consent records locally
npx wrangler d1 execute cozylife-db --local --command="SELECT email, accepted_terms, marketing_consent FROM cozylife_users"

# Fetch LLM API tokens tracked on production environment
npx wrangler d1 execute cozylife-db --remote --command="SELECT SUM(prompt_tokens) FROM cozylife_llm_usage"