{"_id":"@aphexcms/sqlite-adapter","_rev":"7-fa26f172f39af58fd9758688509a72c1","name":"@aphexcms/sqlite-adapter","dist-tags":{"latest":"2.0.0"},"versions":{"0.1.0":{"name":"@aphexcms/sqlite-adapter","version":"0.1.0","license":"MIT","_id":"@aphexcms/sqlite-adapter@0.1.0","maintainers":[{"name":"rainbowasian96","email":"benjaminsinidol@gmail.com"}],"homepage":"https://github.com/IcelandicIcecream/aphex#readme","bugs":{"url":"https://github.com/IcelandicIcecream/aphex/issues"},"dist":{"shasum":"52d3975e50b00df0e7675774acd1d9a52a791b4b","tarball":"https://registry.npmjs.org/@aphexcms/sqlite-adapter/-/sqlite-adapter-0.1.0.tgz","fileCount":47,"integrity":"sha512-LnlNJh9quj/yDvGfQo+qEVy+rpWp5H7ABprhmZuMkIuvyCrDRAVW2cf9cPqAc+3yRtUoOzkEW3s4CHSXOfSyaA==","signatures":[{"sig":"MEQCIFZhSq7Sh+NBwV0CfwNw/gJZcDb7gLJqsG7HqaQxbneCAiBHbToiFBEH8LIDXKNMMRFmQ79snBmmMSjr5yevUMrchg==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":399073},"main":"./dist/index.js","type":"module","_from":"file:aphexcms-sqlite-adapter-0.1.0.tgz","types":"./dist/index.d.ts","exports":{".":{"types":"./dist/index.d.ts","import":"./dist/index.js","default":"./dist/index.js"},"./schema":{"types":"./dist/schema.d.ts","import":"./dist/schema.js","default":"./dist/schema.js"}},"scripts":{"dev":"tsc --watch","test":"vitest run","build":"tsc && node ../../scripts/fix-imports.js ./dist","clean":"rm -rf dist","test:watch":"vitest"},"_npmUser":{"name":"rainbowasian96","email":"benjaminsinidol@gmail.com"},"_resolved":"/private/var/folders/lg/xjmlrfd55zd3z62k81158q200000gn/T/dc34c5ee96f90d6085c12497c634143b/aphexcms-sqlite-adapter-0.1.0.tgz","_integrity":"sha512-LnlNJh9quj/yDvGfQo+qEVy+rpWp5H7ABprhmZuMkIuvyCrDRAVW2cf9cPqAc+3yRtUoOzkEW3s4CHSXOfSyaA==","repository":{"url":"git+https://github.com/IcelandicIcecream/aphex.git","type":"git","directory":"packages/sqlite-adapter"},"_npmVersion":"11.12.1","description":"SQLite database adapter for Aphex CMS (libsql — local file databases and Turso)","directories":{},"_nodeVersion":"26.0.0","dependencies":{"drizzle-orm":"^0.45.2","@libsql/client":"^0.15.15"},"publishConfig":{"access":"public","provenance":true},"_hasShrinkwrap":false,"devDependencies":{"vitest":"^4.0.14","typescript":"^5.9.3","drizzle-kit":"^0.31.7","@aphexcms/cms-core":"^9.3.0","@electric-sql/pglite":"^0.5.0","@aphexcms/postgresql-adapter":"14.1.0"},"peerDependencies":{"@aphexcms/cms-core":"^9.3.0"},"_npmOperationalInternal":{"tmp":"tmp/sqlite-adapter_0.1.0_1783696319965_0.8505302102639436","host":"s3://npm-registry-packages-npm-production"}},"0.2.0":{"name":"@aphexcms/sqlite-adapter","version":"0.2.0","license":"MIT","_id":"@aphexcms/sqlite-adapter@0.2.0","maintainers":[{"name":"rainbowasian96","email":"benjaminsinidol@gmail.com"}],"homepage":"https://github.com/IcelandicIcecream/aphex#readme","bugs":{"url":"https://github.com/IcelandicIcecream/aphex/issues"},"dist":{"shasum":"3bebc4d19c38613d00e65ca20c9961a80e5347a4","tarball":"https://registry.npmjs.org/@aphexcms/sqlite-adapter/-/sqlite-adapter-0.2.0.tgz","fileCount":47,"integrity":"sha512-ojVU41pGN2xX9fjq1wj/4eRJjnRcXafLCZMxqVA5AmNpGeTS0BvKsWCh4qk0y5rbTCWbrm8JZmL/6aU2d2lEOw==","signatures":[{"sig":"MEUCIHGirJP5V2KbT31z6PL6KyK1F77UeW9doeUogThbZc7pAiEAj5YNU9raAXAfnYXxlDHuD1NPPMZCRIKZuQsJeaOh92Q=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@aphexcms%2fsqlite-adapter@0.2.0","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":411926},"main":"./dist/index.js","type":"module","_from":"file:aphexcms-sqlite-adapter-0.2.0.tgz","types":"./dist/index.d.ts","exports":{".":{"types":"./dist/index.d.ts","import":"./dist/index.js","default":"./dist/index.js"},"./schema":{"types":"./dist/schema.d.ts","import":"./dist/schema.js","default":"./dist/schema.js"}},"scripts":{"dev":"tsc --watch","test":"vitest run","build":"tsc && node ../../scripts/fix-imports.js ./dist","clean":"rm -rf dist","test:watch":"vitest"},"_npmUser":{"name":"GitHub Actions","email":"npm-oidc-no-reply@github.com","trustedPublisher":{"id":"github","oidcConfigId":"oidc:552b0b2c-0aff-4901-8f40-2c16435db73f"}},"_resolved":"/tmp/33498d7e6a33ef76521be5a951168c67/aphexcms-sqlite-adapter-0.2.0.tgz","_integrity":"sha512-ojVU41pGN2xX9fjq1wj/4eRJjnRcXafLCZMxqVA5AmNpGeTS0BvKsWCh4qk0y5rbTCWbrm8JZmL/6aU2d2lEOw==","repository":{"url":"git+https://github.com/IcelandicIcecream/aphex.git","type":"git","directory":"packages/sqlite-adapter"},"_npmVersion":"11.16.0","description":"SQLite database adapter for Aphex CMS (libsql — local file databases and Turso)","directories":{},"_nodeVersion":"24.18.0","dependencies":{"drizzle-orm":"^0.45.2","@libsql/client":"^0.15.15"},"publishConfig":{"access":"public","provenance":true},"_hasShrinkwrap":false,"devDependencies":{"vitest":"^4.0.14","typescript":"^5.9.3","drizzle-kit":"^0.31.7","@aphexcms/cms-core":"^9.5.0","@electric-sql/pglite":"^0.5.0","@aphexcms/postgresql-adapter":"14.2.0"},"peerDependencies":{"@aphexcms/cms-core":"^9.5.0"},"_npmOperationalInternal":{"tmp":"tmp/sqlite-adapter_0.2.0_1784275335335_0.9486964844124552","host":"s3://npm-registry-packages-npm-production"}},"0.3.0":{"name":"@aphexcms/sqlite-adapter","version":"0.3.0","license":"MIT","_id":"@aphexcms/sqlite-adapter@0.3.0","maintainers":[{"name":"rainbowasian96","email":"benjaminsinidol@gmail.com"}],"homepage":"https://github.com/IcelandicIcecream/aphex#readme","bugs":{"url":"https://github.com/IcelandicIcecream/aphex/issues"},"dist":{"shasum":"29a4c0fb550ef94fa491efd1fce63e8f8744de46","tarball":"https://registry.npmjs.org/@aphexcms/sqlite-adapter/-/sqlite-adapter-0.3.0.tgz","fileCount":55,"integrity":"sha512-wS0Tssm9Z1mt9UQo4hGWGLa6gHHSmR2OYj5pFobb0ZPkH1cWNIC44XBtaDMpxEXEJgwdBYggUFZVOXl0ErkcQA==","signatures":[{"sig":"MEYCIQCIndTP4t/fi+CBe23setcND91IH4LL0s/JVR9RvW7yGAIhAKJ5ALaxztl2ylGXJxKm+8yqj9U944eV7CdELQxh35oA","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@aphexcms%2fsqlite-adapter@0.3.0","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":520810},"main":"./dist/index.js","type":"module","_from":"file:aphexcms-sqlite-adapter-0.3.0.tgz","types":"./dist/index.d.ts","exports":{".":{"types":"./dist/index.d.ts","import":"./dist/index.js","default":"./dist/index.js"},"./schema":{"types":"./dist/schema.d.ts","import":"./dist/schema.js","default":"./dist/schema.js"}},"scripts":{"dev":"tsc --watch","test":"vitest run","build":"tsc && node ../../scripts/fix-imports.js ./dist","clean":"rm -rf dist","test:watch":"vitest"},"_npmUser":{"name":"GitHub Actions","email":"npm-oidc-no-reply@github.com","trustedPublisher":{"id":"github","oidcConfigId":"oidc:552b0b2c-0aff-4901-8f40-2c16435db73f"}},"_resolved":"/tmp/0e9e10c5b909b2eae405d9fc14b83ab1/aphexcms-sqlite-adapter-0.3.0.tgz","_integrity":"sha512-wS0Tssm9Z1mt9UQo4hGWGLa6gHHSmR2OYj5pFobb0ZPkH1cWNIC44XBtaDMpxEXEJgwdBYggUFZVOXl0ErkcQA==","repository":{"url":"git+https://github.com/IcelandicIcecream/aphex.git","type":"git","directory":"packages/sqlite-adapter"},"_npmVersion":"11.16.0","description":"SQLite database adapter for Aphex CMS (libsql — local file databases and Turso)","directories":{},"_nodeVersion":"24.18.0","dependencies":{"drizzle-orm":"^0.45.2","@libsql/client":"^0.15.15"},"publishConfig":{"access":"public","provenance":true},"_hasShrinkwrap":false,"devDependencies":{"vitest":"^4.0.14","typescript":"^5.9.3","drizzle-kit":"^0.31.7","@aphexcms/cms-core":"^9.7.0","@electric-sql/pglite":"^0.5.0","@aphexcms/postgresql-adapter":"14.3.0"},"peerDependencies":{"@aphexcms/cms-core":"^9.7.0"},"_npmOperationalInternal":{"tmp":"tmp/sqlite-adapter_0.3.0_1784548674083_0.632374969151605","host":"s3://npm-registry-packages-npm-production"}},"0.4.0":{"name":"@aphexcms/sqlite-adapter","version":"0.4.0","license":"MIT","_id":"@aphexcms/sqlite-adapter@0.4.0","maintainers":[{"name":"rainbowasian96","email":"benjaminsinidol@gmail.com"}],"homepage":"https://github.com/IcelandicIcecream/aphex#readme","bugs":{"url":"https://github.com/IcelandicIcecream/aphex/issues"},"dist":{"shasum":"8ebc4b0ca27eab903ba27e5e572c101f0a6776b2","tarball":"https://registry.npmjs.org/@aphexcms/sqlite-adapter/-/sqlite-adapter-0.4.0.tgz","fileCount":59,"integrity":"sha512-w2XRhk9DBZCJmIndG0HU/M1T65UqI8Z0eJki9AxzsV3xA72lbcuUEBK1BsruWRuVsOulqfPAe6G0iIwWgb6nmA==","signatures":[{"sig":"MEUCIERDxWvMqFw0yMdlvB98kDQx8Lh3MQ/M9i/YI7stn4CnAiEAwwD3Ks4DXIBHa3DVMRj+bnsLT1YnbfYuiFhSHxqlvzw=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@aphexcms%2fsqlite-adapter@0.4.0","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":579470},"main":"./dist/index.js","type":"module","_from":"file:aphexcms-sqlite-adapter-0.4.0.tgz","types":"./dist/index.d.ts","exports":{".":{"types":"./dist/index.d.ts","import":"./dist/index.js","default":"./dist/index.js"},"./schema":{"types":"./dist/schema.d.ts","import":"./dist/schema.js","default":"./dist/schema.js"}},"scripts":{"dev":"tsc --watch","test":"vitest run","build":"tsc && node ../../scripts/fix-imports.js ./dist","clean":"rm -rf dist","test:watch":"vitest"},"_npmUser":{"name":"GitHub Actions","email":"npm-oidc-no-reply@github.com","trustedPublisher":{"id":"github","oidcConfigId":"oidc:552b0b2c-0aff-4901-8f40-2c16435db73f"}},"_resolved":"/tmp/6de1f33fad2cc92dcde2805833778a7e/aphexcms-sqlite-adapter-0.4.0.tgz","_integrity":"sha512-w2XRhk9DBZCJmIndG0HU/M1T65UqI8Z0eJki9AxzsV3xA72lbcuUEBK1BsruWRuVsOulqfPAe6G0iIwWgb6nmA==","repository":{"url":"git+https://github.com/IcelandicIcecream/aphex.git","type":"git","directory":"packages/sqlite-adapter"},"_npmVersion":"11.16.0","description":"SQLite database adapter for Aphex CMS (libsql — local file databases and Turso)","directories":{},"_nodeVersion":"24.18.0","dependencies":{"drizzle-orm":"^0.45.2","@libsql/client":"^0.15.15"},"publishConfig":{"access":"public","provenance":true},"_hasShrinkwrap":false,"devDependencies":{"vitest":"^4.0.14","typescript":"^5.9.3","drizzle-kit":"^0.31.7","@aphexcms/cms-core":"^9.8.0","@electric-sql/pglite":"^0.5.0","@aphexcms/postgresql-adapter":"14.4.0"},"peerDependencies":{"@aphexcms/cms-core":"^9.8.0"},"_npmOperationalInternal":{"tmp":"tmp/sqlite-adapter_0.4.0_1785602477364_0.9330044233490622","host":"s3://npm-registry-packages-npm-production"}},"0.5.0":{"name":"@aphexcms/sqlite-adapter","version":"0.5.0","license":"MIT","_id":"@aphexcms/sqlite-adapter@0.5.0","maintainers":[{"name":"rainbowasian96","email":"benjaminsinidol@gmail.com"}],"homepage":"https://github.com/IcelandicIcecream/aphex#readme","bugs":{"url":"https://github.com/IcelandicIcecream/aphex/issues"},"dist":{"shasum":"5a627b06338316bafcd79a950a4fd07cc798a6e0","tarball":"https://registry.npmjs.org/@aphexcms/sqlite-adapter/-/sqlite-adapter-0.5.0.tgz","fileCount":59,"integrity":"sha512-tPE97Bp1cFW0Gf4WTPBHtczuz1dHAI/Mjtf6a4aIaqo1pAUzLzrsAnMsBZoEW1TkeHFPE7MvJ22OQGlJWXPo2g==","signatures":[{"sig":"MEUCIQDygNnzh9v9n45qwUzWax16giM4d3TRvDh8bk5kHP2F2QIgfzdYoeyPHEXs6OS+szewh1XhZVIuGmldocVWPnUNfTQ=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@aphexcms%2fsqlite-adapter@0.5.0","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":588737},"main":"./dist/index.js","type":"module","_from":"file:aphexcms-sqlite-adapter-0.5.0.tgz","types":"./dist/index.d.ts","exports":{".":{"types":"./dist/index.d.ts","import":"./dist/index.js","default":"./dist/index.js"},"./schema":{"types":"./dist/schema.d.ts","import":"./dist/schema.js","default":"./dist/schema.js"}},"scripts":{"dev":"tsc --watch","test":"vitest run","build":"tsc && node ../../scripts/fix-imports.js ./dist","clean":"rm -rf dist","test:watch":"vitest"},"_npmUser":{"name":"GitHub Actions","email":"npm-oidc-no-reply@github.com","trustedPublisher":{"id":"github","oidcConfigId":"oidc:552b0b2c-0aff-4901-8f40-2c16435db73f"}},"_resolved":"/tmp/9c4a298a0d85b4a7a44b5bc5afcdad5c/aphexcms-sqlite-adapter-0.5.0.tgz","_integrity":"sha512-tPE97Bp1cFW0Gf4WTPBHtczuz1dHAI/Mjtf6a4aIaqo1pAUzLzrsAnMsBZoEW1TkeHFPE7MvJ22OQGlJWXPo2g==","repository":{"url":"git+https://github.com/IcelandicIcecream/aphex.git","type":"git","directory":"packages/sqlite-adapter"},"_npmVersion":"11.16.0","description":"SQLite database adapter for Aphex CMS (libsql — local file databases and Turso)","directories":{},"_nodeVersion":"24.18.0","dependencies":{"drizzle-orm":"^0.45.2","@libsql/client":"^0.15.15"},"publishConfig":{"access":"public","provenance":true},"_hasShrinkwrap":false,"devDependencies":{"vitest":"^4.1.10","typescript":"^5.9.3","drizzle-kit":"^0.31.7","@aphexcms/cms-core":"^9.9.0","@electric-sql/pglite":"^0.5.0","@aphexcms/postgresql-adapter":"14.5.0"},"peerDependencies":{"@aphexcms/cms-core":"^9.9.0"},"_npmOperationalInternal":{"tmp":"tmp/sqlite-adapter_0.5.0_1786287174252_0.08419752042017703","host":"s3://npm-registry-packages-npm-production"}},"1.0.0":{"name":"@aphexcms/sqlite-adapter","version":"1.0.0","license":"MIT","_id":"@aphexcms/sqlite-adapter@1.0.0","maintainers":[{"name":"rainbowasian96","email":"benjaminsinidol@gmail.com"}],"homepage":"https://github.com/IcelandicIcecream/aphex#readme","bugs":{"url":"https://github.com/IcelandicIcecream/aphex/issues"},"dist":{"shasum":"9cf058db6db88ae262d3850942fa457c557af20d","tarball":"https://registry.npmjs.org/@aphexcms/sqlite-adapter/-/sqlite-adapter-1.0.0.tgz","fileCount":59,"integrity":"sha512-z48SM4SSvR29yBlaWSbLzICSSb7pwa+6vSx7JJy4UmWSrj9AW5FB3rfWE/L1sZWeG9r/zno9ECWP6BjO3nqDvg==","signatures":[{"sig":"MEYCIQDDwjc9IvR6+hyNvAsAUA/xMWlYcFobair5FN5BzaN3fQIhAIo49IVyOz3y8e0b0yjfo8bWH7KvBaHqBOppOS4UQfmE","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@aphexcms%2fsqlite-adapter@1.0.0","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":639183},"main":"./dist/index.js","type":"module","_from":"file:aphexcms-sqlite-adapter-1.0.0.tgz","types":"./dist/index.d.ts","exports":{".":{"types":"./dist/index.d.ts","import":"./dist/index.js","default":"./dist/index.js"},"./schema":{"types":"./dist/schema.d.ts","import":"./dist/schema.js","default":"./dist/schema.js"}},"scripts":{"dev":"tsc --watch","test":"vitest run","build":"tsc && node ../../scripts/fix-imports.js ./dist","clean":"rm -rf dist","test:watch":"vitest"},"_npmUser":{"name":"GitHub Actions","email":"npm-oidc-no-reply@github.com","trustedPublisher":{"id":"github","oidcConfigId":"oidc:552b0b2c-0aff-4901-8f40-2c16435db73f"}},"_resolved":"/tmp/a1be051dccab2466e745d345dcb838ff/aphexcms-sqlite-adapter-1.0.0.tgz","_integrity":"sha512-z48SM4SSvR29yBlaWSbLzICSSb7pwa+6vSx7JJy4UmWSrj9AW5FB3rfWE/L1sZWeG9r/zno9ECWP6BjO3nqDvg==","repository":{"url":"git+https://github.com/IcelandicIcecream/aphex.git","type":"git","directory":"packages/sqlite-adapter"},"_npmVersion":"11.19.0","description":"SQLite database adapter for Aphex CMS (libsql — local file databases and Turso)","directories":{},"_nodeVersion":"24.20.0","dependencies":{"drizzle-orm":"^0.45.2","@libsql/client":"^0.15.15"},"publishConfig":{"access":"public","provenance":true},"_hasShrinkwrap":false,"devDependencies":{"vitest":"^4.1.10","typescript":"^5.9.3","drizzle-kit":"^0.31.7","@aphexcms/cms-core":"^10.0.0","@electric-sql/pglite":"^0.5.0","@aphexcms/postgresql-adapter":"15.0.0"},"peerDependencies":{"@aphexcms/cms-core":"^10.0.0"},"_npmOperationalInternal":{"tmp":"tmp/sqlite-adapter_1.0.0_1788630765041_0.8167335240813558","host":"s3://npm-registry-packages-npm-production"}},"2.0.0":{"name":"@aphexcms/sqlite-adapter","version":"2.0.0","description":"SQLite database adapter for Aphex CMS (libsql — local file databases and Turso)","license":"MIT","publishConfig":{"access":"public","provenance":true},"repository":{"type":"git","url":"git+https://github.com/IcelandicIcecream/aphex.git","directory":"packages/sqlite-adapter"},"type":"module","main":"./dist/index.js","types":"./dist/index.d.ts","exports":{".":{"types":"./dist/index.d.ts","import":"./dist/index.js","default":"./dist/index.js"},"./schema":{"types":"./dist/schema.d.ts","import":"./dist/schema.js","default":"./dist/schema.js"}},"dependencies":{"@libsql/client":"^0.15.15","drizzle-orm":"^0.45.2"},"peerDependencies":{"@aphexcms/cms-core":"^11.0.0"},"devDependencies":{"@electric-sql/pglite":"^0.5.0","drizzle-kit":"^0.31.7","typescript":"^5.9.3","vitest":"^4.1.10","@aphexcms/cms-core":"^11.0.0","@aphexcms/postgresql-adapter":"16.0.0"},"scripts":{"build":"tsc && node ../../scripts/fix-imports.js ./dist","dev":"tsc --watch","clean":"rm -rf dist","test":"vitest run","test:watch":"vitest"},"_id":"@aphexcms/sqlite-adapter@2.0.0","bugs":{"url":"https://github.com/IcelandicIcecream/aphex/issues"},"homepage":"https://github.com/IcelandicIcecream/aphex#readme","_integrity":"sha512-y374hZgSETAd3ZUYmnyiJTi3Sw5jdmlXZSRHXcJvDgfsHlv5Dwdi2lQIHNBa39K7tRX4Bc0I89NpssaSjRltBQ==","_resolved":"/tmp/410b8fa29c1cf4caf374c3c691fc81e0/aphexcms-sqlite-adapter-2.0.0.tgz","_from":"file:aphexcms-sqlite-adapter-2.0.0.tgz","_nodeVersion":"24.20.0","_npmVersion":"11.19.1","dist":{"integrity":"sha512-y374hZgSETAd3ZUYmnyiJTi3Sw5jdmlXZSRHXcJvDgfsHlv5Dwdi2lQIHNBa39K7tRX4Bc0I89NpssaSjRltBQ==","shasum":"8f68a1225128e72a14fe379824ab3b239da7586d","tarball":"https://registry.npmjs.org/@aphexcms/sqlite-adapter/-/sqlite-adapter-2.0.0.tgz","fileCount":59,"unpackedSize":643299,"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@aphexcms%2fsqlite-adapter@2.0.0","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCICmecgkMNGbN7ZGzTiIa+P7vxFbTpbSphBVvb50pwswbAiEA7oqH2eAMw5S07OtGtk8ak0bmHW9XAz4GmzOBAVprv2c="}]},"_npmUser":{"name":"GitHub Actions","email":"npm-oidc-no-reply@github.com","trustedPublisher":{"id":"github","oidcConfigId":"oidc:552b0b2c-0aff-4901-8f40-2c16435db73f"}},"directories":{},"maintainers":[{"name":"rainbowasian96","email":"benjaminsinidol@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/sqlite-adapter_2.0.0_1788805988910_0.7104218747231372"},"_hasShrinkwrap":false}},"time":{"created":"2026-07-10T15:11:59.822Z","modified":"2026-09-07T18:33:09.371Z","0.1.0":"2026-07-10T15:12:00.091Z","0.2.0":"2026-07-17T08:02:15.546Z","0.3.0":"2026-07-20T11:57:54.243Z","0.4.0":"2026-08-01T16:41:17.506Z","0.5.0":"2026-08-09T14:52:54.396Z","1.0.0":"2026-09-05T17:52:45.182Z","2.0.0":"2026-09-07T18:33:09.055Z"},"bugs":{"url":"https://github.com/IcelandicIcecream/aphex/issues"},"license":"MIT","homepage":"https://github.com/IcelandicIcecream/aphex#readme","repository":{"type":"git","url":"git+https://github.com/IcelandicIcecream/aphex.git","directory":"packages/sqlite-adapter"},"description":"SQLite database adapter for Aphex CMS (libsql — local file databases and Turso)","maintainers":[{"name":"rainbowasian96","email":"benjaminsinidol@gmail.com"}],"readme":"# @aphexcms/sqlite-adapter\n\nSQLite database adapter for [AphexCMS](https://github.com/IcelandicIcecream/aphex), built on [libsql](https://github.com/tursodatabase/libsql).\n\nImplements the full `DatabaseAdapter` contract from `@aphexcms/cms-core`, so it is a drop-in alternative to `@aphexcms/postgresql-adapter`. Works against a local `file:` database (no Docker, no server) or a Turso-hosted `libsql://` URL.\n\n## Install\n\n```bash\npnpm add @aphexcms/sqlite-adapter @libsql/client\n```\n\n## Quick start\n\nLet the adapter create and own the client:\n\n```ts\nimport { createSQLiteProvider } from '@aphexcms/sqlite-adapter';\n\n// Local file\nconst db = createSQLiteProvider({ url: 'file:.aphex/site.db' }).createAdapter();\n\n// Turso\nconst db = createSQLiteProvider({\n\turl: 'libsql://mydb-me.turso.io',\n\tauthToken: process.env.DATABASE_AUTH_TOKEN\n}).createAdapter();\n```\n\nThen hand it to `createCMSConfig()`:\n\n```ts\nimport { createCMSConfig } from '@aphexcms/cms-core/server';\n\nexport default createCMSConfig({\n\tschemaTypes,\n\tdatabase: db\n\t// …\n});\n```\n\n### Bringing your own client\n\nApps usually share one libsql client between the adapter, Drizzle, and the auth provider. Pass it in — **the adapter never modifies a client it didn't create**, so apply pragmas yourself:\n\n```ts\nimport { createClient } from '@libsql/client';\nimport { createSQLiteProvider, applyRecommendedPragmas } from '@aphexcms/sqlite-adapter';\n\nconst client = createClient({ url: 'file:.aphex/site.db' });\nawait applyRecommendedPragmas(client, 'file:.aphex/site.db');\n\nconst db = createSQLiteProvider({ client }).createAdapter();\n```\n\n## Pragmas\n\nWhen the adapter creates the client from `url`, it applies a recommended set to local `file:` databases:\n\n| Pragma         | Value    | Why                                                       |\n| -------------- | -------- | --------------------------------------------------------- |\n| `journal_mode` | `WAL`    | Reads proceed while a write is in flight                  |\n| `synchronous`  | `NORMAL` | The safe pairing for WAL                                  |\n| `busy_timeout` | `5000`   | Waits instead of throwing `SQLITE_BUSY` under concurrency |\n\nIn-memory and Turso URLs are skipped — Turso manages its own journaling.\n\n```ts\n// Default: recommended set\ncreateSQLiteProvider({ url });\n\n// Opt out entirely\ncreateSQLiteProvider({ url, pragmas: false });\n\n// Recommended set plus tuning (see SQLitePragmaOptions)\ncreateSQLiteProvider({\n\turl,\n\tpragmas: { cacheSize: -65536 } // 64 MiB page cache (negative = KiB)\n});\n\n// Raw statements, run verbatim\ncreateSQLiteProvider({ url, pragmas: 'PRAGMA busy_timeout=10000;' });\n```\n\nPragmas apply to the client's main connection. libsql opens a fresh connection per interactive transaction, which gets SQLite defaults.\n\n## Multi-tenancy\n\nSQLite has **no Row-Level Security**. Organization isolation comes from the explicit `organizationId` WHERE clause every query applies — the same mechanism that actually isolates tenants on pooled Postgres, where the connection is the table owner and bypasses RLS anyway.\n\n```ts\ncreateSQLiteProvider({ url, multiTenancy: { enableHierarchy: true } });\n```\n\n`enableHierarchy` works as on Postgres. There is no `enableRLS` option.\n\n## Migrations\n\nPoint `drizzle.config.ts` at `dialect: 'sqlite'` and re-export the CMS tables from `@aphexcms/sqlite-adapter/schema` instead of the Postgres adapter.\n\nThe `aphex migrate` CLI detects SQLite from `APHEX_DATABASE=sqlite`, or from a `DATABASE_URL` starting with `file:` / `libsql:`. Remote databases use `DATABASE_AUTH_TOKEN`.\n\n## Behavioral parity\n\nBoth adapters run the same cross-dialect conformance suite (`tests/conformance.spec.ts`) against an in-memory libsql and an in-memory PGlite, so filters, sorting, versioning, references, and org isolation behave identically.\n\nTwo documented differences:\n\n- **`contains` uses SQLite's `LIKE`**, which is case-insensitive for ASCII only. Postgres `ILIKE` handles full Unicode.\n- **Document JSON filters and sorts compile to `json_extract`** (Postgres uses `->>`). Both are per-row extraction expressions.\n\n### Query performance\n\nContent stored in `draftData` / `publishedData` is JSON. Filtering or sorting by a field _inside_ that JSON — anything that isn't a real column like `type` or `status` — compiles to `json_extract(...)` with no index behind it, so it scans within the `(organization_id, type)` partition. This is true of the PostgreSQL adapter too. If you filter a field often, promote it to a real column or add an expression index.\n\n## Exports\n\n| Path                              | Contents                                                                                           |\n| --------------------------------- | -------------------------------------------------------------------------------------------------- |\n| `@aphexcms/sqlite-adapter`        | `createSQLiteProvider`, `applyRecommendedPragmas`, `SQLiteAdapter`, types                          |\n| `@aphexcms/sqlite-adapter/schema` | Drizzle table definitions (`documents`, `assets`, `organizations`, …) and the combined `cmsSchema` |\n\n## License\n\nMIT\n","readmeFilename":"README.md"}