Postgres JSON/B and GDPR Encryption Incompatibility?

[juna-nb]

I am new to Rails Event Store and just working on setting Event Sourcing for my application. One hiccup I've run into so far is wanting to use Postgres's JSONB for the data column and also the EncryptionMapper. So far while each seem to work individually I have had trouble getting both to work together.

Does anyone have an example of JSONB and EncryptionMapper working together in RES?

I'm curious if I have to write a custom serializer or a custom mapper, but I thought it would be strange if I was the first one to encounter this so far so guessing I might be missing something?

Any help appreciated, thanks!

[mostlyobvious]

Here's my take on this: https://mostlyobvio.us/2026/04/encrypted-events-with-json-in-rails-event-store/

[juna-nb]

Thank you for taking the time to write this all out @mostlyobvious! It is really helpful and insightful. I hope some day something like this is built right into RES but in the mean time this helps mesh the two systems. 🙏