addrbookFor publishers
← 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).

  1. 0xf3f12147e86a06803a2bdf31dedb36b6e6795e584357fb20922bbb779dbff580
  2. 0xf7b3936823a40615191d320c022f9be76ca8ac5ee27b37e79973d5d6621ee37d
  3. 0x3c864bce37b3d1bde96f154a1c7b0e6b80c579baee7fbba2857cf93375cb77bc
  4. 0x6b9e76a5a10b7e15e625425130e90b98d60b2abc2a2ec2be3e79f165e9dcd058
  5. 0xe5b391b3f093d7fe895f79b0900ebf6e6e36234807d304a3a3b1b690757a2fb1
  6. 0x311500541bbf43bc259a7af29c933664434ec06c7b53bff3319c6c217dc62299
  7. 0x5af19a3b9ce7484ddedc8408dda02e2778ec5d59477c90a483c17f1f51a9865a
  8. 0x713aa721951d105b56a811c13d4c62baaac6f3bc6aedc34d08ea99e3f1babcce
  9. 0x45fe8ee3873885178f9b3399528a6107f64bcd48f52b3a2eb44e85703c3ccd12
  10. 0x2975e89c0c18a450c0bfde2c42c4c92b23bf147f75afffe0dee4f9c66939c8bf
  11. 0x07709318feb0c1102a4f704a544c82a5c58ec388fbdac0965060c1f5091cc976
  12. 0x86ae35463d854f3938d986999aa8497e14f0ba2aa6f39a269e1e6d1134f9b847
  13. 0x79695e4356ea25a2b58265a824698704cd2c743099ce2dca9e41384ce8f1a8c5
  14. 0xd769d41500075835c3b2f9184d223699fb983fd05c29fbcb44d964abc7ee380d
  15. 0x68d296b1e00b4899fb83c3fba36fffaefa311eac2903067dbebfe776a12b4a9a
  16. 0x5fb5dda563336cd1bc1b9f44c52b76237ae72ed2145cb9290f39f304ca7dd678
  17. 0x74a0a08e4e7ab9aa5bfbead33dec7e1c7e8e364cff69a63720d764bbe987aadc
Day root
0xf43e8dcc3d451a4788b26be904c55e8c4c0fa75c9666796c51db38d37e2c0df8
Chained
0x702d5ac508f08b0d1accf36af25822d8e5660367494edd17a642fb61e158a57a
Published
On Arc Testnet, block 69251483: 0x495162f8936e19f0039918feebe6c307f327cd6bf8c37219620b1970041fa9ae

How to check it · This row as JSON