SQL Operations
Execute SQL transactions, create databases, and run queries against Hoody-managed databases.
Overview
Section titled “Overview”The Hoody SQLite service combines a managed SQL execution layer with a high-performance key-value store. The endpoints in this section let you run SQL transactions, perform atomic and batch key-value operations, inspect stored keys with time-travel queries, and scrape health metrics for observability dashboards and liveness probes.
Service areas
Section titled “Service areas”Key-Value Store
Overview of the distributed KV Store, key listing, and metadata endpoints.
KV Basic Operations
Get, set, delete, increment, and decrement values for individual keys.
KV Batch Operations
Batch get, set, and delete across 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 stored keys.
Health
Section titled “Health”Liveness and observability endpoints for the SQLite service. These endpoints expose service identity, process-level counters, and cache pressure snapshots for monitoring, alerting, and load-balancer probes.
GET /api/v1/sqlite/health
Section titled “GET /api/v1/sqlite/health”Liveness/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 https://api.hoody.io/api/v1/sqlite/health{ "status": "ok", "service": "sqlite", "built": "2024-01-15T08:30:00Z", "started": "2024-01-15T12:00:00Z", "pid": 12345, "memory": { "rss": 52428800, "heapUsed": 33554432, "external": 8388608 }, "fds": { "open": 42, "limit": 1024 }, "cache": { "size": 1024, "capacity": 4096, "hits": 987654, "misses": 12345 }, "counters": { "requests": 1234567, "errors": 42, "queries": 987654 }}SDK usage
const health = await client.sqlite.health.getHealth();GET /api/v1/sqlite/health/cache
Section titled “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-descriptor counters.
This endpoint takes no parameters.
curl https://api.hoody.io/api/v1/sqlite/health/cache{ "size": 1024, "capacity": 4096, "hits": 987654, "misses": 12345, "evictions": 128}SDK usage
const cache = await client.sqlite.health.getHealthCache();