← The evidence ledger
Evidence row 121253
Observed , by baseline/1.
- Kind
- listing
- About
- source_record x402_bazaar:https://sicher.halowerk.com/v1/oss-sqlite-database-integrity-audit
- Recorded
- Previous row
- None: the first of its kind about this subject
- Body SHA-256
- 1943bbec3a4eae979e1c6425543cbfda5257d12e86fd34fb400270f08bce1f6d
- Leaf
- 0xf3f14b05939d0421e18fa3396ddddcdee569b7bcec13502e5a8377c385da4df3
What was observed
{
"endpoints": [
[
"x402",
"https://sicher.halowerk.com/v1/oss-sqlite-database-integrity-audit"
]
],
"name": "HALOWERK sicherwerk",
"owner_address": "0x2880edfff13100677bf97a3cbdf3bc34771c4e5e",
"raw": {
"accepts": [
{
"amount": "2500",
"asset": "0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913",
"extra": {
"asset": "USDC",
"assetTransferMethod": "eip3009",
"eip712Domain": {
"chainId": 8453,
"name": "USD Coin",
"verifyingContract": "0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913",
"version": "2"
},
"name": "USD Coin",
"network_name": "Base Mainnet",
"version": "2"
},
"maxTimeoutSeconds": 300,
"network": "eip155:8453",
"payTo": "0x2880EdfFF13100677Bf97A3CBdF3Bc34771C4E5E",
"scheme": "exact"
}
],
"description": "Opens a supplied SQLite database read-only with the pinned engine and asks it the two questions it answers about itself: whether the file structure is intact, and whether any row points at a parent that is not there. What comes back is the engine's own integrity messages, each foreign-key violation with its table and rowid, the inventory of tables and indexes, and the page geometry and text encoding.",
"extensions": {
"bazaar": {
"info": {
"input": {
"bodyType": "json",
"exampleUrl": "https://sicher.halowerk.com/v1/oss-sqlite-database-integrity-audit/schema#/requestExample",
"method": "POST",
"schemaUrl": "https://sicher.halowerk.com/v1/oss-sqlite-database-integrity-audit/schema#/inputSchema",
"type": "http"
},
"output": {
"example": {
"operation": "database-integrity-audit",
"result": {
"application_id": 0,
"encoding": "UTF-8",
"file_bytes": 16384,
"file_sha256": "d18c23b52a5a78552786f6cacea68b171c811514f0432170bed3a4d04e618945",
"foreign_key_violation_count": 1,
"foreign_key_violations": [
{
"fkid": 0,
"parent": "kunde",
"rowid": 12,
"table": "auftrag"
}
],
"freelist_count": 0,
"integrity_messages": [
"ok"
],
"integrity_ok": true,
"object_counts": {
"index": 1,
"table": 2
},
"objects": [
{
"name": "auftrag_kunde",
"tbl_name": "auftrag",
"type": "index"
},
{
"name": "auftrag",
"tbl_name": "auftrag",
"type": "table"
},
{
"name": "kunde",
"tbl_name": "kunde",
"type": "table"
}
],
"page_count": 4,
"page_size": 4096,
"user_version": 0,
"warnings": [
"PRAGMA foreign_key_check reported violations; see foreign_key_violations.",
"Reads the file as supplied. A clean result does not vouch for the data, only for the file structure."
]
},
"runtime_ms": 84.402,
"upstream": {
"binary_sha256": "04d261a472c6838700310da6c8abaec05534945c6fe1a2b3353e945313fc20b4",
"components": [
"/usr/bin/sqlite3"
],
"package_version": "3.45.1-1ubuntu2.8",
"project": "SQLite"
}
},
"exampleUrl": "https://sicher.halowerk.com/v1/oss-sqlite-database-integrity-audit/schema#/outputExample",
"schemaUrl": "https://sicher.halowerk.com/v1/oss-sqlite-database-integrity-audit/schema#/outputSchema",
"type": "json"
}
},
"schema": {
"$schema": "https://json-schema.org/draft/2020-12/schema",
"additionalProperties": true,
"properties": {
"input": {
"additionalProperties": true,
"properties": {
"bodyType": {
"const": "json"
},
"exampleUrl": {
"format": "uri",
"type": "string"
},
"method": {
"const": "POST"
},
"schemaUrl": {
"format": "uri",
"type": "string"
},
"type": {
"const": "http"
}
},
"required": [
"type",
"method",
"bodyType"
],
"type": "object"
},
"output": {
"additionalProperties": true,
"properties": {
"exampleUrl": {
"format": "uri",
"type": "string"
},
"schemaUrl": {
"format": "uri",
"type": "string"
},
"type": {
"const": "json"
}
},
"required": [
"type"
],
"type": "object"
}
},
"required": [
"input"
],
"type": "object"
}
}
},
"lastUpdated": "2026-10-25T14:03:26.411Z",
"quality": {
"l30DaysTotalCalls": 1,
"l30DaysUniquePayers": 1,
"lastCalledAt": "2026-10-25T14:03:25.993Z"
},
"resource": "https://sicher.halowerk.com/v1/oss-sqlite-database-integrity-audit",
"serviceName": "HALOWERK sicherwerk",
"tags": [
"oss",
"sqlite",
"p102"
],
"type": "http",
"x402Version": 2
},
"source": "x402_bazaar",
"summary": "Opens a supplied SQLite database read-only with the pinned engine and asks it the two questions it answers about itself: whether the file structure is intact, and whether any row points at a parent that is not there. What comes back is the engine's own integrity messages, each foreign-key violation with its table and rowid, the inventory of tables and indexes, and the page geometry and text encoding."
}What the leaf hashes
{"body":"1943bbec3a4eae979e1c6425543cbfda5257d12e86fd34fb400270f08bce1f6d","id":121253,"kind":"listing","method":"baseline/1","observed_us":1793025619677209,"prev":null,"subject":"x402_bazaar:https://sicher.halowerk.com/v1/oss-sqlite-database-integrity-audit","subject_kind":"source_record"}Proof
Fold these into the leaf in order, hashing each sorted pair with keccak256, to reach the root of (296695 rows).
- 0xf3f12147e86a06803a2bdf31dedb36b6e6795e584357fb20922bbb779dbff580
- 0xf7b3936823a40615191d320c022f9be76ca8ac5ee27b37e79973d5d6621ee37d
- 0x3c864bce37b3d1bde96f154a1c7b0e6b80c579baee7fbba2857cf93375cb77bc
- 0x6b9e76a5a10b7e15e625425130e90b98d60b2abc2a2ec2be3e79f165e9dcd058
- 0xe5b391b3f093d7fe895f79b0900ebf6e6e36234807d304a3a3b1b690757a2fb1
- 0x311500541bbf43bc259a7af29c933664434ec06c7b53bff3319c6c217dc62299
- 0x5af19a3b9ce7484ddedc8408dda02e2778ec5d59477c90a483c17f1f51a9865a
- 0x713aa721951d105b56a811c13d4c62baaac6f3bc6aedc34d08ea99e3f1babcce
- 0x45fe8ee3873885178f9b3399528a6107f64bcd48f52b3a2eb44e85703c3ccd12
- 0x2975e89c0c18a450c0bfde2c42c4c92b23bf147f75afffe0dee4f9c66939c8bf
- 0x07709318feb0c1102a4f704a544c82a5c58ec388fbdac0965060c1f5091cc976
- 0x86ae35463d854f3938d986999aa8497e14f0ba2aa6f39a269e1e6d1134f9b847
- 0x79695e4356ea25a2b58265a824698704cd2c743099ce2dca9e41384ce8f1a8c5
- 0xd769d41500075835c3b2f9184d223699fb983fd05c29fbcb44d964abc7ee380d
- 0x68d296b1e00b4899fb83c3fba36fffaefa311eac2903067dbebfe776a12b4a9a
- 0x5fb5dda563336cd1bc1b9f44c52b76237ae72ed2145cb9290f39f304ca7dd678
- 0x74a0a08e4e7ab9aa5bfbead33dec7e1c7e8e364cff69a63720d764bbe987aadc
- Day root
- 0xf43e8dcc3d451a4788b26be904c55e8c4c0fa75c9666796c51db38d37e2c0df8
- Chained
- 0x702d5ac508f08b0d1accf36af25822d8e5660367494edd17a642fb61e158a57a
- Published
- On Arc Testnet, block 69251483: 0x495162f8936e19f0039918feebe6c307f327cd6bf8c37219620b1970041fa9ae