Hoody SQLite

The Hoody SQLite service provides embedded database and key-value store capabilities directly inside your container’s runtime. It combines a lightweight SQL engine with a Redis-style key-value API, giving you transactional queries, structured indexing, and high-throughput atomic operations without provisioning an external database.

The service is reachable on a per-container subdomain of the form https://{projectId}-{containerId}-sqlite-1.{server}.containers.hoody.icu.

Browse the pages below for the full reference.

SQL Operations

Execute SQL transactions, create databases, and run queries against the embedded SQLite engine.

Key-Value Store

Overview of the KV Store and key listing endpoints.

KV Basic Operations

Get, set, delete, increment, and decrement values.

KV Batch Operations

Batch get, set, and delete multiple keys in a single request.

KV Atomic Operations

Push, pop, and remove array elements atomically.

KV Time-Travel & History

Snapshots, diffs, and rollbacks for the key-value store.

Health

The SQLite service exposes health endpoints for liveness checks and observability dashboards. These endpoints sit alongside the SQL and KV APIs and can be scraped independently.

GET /api/v1/sqlite/health

Liveness and observability endpoint. Returns service identity (status, service, built, started), process-level memory and file-descriptor counters (pid, memory, fds), and hardening snapshots (cache, counters). One scrape covers both liveness and observability signals.

This endpoint takes no parameters.

cURL

curl -X GET "https://{projectId}-{containerId}-sqlite-1.{server}.containers.hoody.icu/api/v1/sqlite/health"

SDK

await client.sqlite.health.getHealth()

Response 200

{
  "status": "ok",
  "service": "sqlite",
  "built": "2024-01-15T08:00:00Z",
  "started": "2024-01-20T12:34:56Z",
  "pid": 42,
  "memory": {
    "rss": 50331648,
    "heapTotal": 33554432,
    "heapUsed": 16777216,
    "external": 1245184
  },
  "fds": 12,
  "cache": {
    "size": 1024,
    "hits": 8432,
    "misses": 127,
    "evictions": 0,
    "maxSize": 4096
  },
  "counters": {
    "queries": 14523,
    "kvOps": 9812,
    "transactions": 312
  }
}

GET /api/v1/sqlite/health/cache

Returns only the cache sub-object from /health. Dedicated endpoint for dashboards that poll cache pressure without re-reading process-level memory and file descriptors.

This endpoint takes no parameters.

cURL

curl -X GET "https://{projectId}-{containerId}-sqlite-1.{server}.containers.hoody.icu/api/v1/sqlite/health/cache"

SDK

await client.sqlite.health.getHealthCache()

Response 200

{
  "size": 1024,
  "maxSize": 4096,
  "hits": 8432,
  "misses": 127,
  "evictions": 0,
  "hitRatio": 0.9851,
  "inserts": 612,
  "removals": 3
}