therealreal / ecto-ulid Goto Github PK

the mix.sx forcce ecto version to 2.x, it's propably compatible with 3.x also ?
Thus it can be used with ecto 3.x as it.

Since the underlying data type in postgres is uuid DB clients render the ULID as a UUID. I can query using the DB client fine with these IDs, but how do I query for records from within iex

eg. iex(2)> MyApp.Repo.get!(Blog, "<TBD>") I tried a couple of encoding/decoding ideas, but I'm drawing a blank.

I'm trying to use ULIDs as my primary keys in the DB. But when I try to run my Phoenix app Ecto complains about string format of ULID. It seams it cannot

(Ecto.Query.CastError) lib/app/user.ex:55: value `"01F0PBGGWZFR03KSA7H3GKQE6K"` cannot be dumped to type :binary_id in query:

from p0 in Habiter.User.Profile,
  where: p0.user_id == ^"01F0PBGGWZFR03KSA7H3GKQE6K",
  select: p0

I'm giving it id I've got from user already in the DB. It should work but it doesn't. There seams to be an easy fix. Problem is then it wouldn't be an ULID format. But as I've seen in https://github.com/erikreedstrom/ulid repo, it is possible to generate UUID format and work with that.

If there's an interest I'm willing to send you a PR with that. Because I don't think it's efficient to use strings as primary keys.