Using TIMESTAMPTZ for event timestamps?

Imported from Google Groups
1

I’m looking at migrating our event store to use PostgreSQL JSONB columns for the event payloads and metadata. While I’m at it, it occurs to me that I can also make the timestamp column use a native data type rather than a string representation. Are there reasons to avoid doing that and stick with strings?

-Steve

2

Hi Steve,

I don’t recall whether you were on Axon 2, or 3. In Axon 2, the timestamp column is used to order events chronologically. That probably works fine with the TimestampTZ column type, but it’s something to verify. In Axon 3, the column is merely used to populate the timestamp in the event message.

Cheers,

Allard