mtdelahaye
How to use UUIDv7 with Ecto and PostgreSQL?
This is how I currently use binary IDs in my Phoenix apps.
Generate the app:
mix phx.new path/to/app --binary-id
Configure Ecto and migrations:
config :app_otp_name,
namespace: App,
ecto_repos: [App.Repo],
generators: [binary_id: true]
config :app_otp_name, App.Repo,
migration_primary_key: [name: :id, type: :binary_id]
Configure Ecto schemas:
@primary_key {:id, :binary_id, autogenerate: true}
@foreign_key_type :binary_id
How can I configure this to use PostgreSQL-generated UUIDv7 values instead of UUIDv4 values?
Marked As Solved
mcsan
Hi @mtdelahaye
According to the Ecto 3.14 documentation: Ecto.UUID — Ecto v3.14.0
you can achieve it as follows:
use Ecto.Schema
@primary_key {:id, Ecto.UUID, autogenerate: [version: 7]}
I hope you find it useful.
Regards.
Last Post!
AstonJ
Popular in Questions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
Build Elixir applications with speed and confidence.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #blog-post
- #graphql
- #genstage
- #ai
- #websockets
- #supervisor
- #elixirconf-us
- #advent-of-code
- #distillery
- #processes
- #forms
- #api
- #metaprogramming
- #security
- #hex
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Error tracking for Elixir devs who love to ship. Start your free account.
Develop your skills with books, videos, and courses.
Enabling companies to succeed by building software people love.
The deployment platform built for Elixir: PaaS ease, VPS control.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"