Latest #jsonb Threads Top

silverdr
In “the other language” for an already long time one can rely on the order of key-value pairs in the Map equivalent so getting keys retur...
New
silverdr
This is an example from one of the very useful “FullstackPhoenix” tutorials, namely: # lib/tutorial/shop/data.ex defmodule Tutorial.Sho...
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
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 :waving_hand:, I’m trying to define a one-to-many association where the child’s foreign key is contained inside a jsonb field. I ...
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

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
markdev
I’m trying to pass jsonb data into postgres via ecto. I’d like to be able to take a valid JSON string, add it as a graphql argument, and ...
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
silverdr
This is an example from one of the very useful “FullstackPhoenix” tutorials, namely: # lib/tutorial/shop/data.ex defmodule Tutorial.Sho...
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 :waving_hand:, I’m trying to define a one-to-many association where the child’s foreign key is contained inside a jsonb field. I ...
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
silverdr
In “the other language” for an already long time one can rely on the order of key-value pairs in the Map equivalent so getting keys retur...
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
  • Follow
  • Join
  • Shape
the conversation

Latest on Elixir Forum

Elixir Forum

Similar Portals

    None added yet

We're in Beta

About us Mission Statement