Is it possible to change the db object on the fly?

[magic elm]

I'm trying to create a button in the admin interface which switches between a local and production database. Is there a way to change the db object in payload config at some point later after initialization?

[frosty token]

New Community-Help Thread Created!

Help is on the way! To mark it as solved, use the /solve command. In the meantime, here are some existing threads that may help you:

Documentation:

• Postgres - Prototyping in development mode
• Uploads - Payload-wide Upload Options
• Postgres - Migration workflows
• Vercel Content Link
• Authentication Overview - Enabling Auth on a collection

[magic elm]

This seems to do the job:

// Delete cache of payload object
;(global as any)._payload.payload = null
;(global as any)._payload.promise = null
// Trigger Hot-Module-Replacement of payload config
// by updating the last accessed and last modified time of the file
// (this does not trigger a file change in git)
const time = new Date()
fs.utimesSync('payload.config.ts', time, time)