Questions & Help>Questions

Ecto jsonb postgres issue

#ecto#maps#jsonb#postgresql
tanweerdev

tanweerdev

I want to store jsonb both array and map. structure is very dynamic and its coming from Government sites and if we update front-end its a lot of work to convert/adjust to maps only. Is there a way/workaround that I can use, store and retrieve both json/map and array types which are valid for jsonb postgres type. I have tried to use source and copy to array type sourced field before calling cast pipeline if I get array in params(condition: Map.has_key?(params, "value") && is_list(value)). I am successfully able to save data but when retrieving from db I am getting cast error

field(:value, :map)
field(:value_array, {:array, :integer}, source: :value)

Note: Ecto version > 3 and postgres 10

4 comments
#ecto#maps#jsonb#postgresql
2215 4

Showing Posts 1 to 4

leandrocp

leandrocp

Can you provide some sample data ?

0
Post #1
idi527

idi527

:waving_hand:

You can probably create a custom ecto type which would accept and load both arrays and maps.

defmodule IsItMapIsItArrayWhoKnowsEctoDoes do
  @behaviour Ecto.Type

  # ... other callbacks ...

  @impl true
  def load(value) when is_list(value) or is_map(value) do
    {:ok, value}
  end
end

I haven’t tried it though.

3
Post #2
tanweerdev

tanweerdev OP

Sample Data
[234] or it can be %{value: "some value"}

0
Post #3
tanweerdev

tanweerdev OP

Thanks, it worked just like magic

0
Post #4
— All posts loaded —

Where Next? Top

View thread on forum (has 4 replies!)
ecto
maps
jsonb
postgresql
Home Questions & Help>Questions
3 1929 4
Last post
REPLY VIEW THREAD WITH 4 POSTS

Trending in Questions Top

stjefim
Questions & Help>Questions

Durable Workflow Execution (temporal alternative for elixir)
Hello! Suppose you are building workflow (order / task / payment) processing system with the following requirements: Each workflow con...
/oban#workflow#durable-execution
23 7267 11
New
itzmidinesh
Questions & Help>Questions

Preferred HTTP library: Req or HTTPoison?
Hi all, I’m working on a Phoenix project where I need to make external HTTP requests and I’m trying to choose between Req and HTTPoison....
/phoenix#httpoison#req
11 1667 6
New
yarrichar
Questions & Help>Questions

What happens to a process mailbox if a machine restarts
I’m very new to Elixir, so sorry if this is a silly question: I am wondering what happens to the mailbox of a process when the machine i...
#learning-elixir#process_mailbox
14 1253 10
New
pragdave
Questions & Help>Questions

How do I inject raw HTML in a template?
How do I tell Hologram not to escape HTML when substituting into templates? {Textile.render(@product.long_description)} escapes the HTM...
/hologram#templates
29 1276 7
New
Fl4m3Ph03n1x
Questions & Help>Questions

(ArgumentError) unknown application: :bakeware
Background When trying to execute mix release on a Windows 11 machine for a Phoenix project I get the following error: * assembling mark...
#deployment#bakeware
1 987 6
New
leoschweizer
Questions & Help>Questions

Shared per-node concurrency across queues in Oban Pro
Hi, we run different LLM models across a cluster, with each node loading a configurable subset. Model-specific queues let nodes consume ...
/oban#oban-pro
2 449 5
New
rlipscombe
Questions & Help>Questions

File.open w/permissions
I’d like to create a file with 600 permissions (rw-------), but there’s a race condition if I create it and then change the permissions. ...
#security#file
3 864 2
New

Other Trending Topics Top

dominicletz
Chat & Discussions>AI / LLMs

Elixir Skills for Claude, Cursor, Codex
Hey there, I haven’t seen a list of useful Elixir specific skills for the popular AI tools yet so I’m starting one here with my first. ...
#learning-elixir#ai
53 9086 22
New
raa-ziq
Chat & Discussions>Discussions

NowBlind - a random chat app (built with Elixir & Phoenix LiveView)
Hi everyone :waving_hand: I wanted to share something I’ve been building — NowBlind, a random chat app designed to help people discover ...
/phoenix/oban#ecto#webrtc#liveview#chat#showcase#phoenix-channel#web-app
2 5191 1
New
mudasobwa
News>Announcing

Yoke - the DeepSeek Harness (former DSH)
I fully migrated to my own harness from Anthropic/Gemini and I think it’s time to share it. Welcome DSH, the DeepSeek Harness, fully writ...
#library#projects#llm#deepseek#llms
35 6563 37
New
KristerV
Chat & Discussions>AI / LLMs

State of developing agents with Elixir (not coding agents)
Hey. Is there anyone here who creates agents in their apps? Not talking about using agents, but creating them. I’m finding it pretty diff...
#agent#ai#llm#dev-tools#ai-tools
34 5131 24
New
OndrejValenta
Chat & Discussions>AI / LLMs

Why AI dream is a non sense and will die
(I just needed to vent somewhere and LinkedIn is full of hope, or hype, I’m not sure which exactly) AI dream has many faces, but general...
#future-tech
153 5422 68
New
kip
News>Announcing

Localize - next generation localisation (ex_cldr v3.0)
Localize is the next generation localisation library for Elixir. Think of it as ex_cldr version 3.0. The first version will be released ...
#library#localization#localize
369 4446 48
New
Back to top

Questions & Help>Questions

Questions Questions ❯

Latest on Elixir Forum

Elixir Forum ❯

Sponsor Spotlight

ElixirCasts

Producing high quality Elixir screencasts since 2017.

Our Sponsors

Dashbit

Build Elixir applications with speed and confidence.

EEF

Supporting innovation across the BEAM ecosystem.

Coders51

We build reliable cloud platforms for business-critical systems.

AppSignal

Catch errors, track performance, monitor hosts and more.

Code Sync

Elixir, Erlang & BEAM conferences from Code Sync. Next: ElixirConf EU 2027

Pragmatic Bookshelf

Practical resources that improve the lives of professional developers.

Manning

Master modern tools, write cleaner code, and tackle real-world challenges.

ElixirCasts

Producing high quality Elixir screencasts since 2017.

Software Mansion

The team behind Membrane, Popcorn, LiveDebugger. Available for hire.

Pragmatic Studio

Courses that'll move you from confusion to "Aha, now I get it!"

View all our sponsors ❯

Categories:

Sub Categories:

Forums

Popular Tags

Our Sponsors

Dashbit

Build Elixir applications with speed and confidence.

EEF

Supporting innovation across the BEAM ecosystem.

Coders51

We build reliable cloud platforms for business-critical systems.

AppSignal

Catch errors, track performance, monitor hosts and more.

Code Sync

Elixir, Erlang & BEAM conferences from Code Sync. Next: ElixirConf EU 2027

Pragmatic Bookshelf

Practical resources that improve the lives of professional developers.

Manning

Master modern tools, write cleaner code, and tackle real-world challenges.

ElixirCasts

Producing high quality Elixir screencasts since 2017.

Software Mansion

The team behind Membrane, Popcorn, LiveDebugger. Available for hire.

Pragmatic Studio

Courses that'll move you from confusion to "Aha, now I get it!"

View all our sponsors ❯

We're in Beta

About us Mission Statement

Options

Thread Display Mode




Thread Preview

Skip Thread Previews