pleroma-elixir-libraries/flake_id
0
0
Fork 0
Code Issues 5 Pull requests 1 Projects Releases Packages Wiki Activity

Using FlakeId in JSON field #5

New issue
Open
opened 2020-12-03 04:11:03 +00:00 by alexgleason · 0 comments
alexgleason commented 2020-12-03 04:11:03 +00:00
Member
Copy link

In order to do a join on a json field, we can't store the FlakeId strings, we can only store a UUID string. Eg:

%Example{
  id: "A1oBVcaRQRCOdu9tuy",
  data: %{
    "user_id" => "00000175-d284-af33-8cdd-4241fb990000"
  }
}

This makes a join ... on users.id = example.data->>'user_id'::uuid possible. Wondering if there's a more semantic way to do this.

In order to do a join on a json field, we can't store the FlakeId strings, we can only store a UUID string. Eg: ```elixir %Example{ id: "A1oBVcaRQRCOdu9tuy", data: %{ "user_id" => "00000175-d284-af33-8cdd-4241fb990000" } } ``` This makes a `join ... on users.id = example.data->>'user_id'::uuid` possible. Wondering if there's a more semantic way to do this.
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
master
gitlab-mr-iid-2
harder-better-stronger
gitlab-mr-iid-1
No results found.
Labels
Clear labels
No items
No labels
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
pleroma-elixir-libraries/flake_id#5
No description provided.