{"_id":"@agntz/store-sqlite","_rev":"9-efb088082364256dc2c557992fda4c29","name":"@agntz/store-sqlite","dist-tags":{"latest":"7.0.0"},"versions":{"0.1.1":{"name":"@agntz/store-sqlite","version":"0.1.1","keywords":["agent-runner","sqlite","store","ai","agents"],"author":{"name":"Aaron Bidworthy"},"license":"MIT","_id":"@agntz/store-sqlite@0.1.1","maintainers":[{"name":"aparry3","email":"aaron.parry.18@gmail.com"}],"homepage":"https://github.com/aparry3/agent-runner#readme","bugs":{"url":"https://github.com/aparry3/agent-runner/issues"},"dist":{"shasum":"6076835b8e04e311f9d636ab71a45eeeb7f2dc65","tarball":"https://registry.npmjs.org/@agntz/store-sqlite/-/store-sqlite-0.1.1.tgz","fileCount":6,"integrity":"sha512-z4LyeZPM26j92p3VzxYs9elm0elJz4xmfYeWzbqW6UTH7TaQExNmRNtXkqr9EocvJhvcW30gKLjK1IqG65kYuA==","signatures":[{"sig":"MEUCIQDOGBhdsRneuBJYTrNAYxl7Pjo74p77AR4HcPhs5nyZXQIgHBsMdG22YiCaPneGt6RBxzLb3oXVLNdetWHkmwa0AlM=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":62947},"main":"./dist/index.js","type":"module","_from":"file:agntz-store-sqlite-0.1.1.tgz","types":"./dist/index.d.ts","engines":{"node":">=22.0.0"},"exports":{".":{"types":"./dist/index.d.ts","import":"./dist/index.js"}},"scripts":{"dev":"tsup --watch","test":"vitest run","build":"tsup","typecheck":"tsc --noEmit","test:watch":"vitest"},"_npmUser":{"name":"aparry3","email":"aaron.parry.18@gmail.com"},"_resolved":"/tmp/e1f111b6987b1799cbe77c637bf32fe0/agntz-store-sqlite-0.1.1.tgz","_integrity":"sha512-z4LyeZPM26j92p3VzxYs9elm0elJz4xmfYeWzbqW6UTH7TaQExNmRNtXkqr9EocvJhvcW30gKLjK1IqG65kYuA==","repository":{"url":"git+https://github.com/aparry3/agent-runner.git","type":"git","directory":"packages/store-sqlite"},"_npmVersion":"10.9.7","description":"SQLite store adapter for agent-runner — single-server production storage","directories":{},"_nodeVersion":"22.22.2","dependencies":{"better-sqlite3":"^11.8.1"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"tsup":"^8.5.0","vitest":"^3.2.0","typescript":"^5.9.0","@agntz/core":"0.1.2","@types/better-sqlite3":"^7.6.12"},"peerDependencies":{"@agntz/core":">=0.1.2"},"_npmOperationalInternal":{"tmp":"tmp/store-sqlite_0.1.1_1776257994013_0.11326056976047982","host":"s3://npm-registry-packages-npm-production"},"deprecated":"Pre-baseline package retired. Use @agntz/stores/sqlite."},"1.0.0":{"name":"@agntz/store-sqlite","version":"1.0.0","keywords":["agntz","sqlite","store","ai","agents"],"author":{"name":"Aaron Bidworthy"},"license":"MIT","_id":"@agntz/store-sqlite@1.0.0","maintainers":[{"name":"aparry3","email":"aaron.parry.18@gmail.com"}],"homepage":"https://github.com/aparry3/agntz#readme","bugs":{"url":"https://github.com/aparry3/agntz/issues"},"dist":{"shasum":"6508f114df328386282ab27fbabdb54f79b4eaaa","tarball":"https://registry.npmjs.org/@agntz/store-sqlite/-/store-sqlite-1.0.0.tgz","fileCount":6,"integrity":"sha512-ru2xMtPKLb1Bzcb15ryHJaTPmzJaOvZWTDeUsbaouLQN0MCqTc7meLU4Wh286G98bevIGwhdKTVbSzdG5uB/vQ==","signatures":[{"sig":"MEUCIFmyiGv5UCUynY14BXhJyV+aP5qksh6UYg7jF7zSX9OuAiEAkk88+rFWYilgO5PBXIlfiUXg2CKNyNaczB8Di8oA21w=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":72253},"main":"./dist/index.js","type":"module","_from":"file:agntz-store-sqlite-1.0.0.tgz","types":"./dist/index.d.ts","engines":{"node":">=22.0.0"},"exports":{".":{"types":"./dist/index.d.ts","import":"./dist/index.js"}},"scripts":{"dev":"tsup --watch","test":"vitest run","build":"tsup","typecheck":"tsc --noEmit","test:watch":"vitest"},"_npmUser":{"name":"aparry3","email":"aaron.parry.18@gmail.com"},"_resolved":"/tmp/e6966352bfd2f7838ba17d352a393ccd/agntz-store-sqlite-1.0.0.tgz","_integrity":"sha512-ru2xMtPKLb1Bzcb15ryHJaTPmzJaOvZWTDeUsbaouLQN0MCqTc7meLU4Wh286G98bevIGwhdKTVbSzdG5uB/vQ==","repository":{"url":"git+https://github.com/aparry3/agntz.git","type":"git","directory":"packages/store-sqlite"},"_npmVersion":"10.9.7","description":"SQLite store adapter for agntz — single-server production storage","directories":{},"_nodeVersion":"22.22.2","dependencies":{"better-sqlite3":"^11.8.1"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"tsup":"^8.5.0","vitest":"^3.2.0","typescript":"^5.9.0","@agntz/core":"1.0.0","@types/better-sqlite3":"^7.6.12"},"peerDependencies":{"@agntz/core":">=1.0.0"},"_npmOperationalInternal":{"tmp":"tmp/store-sqlite_1.0.0_1776445123483_0.9729691311526154","host":"s3://npm-registry-packages-npm-production"},"deprecated":"Pre-baseline package retired. Use @agntz/stores/sqlite."},"2.0.0":{"name":"@agntz/store-sqlite","version":"2.0.0","keywords":["agntz","sqlite","store","ai","agents"],"author":{"name":"Aaron Bidworthy"},"license":"MIT","_id":"@agntz/store-sqlite@2.0.0","maintainers":[{"name":"aparry3","email":"aaron.parry.18@gmail.com"}],"homepage":"https://github.com/aparry3/agntz#readme","bugs":{"url":"https://github.com/aparry3/agntz/issues"},"dist":{"shasum":"d0e615b882b194ee69228017e819d80044c8d5b0","tarball":"https://registry.npmjs.org/@agntz/store-sqlite/-/store-sqlite-2.0.0.tgz","fileCount":6,"integrity":"sha512-by/TuRbt+9o7clJSN47zfneQ9wlSREYp1AMlrrM5FeZzCXwbAAHqdRUHeTLEasWZLexs8IrjESdM/Q9PvbEwlg==","signatures":[{"sig":"MEUCIDrhvqpx4NOgMTlG3mnOi+KzxF1ahMcyAbavCy7sfLTbAiEAuDy6JPLD3SCBTtROSKJ+CdvtDCj1pgNYKeUa5pTkVSc=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":158071},"main":"./dist/index.js","type":"module","_from":"file:agntz-store-sqlite-2.0.0.tgz","types":"./dist/index.d.ts","engines":{"node":">=22.0.0"},"exports":{".":{"types":"./dist/index.d.ts","import":"./dist/index.js"}},"scripts":{"dev":"tsup --watch","test":"vitest run","build":"tsup","typecheck":"tsc --noEmit","test:watch":"vitest"},"_npmUser":{"name":"aparry3","email":"aaron.parry.18@gmail.com"},"_resolved":"/private/var/folders/5q/yf1j5cks5znbm_l1g6rm2w5h0000gn/T/15f6b00cb6e55ad530fb55ddfb9e2f55/agntz-store-sqlite-2.0.0.tgz","_integrity":"sha512-by/TuRbt+9o7clJSN47zfneQ9wlSREYp1AMlrrM5FeZzCXwbAAHqdRUHeTLEasWZLexs8IrjESdM/Q9PvbEwlg==","repository":{"url":"git+https://github.com/aparry3/agntz.git","type":"git","directory":"packages/store-sqlite"},"_npmVersion":"10.9.4","description":"SQLite store adapter for agntz — single-server production storage","directories":{},"_nodeVersion":"22.21.0","dependencies":{"better-sqlite3":"^11.8.1"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"tsup":"^8.5.0","vitest":"^3.2.0","typescript":"^5.9.0","@agntz/core":"1.1.0","@types/better-sqlite3":"^7.6.12"},"peerDependencies":{"@agntz/core":">=1.1.0"},"_npmOperationalInternal":{"tmp":"tmp/store-sqlite_2.0.0_1779382444584_0.013622892046951884","host":"s3://npm-registry-packages-npm-production"},"deprecated":"Pre-baseline package retired. Use @agntz/stores/sqlite."},"3.0.0":{"name":"@agntz/store-sqlite","version":"3.0.0","keywords":["agntz","sqlite","store","ai","agents"],"author":{"name":"Aaron Bidworthy"},"license":"MIT","_id":"@agntz/store-sqlite@3.0.0","maintainers":[{"name":"aparry3","email":"aaron.parry.18@gmail.com"}],"homepage":"https://github.com/aparry3/agntz#readme","bugs":{"url":"https://github.com/aparry3/agntz/issues"},"dist":{"shasum":"ef8f829d0d072e6e06bacc0801cd1f875b58713d","tarball":"https://registry.npmjs.org/@agntz/store-sqlite/-/store-sqlite-3.0.0.tgz","fileCount":6,"integrity":"sha512-rpiXaDMhZiUw4Nm7ZUvpQi8dVehWfYvgaCxyGTWMvyYk/TXlY4BCq6l7N5u+vokbx0aWLKrYkTOAhjqeMiaElA==","signatures":[{"sig":"MEUCIQD9t1A2P3aCkwPZLnH3cCu/AXKVAm2MKgBTjUK+TmSADAIgH7tUHzfYD0guUq3d/Cy6RAL0HNPvGTZiVQ0bfKuAMyo=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":159602},"main":"./dist/index.js","type":"module","_from":"file:agntz-store-sqlite-3.0.0.tgz","types":"./dist/index.d.ts","engines":{"node":">=22.0.0"},"exports":{".":{"types":"./dist/index.d.ts","import":"./dist/index.js"}},"scripts":{"dev":"tsup --watch","lint":"biome check src tests --no-errors-on-unmatched","test":"vitest run","build":"tsup","typecheck":"tsc --noEmit","test:watch":"vitest"},"_npmUser":{"name":"aparry3","email":"aaron.parry.18@gmail.com"},"_resolved":"/tmp/4c6c84b6bc40e1f74c52ed2befc4168a/agntz-store-sqlite-3.0.0.tgz","_integrity":"sha512-rpiXaDMhZiUw4Nm7ZUvpQi8dVehWfYvgaCxyGTWMvyYk/TXlY4BCq6l7N5u+vokbx0aWLKrYkTOAhjqeMiaElA==","repository":{"url":"git+https://github.com/aparry3/agntz.git","type":"git","directory":"packages/store-sqlite"},"_npmVersion":"10.9.8","description":"SQLite store adapter for agntz — single-server production storage","directories":{},"_nodeVersion":"22.22.3","dependencies":{"better-sqlite3":"^11.8.1"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"tsup":"^8.5.0","vitest":"^3.2.0","typescript":"^5.9.0","@agntz/core":"1.2.1","@types/better-sqlite3":"^7.6.12"},"peerDependencies":{"@agntz/core":">=1.2.1"},"_npmOperationalInternal":{"tmp":"tmp/store-sqlite_3.0.0_1780099801993_0.7365105644081276","host":"s3://npm-registry-packages-npm-production"},"deprecated":"Pre-baseline package retired. Use @agntz/stores/sqlite."},"4.0.0":{"name":"@agntz/store-sqlite","version":"4.0.0","keywords":["agntz","sqlite","store","ai","agents"],"author":{"name":"Aaron Bidworthy"},"license":"MIT","_id":"@agntz/store-sqlite@4.0.0","maintainers":[{"name":"aparry3","email":"aaron.parry.18@gmail.com"}],"homepage":"https://github.com/aparry3/agntz#readme","bugs":{"url":"https://github.com/aparry3/agntz/issues"},"dist":{"shasum":"736393d82649a99dcb3600838a235915fcee602c","tarball":"https://registry.npmjs.org/@agntz/store-sqlite/-/store-sqlite-4.0.0.tgz","fileCount":6,"integrity":"sha512-4TV2HTGxhzOjwKXMP15Xmx0kim1Uf3TpGK7udeWkfIlrXmmBWDFoV5bbMr6SFTuYm+3TR1hPJ5nO5YcwSibr6Q==","signatures":[{"sig":"MEYCIQCi9GQ6+G66nsexMJvdsekAOxH3MtksH5DXfTZETVhN0AIhAJMb79cZyItN0u5iyS01nWeEmkuyL+DFhWCZNy3XICdJ","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":191274},"main":"./dist/index.js","type":"module","_from":"file:agntz-store-sqlite-4.0.0.tgz","types":"./dist/index.d.ts","engines":{"node":">=22.0.0"},"exports":{".":{"types":"./dist/index.d.ts","import":"./dist/index.js"}},"scripts":{"dev":"tsup --watch","lint":"biome check src tests --no-errors-on-unmatched","test":"vitest run","build":"tsup","typecheck":"tsc --noEmit","test:watch":"vitest"},"_npmUser":{"name":"aparry3","email":"aaron.parry.18@gmail.com"},"_resolved":"/tmp/ba29c22923eb0b8f7385c13d9bf67d17/agntz-store-sqlite-4.0.0.tgz","_integrity":"sha512-4TV2HTGxhzOjwKXMP15Xmx0kim1Uf3TpGK7udeWkfIlrXmmBWDFoV5bbMr6SFTuYm+3TR1hPJ5nO5YcwSibr6Q==","repository":{"url":"git+https://github.com/aparry3/agntz.git","type":"git","directory":"packages/store-sqlite"},"_npmVersion":"10.9.8","description":"SQLite store adapter for agntz — single-server production storage","directories":{},"_nodeVersion":"22.22.3","dependencies":{"better-sqlite3":"^11.8.1"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"tsup":"^8.5.0","vitest":"^3.2.0","typescript":"^5.9.0","@agntz/core":"1.3.0","@types/better-sqlite3":"^7.6.12"},"peerDependencies":{"@agntz/core":">=1.3.0"},"_npmOperationalInternal":{"tmp":"tmp/store-sqlite_4.0.0_1780683666594_0.25993230547088997","host":"s3://npm-registry-packages-npm-production"},"deprecated":"Pre-baseline package retired. Use @agntz/stores/sqlite."},"5.0.0":{"name":"@agntz/store-sqlite","version":"5.0.0","keywords":["agntz","sqlite","store","ai","agents"],"author":{"name":"Aaron Bidworthy"},"license":"MIT","_id":"@agntz/store-sqlite@5.0.0","maintainers":[{"name":"aparry3","email":"aaron.parry.18@gmail.com"}],"homepage":"https://github.com/aparry3/agntz#readme","bugs":{"url":"https://github.com/aparry3/agntz/issues"},"dist":{"shasum":"0a8b46fdee09e1db165a0a11643db832e731b196","tarball":"https://registry.npmjs.org/@agntz/store-sqlite/-/store-sqlite-5.0.0.tgz","fileCount":6,"integrity":"sha512-teP+MenCnJMkcPB9W2PFQRUN6VXnxQXNICMPHmaWUfJ2sEedFduA/VKEpvwQv4pQPKp5MMNb/6JPb3Bua9Ik6w==","signatures":[{"sig":"MEYCIQD2ZDMtbJSHJWyF/YMw8zVkaVDJYDbbELeazqgUTRaazgIhAM/AjRGVcRpKs/MvuXB91gJEjRIXe19+BRVEAVO9EgQB","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":228516},"main":"./dist/index.js","type":"module","_from":"file:agntz-store-sqlite-5.0.0.tgz","types":"./dist/index.d.ts","engines":{"node":">=22.0.0"},"exports":{".":{"types":"./dist/index.d.ts","import":"./dist/index.js"}},"scripts":{"dev":"tsup --watch","lint":"biome check src tests --no-errors-on-unmatched","test":"vitest run","build":"tsup","typecheck":"tsc --noEmit","test:watch":"vitest"},"_npmUser":{"name":"aparry3","email":"aaron.parry.18@gmail.com"},"_resolved":"/tmp/12fe468e15a06e707a0434341ebf0f05/agntz-store-sqlite-5.0.0.tgz","_integrity":"sha512-teP+MenCnJMkcPB9W2PFQRUN6VXnxQXNICMPHmaWUfJ2sEedFduA/VKEpvwQv4pQPKp5MMNb/6JPb3Bua9Ik6w==","repository":{"url":"git+https://github.com/aparry3/agntz.git","type":"git","directory":"packages/store-sqlite"},"_npmVersion":"10.9.8","description":"SQLite store adapter for agntz — single-server production storage","directories":{},"_nodeVersion":"22.22.3","dependencies":{"better-sqlite3":"^11.8.1"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"tsup":"^8.5.0","vitest":"^3.2.0","typescript":"^5.9.0","@agntz/core":"1.4.0","@types/better-sqlite3":"^7.6.12"},"peerDependencies":{"@agntz/core":">=1.4.0"},"_npmOperationalInternal":{"tmp":"tmp/store-sqlite_5.0.0_1780928708961_0.7448214195341414","host":"s3://npm-registry-packages-npm-production"},"deprecated":"Pre-baseline package retired. Use @agntz/stores/sqlite."},"6.0.0":{"name":"@agntz/store-sqlite","version":"6.0.0","keywords":["agntz","sqlite","store","ai","agents"],"author":{"name":"Aaron Bidworthy"},"license":"MIT","_id":"@agntz/store-sqlite@6.0.0","maintainers":[{"name":"aparry3","email":"aaron.parry.18@gmail.com"}],"homepage":"https://github.com/aparry3/agntz#readme","bugs":{"url":"https://github.com/aparry3/agntz/issues"},"dist":{"shasum":"5dccdaf0b894d1ac4bcd36a666d41ba68ef62a32","tarball":"https://registry.npmjs.org/@agntz/store-sqlite/-/store-sqlite-6.0.0.tgz","fileCount":6,"integrity":"sha512-ZLpChkGYXym+zfLEJusln21wHmqHEaEL9/ye4Rk43WOa/2Bs8F6b5VV1TOeNULEGJtKlO/oG15hS6oOd1CSmLw==","signatures":[{"sig":"MEYCIQD34jmKpSEcRs1itVEyzhx/lCGnZwdpdopV8Iuv/GLu6QIhAIcAX/lHDaa6fRnH5Y8xSvSRCW4oNqnqE9/94pv8GJXQ","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":233397},"main":"./dist/index.js","type":"module","_from":"file:agntz-store-sqlite-6.0.0.tgz","types":"./dist/index.d.ts","engines":{"node":">=22.0.0"},"exports":{".":{"types":"./dist/index.d.ts","import":"./dist/index.js"}},"scripts":{"dev":"tsup --watch","lint":"biome check src tests --no-errors-on-unmatched","test":"vitest run","build":"tsup","typecheck":"tsc --noEmit","test:watch":"vitest"},"_npmUser":{"name":"aparry3","email":"aaron.parry.18@gmail.com"},"_resolved":"/tmp/fe3cf351e7944787728cc218935bc982/agntz-store-sqlite-6.0.0.tgz","_integrity":"sha512-ZLpChkGYXym+zfLEJusln21wHmqHEaEL9/ye4Rk43WOa/2Bs8F6b5VV1TOeNULEGJtKlO/oG15hS6oOd1CSmLw==","repository":{"url":"git+https://github.com/aparry3/agntz.git","type":"git","directory":"packages/store-sqlite"},"_npmVersion":"10.9.8","description":"SQLite store adapter for agntz — single-server production storage","directories":{},"_nodeVersion":"22.22.3","dependencies":{"better-sqlite3":"^11.8.1"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"tsup":"^8.5.0","vitest":"^3.2.0","typescript":"^5.9.0","@agntz/core":"1.5.0","@types/better-sqlite3":"^7.6.12"},"peerDependencies":{"@agntz/core":">=1.5.0"},"_npmOperationalInternal":{"tmp":"tmp/store-sqlite_6.0.0_1781379275431_0.13511006167734796","host":"s3://npm-registry-packages-npm-production"},"deprecated":"Pre-baseline package retired. Use @agntz/stores/sqlite."},"7.0.0":{"name":"@agntz/store-sqlite","version":"7.0.0","keywords":["agntz","sqlite","store","ai","agents"],"author":{"name":"Aaron Bidworthy"},"license":"MIT","_id":"@agntz/store-sqlite@7.0.0","maintainers":[{"name":"aparry3","email":"aaron.parry.18@gmail.com"}],"homepage":"https://github.com/aparry3/agntz#readme","bugs":{"url":"https://github.com/aparry3/agntz/issues"},"dist":{"shasum":"fa87187a394b72785af7b212862f96aeff8836df","tarball":"https://registry.npmjs.org/@agntz/store-sqlite/-/store-sqlite-7.0.0.tgz","fileCount":6,"integrity":"sha512-NVxoMKmLlh98YFG3xGpN6zDwlv8G/TUmsrOXe+7KmXPK2eRIbhS8c31x31kjFHrB6HJQPtltTzSbb3eXQw4BeQ==","signatures":[{"sig":"MEUCIQDcKPT8ywZQArv2sM34TFHmWym3ahYOg2gmhNZ+M5HR6QIgAmXQgF7bIv0CJLTI162bFmYtFapIqpueF+yAZdum3KY=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":239272},"main":"./dist/index.js","type":"module","_from":"file:agntz-store-sqlite-7.0.0.tgz","types":"./dist/index.d.ts","engines":{"node":">=22.0.0"},"exports":{".":{"types":"./dist/index.d.ts","import":"./dist/index.js"}},"scripts":{"dev":"tsup --watch","lint":"biome check src tests --no-errors-on-unmatched","test":"vitest run","build":"tsup","typecheck":"tsc --noEmit","test:watch":"vitest"},"_npmUser":{"name":"aparry3","email":"aaron.parry.18@gmail.com"},"_resolved":"/tmp/9790847cf50e574d5a592311b5295980/agntz-store-sqlite-7.0.0.tgz","_integrity":"sha512-NVxoMKmLlh98YFG3xGpN6zDwlv8G/TUmsrOXe+7KmXPK2eRIbhS8c31x31kjFHrB6HJQPtltTzSbb3eXQw4BeQ==","repository":{"url":"git+https://github.com/aparry3/agntz.git","type":"git","directory":"packages/store-sqlite"},"_npmVersion":"10.9.8","description":"SQLite store adapter for agntz — single-server production storage","directories":{},"_nodeVersion":"22.22.3","dependencies":{"better-sqlite3":"^11.8.1"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"tsup":"^8.5.0","vitest":"^3.2.0","typescript":"^5.9.0","@agntz/core":"1.6.0","@types/better-sqlite3":"^7.6.12"},"peerDependencies":{"@agntz/core":">=1.6.0"},"_npmOperationalInternal":{"tmp":"tmp/store-sqlite_7.0.0_1781630060014_0.5136013542280562","host":"s3://npm-registry-packages-npm-production"},"deprecated":"Pre-baseline package retired. Use @agntz/stores/sqlite."}},"time":{"created":"2026-04-15T12:59:53.907Z","modified":"2026-06-26T19:24:24.700Z","0.1.1":"2026-04-15T12:59:54.132Z","1.0.0":"2026-04-17T16:58:43.632Z","2.0.0":"2026-05-21T16:54:04.746Z","3.0.0":"2026-05-30T00:10:02.167Z","4.0.0":"2026-06-05T18:21:06.763Z","5.0.0":"2026-06-08T14:25:09.089Z","6.0.0":"2026-06-13T19:34:35.602Z","7.0.0":"2026-06-16T17:14:20.201Z"},"bugs":{"url":"https://github.com/aparry3/agntz/issues"},"author":{"name":"Aaron Bidworthy"},"license":"MIT","homepage":"https://github.com/aparry3/agntz#readme","keywords":["agntz","sqlite","store","ai","agents"],"repository":{"url":"git+https://github.com/aparry3/agntz.git","type":"git","directory":"packages/store-sqlite"},"description":"SQLite store adapter for agntz — single-server production storage","maintainers":[{"name":"aparry3","email":"aaron.parry.18@gmail.com"}],"readme":"# @agntz/store-sqlite\n\n[![npm version](https://img.shields.io/npm/v/@agntz/store-sqlite.svg)](https://www.npmjs.com/package/@agntz/store-sqlite)\n[![License: MIT](https://img.shields.io/badge/License-MIT-blue.svg)](https://opensource.org/licenses/MIT)\n[![Node.js](https://img.shields.io/badge/node-%3E%3D20.0.0-brightgreen.svg)](https://nodejs.org)\n\nSQLite storage adapter for [agntz](https://github.com/aparry3/agntz). Zero-config persistent storage for single-server deployments with WAL mode, automatic migrations, and full-text search on logs.\n\nBuilt on [better-sqlite3](https://github.com/WiseLibs/better-sqlite3) for synchronous, high-performance access.\n\n## Install\n\n```bash\nnpm install @agntz/store-sqlite @agntz/core\n# or\npnpm add @agntz/store-sqlite @agntz/core\n# or\nyarn add @agntz/store-sqlite @agntz/core\n```\n\n## Quick Start\n\n```typescript\nimport { createRunner, defineAgent } from \"@agntz/core\";\nimport { SqliteStore } from \"@agntz/store-sqlite\";\n\nconst runner = createRunner({\n  store: new SqliteStore(\"./data.db\"),\n});\n\nrunner.registerAgent(defineAgent({\n  id: \"greeter\",\n  name: \"Greeter\",\n  systemPrompt: \"You are a friendly greeter.\",\n  model: { provider: \"openai\", name: \"gpt-5.4-mini\" },\n}));\n\nconst result = await runner.invoke(\"greeter\", \"Hello!\");\nconsole.log(result.output);\n```\n\nThat's it. The database file is created automatically with all tables and indexes.\n\n## Usage\n\n### File-Based Storage\n\nThe most common setup — a single file that persists everything:\n\n```typescript\nconst store = new SqliteStore(\"./data.db\");\n```\n\nThis creates (or opens) `./data.db` with WAL mode enabled for concurrent read performance.\n\n### In-Memory Storage\n\nFor testing or ephemeral workloads:\n\n```typescript\nconst store = new SqliteStore(\":memory:\");\n```\n\nSame API, same schema — data lives only in memory.\n\n### Full Options\n\n```typescript\nconst store = new SqliteStore({\n  path: \"./data.db\",\n  wal: true,       // WAL mode for better concurrent reads (default: true)\n  verbose: false,  // Log all SQL queries to console (default: false)\n});\n```\n\n## API Reference\n\n### `SqliteStore`\n\nImplements `UnifiedStore` from `@agntz/core` — provides `AgentStore`, `SessionStore`, `ContextStore`, and `LogStore` in a single class.\n\n#### Constructor\n\n```typescript\nnew SqliteStore(path: string)\nnew SqliteStore(options: SqliteStoreOptions)\n```\n\n#### `SqliteStoreOptions`\n\n| Option | Type | Default | Description |\n|---|---|---|---|\n| `path` | `string` | — | **Required.** Path to SQLite file, or `\":memory:\"` |\n| `wal` | `boolean` | `true` | Enable WAL journal mode |\n| `verbose` | `boolean` | `false` | Log all SQL queries to console |\n\n#### Store Methods\n\n**AgentStore:**\n\n| Method | Description |\n|---|---|\n| `getAgent(id)` | Get an agent definition by ID |\n| `listAgents()` | List all agents (id, name, description) |\n| `putAgent(agent)` | Create or update an agent (upsert) |\n| `deleteAgent(id)` | Delete an agent |\n\n**SessionStore:**\n\n| Method | Description |\n|---|---|\n| `getMessages(sessionId)` | Get all messages in a session |\n| `append(sessionId, messages)` | Append messages (creates session if needed) |\n| `deleteSession(sessionId)` | Delete a session and its messages |\n| `listSessions(agentId?)` | List sessions, optionally filtered by agent |\n\n**ContextStore:**\n\n| Method | Description |\n|---|---|\n| `getContext(contextId)` | Get all entries for a context bucket |\n| `addContext(contextId, entry)` | Add an entry to a context bucket |\n| `clearContext(contextId)` | Clear all entries in a context bucket |\n\n**LogStore:**\n\n| Method | Description |\n|---|---|\n| `log(entry)` | Write an invocation log |\n| `getLogs(filter?)` | Query logs with optional filters (agentId, sessionId, since, limit, offset) |\n| `getLog(id)` | Get a single log by ID |\n\n**Lifecycle:**\n\n| Method | Description |\n|---|---|\n| `close()` | Close the database connection |\n| `database` | Access the underlying `better-sqlite3` Database instance |\n\n## Schema\n\nThe store creates the following tables automatically:\n\n| Table | Description |\n|---|---|\n| `agents` | Agent definitions stored as JSON text |\n| `sessions` | Session metadata with timestamps |\n| `messages` | Conversation messages with JSON tool calls |\n| `context_entries` | Shared context entries between agents |\n| `invocation_logs` | Full invocation logs with token usage |\n| `schema_version` | Migration version tracking |\n\n**Indexes** on `messages(session_id)`, `context_entries(context_id)`, `invocation_logs(agent_id)`, `invocation_logs(session_id)`, and `invocation_logs(timestamp)`.\n\n## Performance Notes\n\n- **WAL mode** enabled by default — dramatically improves concurrent read performance\n- **Synchronous = NORMAL** — good balance of durability and speed\n- **Busy timeout = 5s** — handles brief write contention gracefully\n- **Foreign keys** enabled — cascading deletes keep data consistent\n- **Transactions** — session appends and deletes are wrapped in transactions for atomicity\n- **Synchronous API** — better-sqlite3 is synchronous under the hood, so no connection pool overhead\n\n### When to Use SQLite vs PostgreSQL\n\n| | SQLite | PostgreSQL |\n|---|---|---|\n| **Deployment** | Single server | Multi-server |\n| **Setup** | Zero config — just a file path | Requires a running database |\n| **Concurrent writes** | One writer at a time (WAL helps reads) | Full concurrent writes |\n| **Best for** | Dev, prototyping, single-instance production | Scaled production, multiple app instances |\n| **Package** | `@agntz/store-sqlite` | [`@agntz/store-postgres`](../store-postgres) |\n\n## Examples\n\n### Local Development\n\n```typescript\nimport { createRunner, defineAgent } from \"@agntz/core\";\nimport { SqliteStore } from \"@agntz/store-sqlite\";\n\nconst runner = createRunner({\n  store: new SqliteStore(\"./dev.db\"),\n});\n```\n\n### Testing with In-Memory Store\n\n```typescript\nimport { describe, it, expect, beforeEach } from \"vitest\";\nimport { createRunner } from \"@agntz/core\";\nimport { SqliteStore } from \"@agntz/store-sqlite\";\n\ndescribe(\"my agent\", () => {\n  let runner;\n\n  beforeEach(() => {\n    // Fresh database for every test — fast and isolated\n    runner = createRunner({\n      store: new SqliteStore(\":memory:\"),\n    });\n  });\n\n  it(\"persists sessions\", async () => {\n    // ...\n  });\n});\n```\n\n### Advanced: Direct Database Access\n\n```typescript\nconst store = new SqliteStore(\"./data.db\");\n\n// Run custom queries against the underlying database\nconst db = store.database;\nconst count = db.prepare(\"SELECT COUNT(*) as n FROM invocation_logs\").get();\nconsole.log(`Total invocations: ${count.n}`);\n```\n\n### Graceful Shutdown\n\n```typescript\nprocess.on(\"SIGTERM\", async () => {\n  await runner.shutdown();\n  store.close();\n  process.exit(0);\n});\n```\n\n## Related Packages\n\n| Package | Description |\n|---|---|\n| [`@agntz/core`](../core) | Core SDK — createRunner, agents, tools, stores |\n| [`@agntz/store-postgres`](../store-postgres) | PostgreSQL adapter for multi-server deployments |\n\n## Contributing\n\nSee the main [CONTRIBUTING.md](https://github.com/aparry3/agntz/blob/main/CONTRIBUTING.md) for guidelines.\n\n## License\n\nMIT © [Aaron Bidworthy](https://github.com/aparry3)\n","readmeFilename":"README.md"}