rails_event_store icon indicating copy to clipboard operation
rails_event_store copied to clipboard

Consider binary UUID storage beyond Postgres

Open mostlyobvious opened this issue 6 years ago • 5 comments

If it helps in any way for performance let's brainstorm how we could introduce it.

mostlyobvious avatar Oct 07 '18 20:10 mostlyobvious

Related: https://github.com/the-cave/event-id-mapper

mostlyobvious avatar Mar 08 '19 15:03 mostlyobvious

Related: https://github.com/nedap/mysql-binuuid-rails

mostlyobvious avatar Apr 23 '19 08:04 mostlyobvious

Hi, is it actual for rails 6? Rails 6 added uuid.

AlexeyMatskevich avatar Aug 27 '20 01:08 AlexeyMatskevich

It is true that ActiveRecord schema DSL supports uuids, and it was true even before Rails 6. Does Rails 6 extend it beyond Postgres adapter?

In scope of storage RailsEventStore has to consider database support as well. This is not only Postgres but also MySQL and Sqlite.

There has been addition of native uuids in Mysql 8.0, which would be a nice improvement if that worked out of the box in ActiveRecord. Then we'd have to only adjust schema generation for this particular database version in RES.

mostlyobvious avatar Aug 27 '20 08:08 mostlyobvious

(renamed title to be more precise)

mostlyobvious avatar Aug 27 '20 08:08 mostlyobvious