Skip to content

Glossary

ACID — the four guarantees of a transaction: Atomicity (all or nothing), Consistency (the rules stay true), Isolation (transactions do not disturb each other), Durability (what is committed is not lost). DB-API 13

Aggregation — a number computed over many rows: COUNT, SUM, AVG, MIN, MAX, usually with GROUP BY. DB-API 10

Allow-list — a closed list of accepted values (tables, columns, sort orders); anything not on it is rejected. DB-API 11, 15

API (HTTP) — a set of endpoints through which a program reads and changes data over HTTP. DB-API 1

Array — in JSON, an ordered list inside [ ]. JSON 2

Authorizer — a function registered in SQLite that approves or denies every action of a query; used by /sql to allow reads only. DB-API 12

Bearer token — a credential sent as Authorization: Bearer <token>: whoever “bears” it is authorized. DB-API 8

Body — the content of an HTTP request or response (for us almost always JSON). DB-API 1

Cache-Control — a header that says who may keep a response and for how long (public, max-age=60, no-store). DB-API 14

CHECK — a schema constraint on a value (rating BETWEEN 1 AND 5). DB-API 13

Composite key — a primary key made of several columns, such as book_tags(book_id, tag_id). Dataset reference

Content-Type — a header that declares the format of the body (application/json; charset=utf-8). JSON 14

CORS — the browser rule by which a site may read responses from another origin only if the server allows it with Access-Control-Allow-Origin. DB-API 15

CTE (Common Table Expression) — a named subquery, WITH name AS (…); the RECURSIVE variant walks hierarchies. DB-API 12

Cursor (pagination) — instead of page=3, an opaque bookmark that says “where to continue from”; stable even when the data changes. DB-API 4

Deserialization (parsing) — from JSON text to language objects (json.loads, JSON.parse). JSON 3

Endpoint — an API path that answers one or more methods (GET /books/{id}). DB-API 1

ETag — a fingerprint of a response; sent back with If-None-Match it allows a 304 Not Modified. DB-API 14

Expand — a parameter with which the API “follows” a foreign key and includes the linked row (?expand=items.book). DB-API 5

Exponential backoff — growing waits between attempts (0.5 s, 1 s, 2 s…), often with random jitter. DB-API 16

Foreign key (FK) — a column holding the primary key of another table (books.author_id → authors.id); it expresses a relation. DB-API 5, 12

Full-text search — searching by words with ranking, not by equality (/search, FTS5). DB-API 9

GROUP BY / HAVING — groups rows by value; HAVING filters the groups after aggregation. DB-API 10, 12

Header — name/value pairs that accompany requests and responses (Authorization, Content-Type, ETag…). DB-API 1

HTTP method — the verb of the request: GET (read), POST (create), PUT (replace), PATCH (update), DELETE (delete), OPTIONS (preflight). DB-API 1

Idempotence — the property of a request that, repeated, has the same effect as a single one: GET, PUT, DELETE yes; POST no. DB-API 16

Index — a structure that lets the database find rows without reading the whole table (SEARCH … USING INDEX vs SCAN). DB-API 12

JOIN — an SQL operation that puts rows of two tables side by side according to a condition, usually FK = PK. LEFT JOIN also keeps the rows with no match. DB-API 12

JSON — a text format for structured data: objects, arrays, strings, numbers, booleans, null. JSON 1

JSON Lines (NDJSON) — one JSON document per line; suited to streams and large files. JSON 11

JSON Schema — a language (written in JSON) to describe and validate the shape of a JSON document. JSON 9

Keep-alive — reusing the same TCP/TLS connection for several requests. DB-API 14

Null — no value: null in JSON, NULL in SQL (tested with IS NULL). JSON 2

Object — in JSON, a set of key/value pairs inside { }. JSON 2

ON DELETE CASCADE — an FK rule: deleting the row it points to also deletes the rows that point to it. DB-API 13

OpenAPI — a formal description (JSON/YAML) of an API: endpoints, parameters, schemas; it powers Swagger UI. JSON 9, Reference

Pagination — returning results in blocks (page/limit or a cursor) with meta and links. DB-API 4

Parameter (SQL) — a ? placeholder that the engine replaces with a value, which can never become code. DB-API 11, 15

Preflight — the OPTIONS request a browser sends before a “non-simple” cross-origin request. DB-API 15

Primary key (PK) — a column (or group of columns) that uniquely identifies a row; usually id. DB-API 5, 12

Query string — the part of the URL after ?: key=value parameters separated by &. DB-API 4

Rate limit — a limit on requests per time interval; when exceeded, 429 with Retry-After. DB-API 14

Resource — the “thing” an API exposes (a book, an order), with a URL. Nested resource: /authors/{id}/books. DB-API 5

REST — an API style based on resources identified by URLs and manipulated with HTTP methods. DB-API 1

Retry-After — a header saying after how many seconds to retry (with 429 or 503). DB-API 14

Reverse proxy — a server (here Caddy) in front of the application: it terminates HTTPS, compresses, adds headers, routes. DB-API 14, 15

Sandbox — a private copy of the database tied to a token, where you can write without touching the public data. DB-API 6

Schema (database) — the definition of tables, columns, keys and constraints; GET /schema exposes it. DB-API 5

Serialization — from language objects to JSON text (json.dumps, JSON.stringify). JSON 3

SQL injection — an attack in which a user value is interpreted as SQL code; prevented with parameters, allow-lists and least privilege. DB-API 15

State machine — a set of states and allowed transitions (order: pending → paid → shipped → delivered). DB-API 13

Status code — the three-digit number of the response: 2xx ok, 3xx redirect/not modified, 4xx client error, 5xx server error. DB-API 7

Subquery — a SELECT inside another one (WHERE price > (SELECT AVG(price) …)). DB-API 12

Timeout — the maximum time the client waits before giving up. DB-API 16

Token — a secret string that identifies the caller (here: the sandbox). DB-API 8

Transaction — a group of writes executed all or none (COMMIT/ROLLBACK). DB-API 13

UNIQUE — a constraint by which a value cannot repeat in a column (customers.email); violated → 409. DB-API 13

Validation — checking the types, limits and shape of input before using it; on error, 422 with the details. DB-API 7, 15

View — a query saved in the database, which can be queried like a table (book_stats). DB-API 12

X-Request-Id — a unique identifier of a request, useful in logs to trace it. DB-API 16

422 / 409 — 422 Unprocessable Content: a value is not acceptable; 409 Conflict: the current state of the data prevents the operation. DB-API 7, 13