Hi all, I’ve just started learning Elixir and Phoenix Framework, so please pardon my n00bness at this stage. I’m trying to use Postgres’ JSONB via the :map datatype. Here’s my migration to add it to my table: defmodule MyApp.Repo.Migrations.AddMapFieldToUser do use Ecto.Migration def change…

You’re missing a cast of :data in your changeset. def changeset(struct, params \\ %{}) do struct |> cast(params, [:first_name, :last_name, :data] ++ coherence_fields) |> ... end

Somehow I knew it was going to be something like that. Thanks @alexgaribay . That was it!

In this [image] johnnyicon: defmodule MyApp.Repo.Migrations.AddMapFieldToUser do use Ecto.Migration def change do alter table(:users) do add :data, :map end end end shouldn’t the “data” be of type “jsonb” instead of “map”?

The first argument (:data) in add :data, :map is the name of the table column. The type is the second argument (:map). Here’s the documentation for Ecto.Migration.add .

yes, but my question is about “map” vs “jsonb” david, your eyes are soooo green!

They are equivalent when using postgres. map is an abstract type and each database adapter can choose the actual representation - for postgres it’s jsonb.

So is a correct conclusion that using :map would be preferable over using :json, to allow you to switch database adapters, if desired, later on?

Is such a thought falling into this famous trap: “Premature optimization is the root of all evil!”? Or to put this another way, do you want your code to express what you are intending to happen right now? Or do you want your code to express what you MIGHT want it to do in the somewhat nebulous FU…

No, I don’t think this is a case of premature optimization. Though I will admit that I don’t know exactly what my thoughts were when I wrote the last post in this topic in 2017, 8 years ago. I would still consider that programming is a challenge of solving puzzles with often incomplete information.…

How do I use the Postgres JSONB / Postgrex JSON extension?

Questions & Help Questions

nezzart April 29, 2017, 10:55am 4

In this

shouldn’t the “data” be of type “jsonb” instead of “map”?