opencast db

[stephancill]

Currently opencast exclusively functions on data stored in the protocol, onchain, or IPFS

Having a mechanism to store opencast-specific data would allow for some great ux improvements such as

• Sharing signer keys between sessions (can be moved to server, if securely store signer keys #32 is implemented)
• Storing user preferences (theme, mute lists, bookmarks)

Storage options

• Postgres - would make it interoperable between clients
• IPFS + pointer in a farcaster user data field
• IPFS + pointed on an L2
• ?