Query Caching

LRU cache with configurable TTL. Cache hit = <5 ms response time.

  • Automatic cache invalidation on mutations
  • Per-table TTL configuration
  • Hit rate monitoring and statistics
  • 85% average cache hit rate in production

Built-in Security

Table whitelisting, input sanitization, field validation, and rate limiting.

  • Schema-based validation prevents bad data
  • Automatic SQL injection protection
  • Rate limiting: 100 req/min per resource
  • Access control by resource and table

Audit Logging

Every operation logged automatically for compliance and anti-cheat.

  • Track who, what, when for all operations
  • Query logs by player, resource, or table
  • Built-in anti-cheat pattern detection
  • Data recovery from deleted records

Backups & Snapshots

Point-in-time backups with automatic daily snapshots.

  • Manual snapshots before major updates
  • Automatic daily backups at 3 AM UTC
  • One-command restore from any snapshot
  • Snapshot metadata tracked in Convex

TypeScript Safety

Full type safety from database schema to Lua exports.

  • Schema defined in TypeScript
  • Runtime validation of all data
  • Catch errors at compile time
  • Auto-generated type definitions

Webhooks & Events

Event-driven architecture with webhook integrations.

  • Subscribe to database events in Lua
  • Trigger Discord/HTTP webhooks automatically
  • Build decoupled microservices
  • Event replay and debugging