Tutorial: Cars by Color

Visual Interface Track

Open /app/ and configure credentials.
Upload cars_images.zip.
Run the SQL query below.

GesamtDB settings panel with connection configuration fields

Step 1: configure credentials and database settings.

GesamtDB data tab with file chooser and upload button

Step 2: choose cars_images.zip and upload it.

GesamtDB query tab with SQL editor and run button

Step 3: run the color filter query in the SQL editor.

SELECT filename
FROM cars_images
WHERE AIFILTER(content, 'this is a red car');

Python + REST Track

import json
import requests

API_BASE = "http://api.localhost"
HEADERS = {"Authorization": "Bearer YOUR_LICENSE_KEY"}

db = {
    "system": "postgres",
    "connection": {
        "host": "db.example.com",
        "port": 5432,
        "database": "analytics",
        "user": "app_user",
        "password": "secret"
    }
}

with open("cars_images.zip", "rb") as f:
    files = {"file": ("cars_images.zip", f, "application/zip")}
    data = {"db_config": json.dumps(db)}
    upload = requests.post(f"{API_BASE}/upload", headers=HEADERS, files=files, data=data, timeout=120)
    upload.raise_for_status()
    table = upload.json()["table_name"]

payload = {
    "db": db,
    "sql": f"SELECT filename FROM {table} WHERE AIFILTER(content, 'this is a red car')",
    "format": "json"
}
response = requests.post(f"{API_BASE}/query", headers=HEADERS, json=payload, timeout=300)
response.raise_for_status()
print(response.json())

Tutorial: Retrieve Cars by Color

Visual Interface Track