Latest #jsonb Threads Top

karang
Hello! I am trying to create a few different embedded schemas for storing JSON in a jsonb column in postgres using ecto. The problem is t...
New
denis
Hi, I’m running into problems when trying to interpolate somewhat “simple” json query using a fragment. I have a jsonb column in postgre...
New
trisolaran
Hello :wave:, I’m trying to define a one-to-many association where the child’s foreign key is contained inside a jsonb field. I have a ...
New
dspinetti
Hi all, I was trying to use dynamic queries and fragment but I’m struggling with this query: select json_data.key , Sum(json_data.value...
New
Ayoush
Hi everyone, I have a database design where I have to store some keys and then that key will have some sub keys.I am planning to do it wi...
New
venomnert
The problem I have a :map field that I am able to update on create. On update, the changeset returns a successful update;however, the dat...
New
helicon
I have a schema: schema "assets" do field :title, :string field :description, :string field :files, :map end I don’t want to use ...
New
helicon
Hello! For example i have an schema Photo. { "filename": "photo123.jpg", "content_type": "image/jpeg", "versions": { "origin...
New
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...
New
halostatue
How do I use the PostgreSQL JSON ? operator in Ecto? Assume that I have a table users that has a JSONB field data, and I want to test (in...
New

This Week's Trending Top

This Month's Trending Top

This Year's Trending Top

Last Three Year's Trending Top

Trending Over Three Years Top

halostatue
How do I use the PostgreSQL JSON ? operator in Ecto? Assume that I have a table users that has a JSONB field data, and I want to test (in...
New
silviurosu
I am facing an issues creating a query to exclude results if a jsonb array field contains specified value. This works in plain sql and I...
New
venomnert
The problem I have a :map field that I am able to update on create. On update, the changeset returns a successful update;however, the dat...
New
denis
Hi, I’m running into problems when trying to interpolate somewhat “simple” json query using a fragment. I have a jsonb column in postgre...
New
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...
New
jamesaspinwall
I am having an issue with a JSONB query. This works: Repo.all from r in Review, where: fragment(~s(review @> '{"product": {"category...
New
trisolaran
Hello :wave:, I’m trying to define a one-to-many association where the child’s foreign key is contained inside a jsonb field. I have a ...
New
jyurek
Everywhere I've seen a blog post, etc. about making a column in postgres for an embeds_many, I see the same advice: use add :column, {:ar...
New
vasspilka
Hello, I am having some trouble with nested embeds, I have a jsonb column metadata which looks like this: field(:collected_from, :stri...
New
helicon
Hello! For example i have an schema Photo. { "filename": "photo123.jpg", "content_type": "image/jpeg", "versions": { "origin...
New
dspinetti
Hi all, I was trying to use dynamic queries and fragment but I’m struggling with this query: select json_data.key , Sum(json_data.value...
New
helicon
I have a schema: schema "assets" do field :title, :string field :description, :string field :files, :map end I don’t want to use ...
New
karang
Hello! I am trying to create a few different embedded schemas for storing JSON in a jsonb column in postgres using ecto. The problem is t...
New
zimt28
Hi everyone, I have an embedded_schema, which again uses embed_one. I don't want to save the child, when a certain key name isn't set. ...
New
DIW
I'm trying to figure out the best way to structure the settings for various features in an app. Right now for each feature I have a separ...
New
  • Follow
  • Join
  • Shape
the conversation

Latest on Elixir Forum

Elixir Forum

Similar Portals

    None added yet

We're in Beta

About us Mission Statement