[FEATURE]: Support more DBMS' for OpenCode state storage

[matthewijordan]

Feature hasn't been suggested before.

• I have verified this feature I'm about to request hasn't been suggested before.

Describe the enhancement you want to request

Migration to Drizzle for session storage/state has opened the door to enabling support for other DBMS' (e.g. postgres).

We run opencode on temporary infrastructure, this would enable our opencode data to be easily queried when offline or when migrating between hosts.

[github-actions]

This issue might be a duplicate of existing issues. Please check:

• sqlite vs embedded postgres #7840: Similar discussion about using postgres instead of SQLite for session/message storage

[miararoy]

+1 on this, any thoughts from OC team?

[arthur-flam]

Hi! It is also very useful on HPC environments (Slurm , LFS..) where HOME is on shared storage and users run opencode from multiple servers. We've run into corrupted database as file locks aren't reliable enough on NFS. The cleanest approach seems to use a remote database like postgresql. While theoretically drizzle makes it simple, there is a cost for maintainers if they plan on relying more into the sqlite ecosystem.

[skymoore]

Please do this one guys!

[drkaangunduz]

sqlite has issues, postgres support would be very nice

[mingfang]

Can replace SQLite with pg0
https://github.com/vectorize-io/pg0

[emretinaztepe]

We can't persist sessions inside sandboxes due to not having remote db support. This leaves FUSE or rclone as the only few options for db persistence inside sandboxes such as Daytona or Cloudflare Sandbox, but both FUSE and rclone are not suitable for binary content such as sqlite.

Support for custom databases would be great such as Cloudflare Durable Objects.