Your project's state, wherever it runs.

SQL

$ curl -H "Authorization: Bearer $TOKEN" \
    https://api.takodb.com/v1/db/orders/sql \
    -d '{"statements":[{"sql":
      "SELECT id, total FROM sales
       WHERE region = ?","params":["eu"]}]}'

→ 200
  {"results":[{"rows":[
    {"id":1,"total":42},
    {"id":2,"total":17}]}]}

Key / Value

# set a typed key — int, text, blob, or JSON
$ curl -X PUT "…/v1/db/app/kv/cursor" \
    -H "Authorization: Bearer $TOKEN" \
    -d '{"type":"json",
      "value":{"page":7,"done":false}}'

$ curl "…/v1/db/app/kv/cursor" -H …
→ 200 {"key":"cursor","type":"json",
        "value":{"page":7,"done":false}}

Python

# no SDK: the standard library is enough
import json
import urllib.request

url = "https://api.takodb.com/v1/db/orders/sql"
body = {"statements": [{
  "sql": "SELECT * FROM sales WHERE region = ?",
  "params": ["eu"]}],
  "format": "objects"}

req = urllib.request.Request(
    url,
    data=json.dumps(body).encode(),
    headers={
        "Authorization": f"Bearer {TOKEN}",
        "Content-Type": "application/json"})

with urllib.request.urlopen(req) as r:
    print(json.load(r)["results"][0]["rows"])

→ [{'id': 1, 'region': 'eu', 'total': 42}, …]