{"id":121253,"recorded_at":"2026-10-26T14:40:19.677258Z","observed_at":"2026-10-26T14:40:19.677209Z","subject_kind":"source_record","subject":"x402_bazaar:https://sicher.halowerk.com/v1/oss-sqlite-database-integrity-audit","kind":"listing","method":"baseline/1","body":{"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."},"body_sha256":"1943bbec3a4eae979e1c6425543cbfda5257d12e86fd34fb400270f08bce1f6d","prev_id":null,"leaf":"0xf3f14b05939d0421e18fa3396ddddcdee569b7bcec13502e5a8377c385da4df3","leaf_text":"{\"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\"}","day":{"day":"2026-10-26","leaves":296695,"root":"0xf43e8dcc3d451a4788b26be904c55e8c4c0fa75c9666796c51db38d37e2c0df8","chained":"0x702d5ac508f08b0d1accf36af25822d8e5660367494edd17a642fb61e158a57a","anchor_chain":"eip155:5042002","anchor_tx":"0x495162f8936e19f0039918feebe6c307f327cd6bf8c37219620b1970041fa9ae","anchor_block":69251483},"proof":["0xf3f12147e86a06803a2bdf31dedb36b6e6795e584357fb20922bbb779dbff580","0xf7b3936823a40615191d320c022f9be76ca8ac5ee27b37e79973d5d6621ee37d","0x3c864bce37b3d1bde96f154a1c7b0e6b80c579baee7fbba2857cf93375cb77bc","0x6b9e76a5a10b7e15e625425130e90b98d60b2abc2a2ec2be3e79f165e9dcd058","0xe5b391b3f093d7fe895f79b0900ebf6e6e36234807d304a3a3b1b690757a2fb1","0x311500541bbf43bc259a7af29c933664434ec06c7b53bff3319c6c217dc62299","0x5af19a3b9ce7484ddedc8408dda02e2778ec5d59477c90a483c17f1f51a9865a","0x713aa721951d105b56a811c13d4c62baaac6f3bc6aedc34d08ea99e3f1babcce","0x45fe8ee3873885178f9b3399528a6107f64bcd48f52b3a2eb44e85703c3ccd12","0x2975e89c0c18a450c0bfde2c42c4c92b23bf147f75afffe0dee4f9c66939c8bf","0x07709318feb0c1102a4f704a544c82a5c58ec388fbdac0965060c1f5091cc976","0x86ae35463d854f3938d986999aa8497e14f0ba2aa6f39a269e1e6d1134f9b847","0x79695e4356ea25a2b58265a824698704cd2c743099ce2dca9e41384ce8f1a8c5","0xd769d41500075835c3b2f9184d223699fb983fd05c29fbcb44d964abc7ee380d","0x68d296b1e00b4899fb83c3fba36fffaefa311eac2903067dbebfe776a12b4a9a","0x5fb5dda563336cd1bc1b9f44c52b76237ae72ed2145cb9290f39f304ca7dd678","0x74a0a08e4e7ab9aa5bfbead33dec7e1c7e8e364cff69a63720d764bbe987aadc"]}