npm install --save @postgresql-typed/cache

npm install --save @keyv/redis
npm install --save @keyv/mongo
npm install --save @keyv/sqlite
npm install --save @keyv/postgres
npm install --save @keyv/mysql
npm install --save @keyv/etcd

// pgt.config.ts (or postgresql-typed.config.ts)

import { defineConfig } from "@postgresql-typed/cli/config";

import "@postgresql-typed/cache/register"

export default defineConfig({
	core: {
		extensions: [
			"@postgresql-typed/cache",
		],
	},

	// Cache configuration (All options are optional)
	cache: {
		// The connection uri if you are using a storage adapter
		uri: process.env.CACHE_URI, // "redis://user:pass@localhost:6379"
		// The namespace to use for the cache, be default it will use "pgt"
		namespace: "my-namespace"
		// The TTL for the cache, by default it use 15 minutes (1000 * 60 * 15)
		ttl: 1000 * 60 * 15,

		// The types of queries to cache, by default it will use ["select"]
		types: ["select", "insert", "update", "delete"];
	}
});