{"_id":"@boredland/node-ts-cache-storage-pg","_rev":"3-89c85ccf1cb8f8573e1acdfca2e13aac","name":"@boredland/node-ts-cache-storage-pg","dist-tags":{"latest":"1.0.2"},"versions":{"1.0.0":{"name":"@boredland/node-ts-cache-storage-pg","description":"Postgres storage module for node-ts-cache","version":"1.0.0","private":false,"main":"dist/index.js","types":"dist/index.d.ts","scripts":{"build":"tsc -p tsconfig-build.json"},"repository":{"type":"git","url":"git+https://github.com/boredland/node-ts-cache.git"},"keywords":["node","nodejs","cache","typescript","ts","caching","cache","postgres","postgresql","node-cache","ts-cache"],"license":"MIT","bugs":{"url":"https://github.com/boredland/node-ts-cache/issues"},"homepage":"https://github.com/boredland/node-ts-cache#readme","peerDependencies":{"@boredland/node-ts-cache":"^6.0.0"},"devDependencies":{"@boredland/node-ts-cache":"^6.0.0","pg":"^8.8.0","pg-mem":"^2.6.3"},"gitHead":"906ebd3fd9ac378a2deba5c593e4d369bd289940","_id":"@boredland/node-ts-cache-storage-pg@1.0.0","_nodeVersion":"16.17.0","_npmVersion":"8.15.0","dist":{"integrity":"sha512-arsP29KTLsID4Wvla+i+HlcO/7kBi62IdCV1aUozftbHXzPn0tuwYB5dh4WdpOKE/pJwI4XnSOWniu24jzrhsw==","shasum":"be4655708e7271fb1577d0116aae8551d5eb4ccd","tarball":"https://registry.npmjs.org/@boredland/node-ts-cache-storage-pg/-/node-ts-cache-storage-pg-1.0.0.tgz","fileCount":10,"unpackedSize":6365,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIGRl0FdXCsX4vAGoHcJS2xucd8M8VsBaLRcs0J7jjMG3AiAROV9K+jrhrs3vGnQE5fMhvqJbpfP+fTXQCeiTdZg55A=="}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJjOvs0ACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmqDjw/6AnFNe45PMMz3pHH9uSud9L6L16AKAnwzUm7oLpUPJzeYNhoR\r\nbXxoaqacsKnHRC/x82x3rQo7YyeROuURRkwamphOaWN+hhJ+tvpp4Zyhnp54\r\nBlIb+ulrrQ1k2sCM+sK/1q4/TG7h0IiXUiawz+Bdz/mB+p1LzPNBt6CuvWFL\r\nKEgC8ysbazdDjSNefOP3pIgDKCAzSHJRzvvWkI953FkG4yRIEPq+uYXLr/7q\r\nFOvs2SeOW4k6mKoBBAvgZshr5cSXolMOMxJ9PPQgJgpkVNGJojQictrFr4PY\r\nhSPl+zRAIiNUT2qJaUiD88uqyyIeQ48s6zvFcRI04kTx1wvyAyRFrkv0QSwy\r\ntFTWEfLd6FUXD8X4A6yV4eoYkQrLDHOstTu2f/Favg+GmJk4T4nwrRtYk4aP\r\nPLZaMOWeo0J7H7ZyNHguezQagwNMJJnWCkxj0nCa7wn6R9R02kB1KnYlsK21\r\nStQRSZ0tbG/LM49DgmpFhjEF8miQEFv1YfAVe6mrIeaLcyA03MaLkpHTFtI0\r\nBcXNVmK4FhW8otzt4I0R8ZYCviWeqWS/3pi0HAV7pmhSzRq5GL1mohJSGR4c\r\noTDQEcx7lawVjuiWDHo+6/1ETio3h2wJMcbN7Hw6yhKuFQwd5KyAD/j1uPPK\r\n3tBDTdwH9O++BJZfnQaj7uWCVShC7ZYh97k=\r\n=kXV+\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"jonasstr","email":"jo.strassel@gmail.com"},"directories":{},"maintainers":[{"name":"jonasstr","email":"jo.strassel@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/node-ts-cache-storage-pg_1.0.0_1664809779635_0.3494668699919006"},"_hasShrinkwrap":false,"deprecated":"Package no longer supported. Contact Support at https://www.npmjs.com/support for more info."},"1.0.1":{"name":"@boredland/node-ts-cache-storage-pg","description":"Postgres storage module for node-ts-cache","version":"1.0.1","private":false,"main":"dist/index.js","types":"dist/index.d.ts","scripts":{"build":"tsc -p tsconfig-build.json"},"repository":{"type":"git","url":"git+https://github.com/boredland/node-ts-cache.git"},"keywords":["node","nodejs","cache","typescript","ts","caching","cache","postgres","postgresql","node-cache","ts-cache"],"license":"MIT","bugs":{"url":"https://github.com/boredland/node-ts-cache/issues"},"homepage":"https://github.com/boredland/node-ts-cache#readme","peerDependencies":{"@boredland/node-ts-cache":"^6.0.1"},"devDependencies":{"@boredland/node-ts-cache":"^6.0.1","pg":"^8.8.0","pg-mem":"^2.6.3"},"gitHead":"d89812dcd5fca14534b6e04953fc0e0590d7a17c","_id":"@boredland/node-ts-cache-storage-pg@1.0.1","_nodeVersion":"16.17.0","_npmVersion":"8.15.0","dist":{"integrity":"sha512-EFMdinpI0hv2/2e2AN2EPqs2RZwqRANy57wKHXTdwA2ldKZg7YJoqQjjr4D9+XuhdQ4M4KGJUT8aVgwvUJ495Q==","shasum":"97623763a8cd2c043bd1209aa1df6aefdb35520e","tarball":"https://registry.npmjs.org/@boredland/node-ts-cache-storage-pg/-/node-ts-cache-storage-pg-1.0.1.tgz","fileCount":10,"unpackedSize":6502,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQC1T/hzV7K313nFrJYsy6aSuXqnZGuSPS85dy1+kSi+aQIgC7iWOHlLpj767enxREpcPM/13TtngjiYTnhp8hE6HU4="}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJjOxtnACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmpZVg//XZBXtO7hnWXE8QTI7uymJI1TZG3ibuVMKzNZhHAUTptkN3WC\r\nraBS+0+cIkYq/juk/Un5D1xFKlSRulutkrNC4QWiTJGjqfavRtl46xncbWYG\r\nKRqGnStvhqW2dn8qIyz13ov9vq/9K4cOr1LsWtaXf4kw4LLcNqYE8TEeP0Gg\r\n7v2qvb/XmusWSaA/Gaakqi4jfMOyhxX+EKYVQ9o9KZ1IpXekibfatDw+7W14\r\nB7b/3OllnD3ZRKY09YEfJMW9k/naqkh6CH/aMSZ8JdSmwt0v0H5vqkvHZhqP\r\nokiYMOwyhCnYZZw6Zd8B/EyWQHfLX8HCbvDE2E9WeX2qbDa+Aw5sgMKJY1yo\r\na3aJCA2Z8s5SnJodksLU2HzpASnpJJKCRuD9bKRUvPNjacWlPs2OkavsXafo\r\n6LUS6RDSjVbUizg7r5i2tQHHUCZj7VurVMn6iJ00VYgWbp7esMl1JBzw1Znd\r\nK6zlOq+eUPSAKO/wgjOgBzRPdya/SCTPiMuDKQloXckamjXzAPQ16ePeC0pY\r\nQCdkn9mNENikvVbOf5+MXGBtsuYgXedu367NWU6jP9mvQyA03ejMPDi6LIjP\r\nnHe95mKoMWcwAggucybKmUIj+7xvJUzskv+r4Z48djrkolVhwLqvB92u0XBT\r\n1QTDcKW+ym/zhLYliyHqS1UJisflu68Xk4o=\r\n=JJ4Z\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"jonasstr","email":"jo.strassel@gmail.com"},"directories":{},"maintainers":[{"name":"jonasstr","email":"jo.strassel@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/node-ts-cache-storage-pg_1.0.1_1664818022915_0.2158512034601603"},"_hasShrinkwrap":false,"deprecated":"Package no longer supported. Contact Support at https://www.npmjs.com/support for more info."},"1.0.2":{"name":"@boredland/node-ts-cache-storage-pg","description":"Postgres storage module for node-ts-cache","version":"1.0.2","private":false,"main":"dist/index.js","types":"dist/index.d.ts","scripts":{"build":"tsc -p tsconfig-build.json"},"repository":{"type":"git","url":"git+https://github.com/boredland/node-ts-cache.git"},"keywords":["node","nodejs","cache","typescript","ts","caching","cache","postgres","postgresql","node-cache","ts-cache"],"license":"MIT","bugs":{"url":"https://github.com/boredland/node-ts-cache/issues"},"homepage":"https://github.com/boredland/node-ts-cache#readme","peerDependencies":{"@boredland/node-ts-cache":"^6.0.2"},"devDependencies":{"@boredland/node-ts-cache":"^6.0.2","pg":"^8.8.0","pg-mem":"^2.6.3"},"gitHead":"ec979021a8855885e90aab5496e16b8a9ea6964c","_id":"@boredland/node-ts-cache-storage-pg@1.0.2","_nodeVersion":"16.17.0","_npmVersion":"8.15.0","dist":{"integrity":"sha512-WellD3BjjFCRW48Rfl422wC4s27hoaGcXpw3t99NXPtG+Ohw+GVxRkQDijvVjlMrbwhiAK6Qa/oorQ9m/TYE5A==","shasum":"25b7a512a93fef9dbbc11e93a980f7991204c363","tarball":"https://registry.npmjs.org/@boredland/node-ts-cache-storage-pg/-/node-ts-cache-storage-pg-1.0.2.tgz","fileCount":10,"unpackedSize":7347,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIFQ7lFTPfZyQcPbp/ZToN0gYzXDDf+P6x01sMBrwKOk2AiEAgHCJJXE+3bdMbKbI7pmdH+TmKwp5VNnvwMNPAlYJfBM="}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJjO+1/ACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2Vmq5LQ/+KwY/lQ0YkuhtF4bwXkz2UMJBNgZxpSOaRDXWF5Fh93VZ4Yik\r\n/cVV3i+172kVsL9DdRrfWmo+h4bp53UFFDvYUTckTUzxJV0U60iic0HiCOck\r\nhe/eE3Rc3bSF1O3Eiau7Gl+8ADa/yIBH2Ec1QisBpf4W5ayDv+iT0de5KVAC\r\n8fJPP5dkhhOXGKFxWJ8SrhkrTZxcaYf1h3rN89Nad4Q9eKFuVHn+W+uSHe7e\r\nmBsBthJ+WAqvUL3UFBiAY6tLGV3BAaStepfMce7OUd8u/RbxvyiYf+qtflyY\r\nzozuo8a/Iy4o9zb88VHS0XwXp1BArzhg93XUHaB2nKLhq+SecJfjzdS0NTgB\r\nwZLzKIRKxz0gzsA29iOhtuhd8RabE3Qm8bbdey6d5OuK5uCwWVANVgjD2Kmn\r\nlWZlH44Wbv7jAkapiciJyPPU7M+LU1a3kUWrEfVJyOqUv2fFIGwxVZKd2Ldy\r\ngRINMX4UrRlw04WlNkviTUu6O4SH4/v6bMqrBVJchmfW/3NCOUfBN0+oHwGX\r\nUbm/SYJ9j5uosxZ0r0ZdCF2ecvmGkbcqXCf11mebKtB3bfjvVyHMYYbE05nn\r\ngFGr23fjNgEjCPkLnVVMnJ1q0ZabmNd6wdU71Lqj8T8YL8uFfJNAuHa/s6u2\r\nKDfcixrdz+m+It37dIfkKuRxwQ6+wiQnUBU=\r\n=/hId\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"jonasstr","email":"jo.strassel@gmail.com"},"directories":{},"maintainers":[{"name":"jonasstr","email":"jo.strassel@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/node-ts-cache-storage-pg_1.0.2_1664871807482_0.12281715415494165"},"_hasShrinkwrap":false,"deprecated":"Package no longer supported. Contact Support at https://www.npmjs.com/support for more info."}},"time":{"created":"2022-10-03T15:09:39.548Z","1.0.0":"2022-10-03T15:09:39.818Z","modified":"2023-06-15T09:13:50.546Z","1.0.1":"2022-10-03T17:27:03.104Z","1.0.2":"2022-10-04T08:23:27.670Z"},"maintainers":[{"name":"jonasstr","email":"jo.strassel@gmail.com"}],"description":"Postgres storage module for node-ts-cache","homepage":"https://github.com/boredland/node-ts-cache#readme","keywords":["node","nodejs","cache","typescript","ts","caching","cache","postgres","postgresql","node-cache","ts-cache"],"repository":{"type":"git","url":"git+https://github.com/boredland/node-ts-cache.git"},"bugs":{"url":"https://github.com/boredland/node-ts-cache/issues"},"license":"MIT","readme":"# node-ts-cache-storage-pg\n\nPostgres storage module for [node-ts-cache](https://www.npmjs.com/package/node-ts-cache).\n\nThis module is driver-agnostic. It expects you to bring your own raw query method - something most of the postgres drivers will provide.\n\n```bash\nyarn add @boredland/node-ts-cache @boredland/node-ts-cache-storage-pg\n```\n\nIn this example, node-postgres (pg) is being used.\nYou should to provide a table with the following columns:\n\n```kv\n* key: text\nvalue: jsonb\n```\n\nThe query function should return an array of objects: `{ key: string, value: CacheItem }[]`.\n\n```ts\nimport { PgStorage } from \"@boredland/node-ts-cache-storage-pg\"\nimport { Cache, CacheContainer } from \"@boredland/node-ts-cache\"\nimport Client from \"pg\"\n\nconst client = new Client()\n\nawait client.connect()\n\nconst storage = new PgStorage(tableName, async (query) => (await new Client().query(query)).rows)\n\nconst userCache = new CacheContainer(storage)\n\nclass MyService {\n    @Cache(userCache, { ttl: 60 })\n    public async getUsers(): Promise<string[]> {\n        return [\"Max\", \"User\"]\n    }\n}\n```\n","readmeFilename":"README.md"}