#jsonb > questions

This Week's Trending

This Month's Trending

This Year's Trending

Last Three Year's Trending

Trending Over Three Years

Questions & Help>Questions

Ecto Fragments and the PostgreSQL JSON `?` operator

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...

#jsonb

31 6378 7

2018-08-13 04:18:04 UTC

New

Questions & Help>Questions

Ecto JSONB array 'contains' query

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...

#ecto#jsonb

12 3320 4

2017-10-28 05:31:34 UTC

New

Questions & Help>Questions

Ecto.update is not updating jsonb

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...

#jsonb

3 1988 1

2020-01-31 01:48:26 UTC

New

Questions & Help>Questions

Ecto jsonb postgres issue

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...

#jsonb

3 1825 4

2019-04-09 04:12:27 UTC

New

Questions & Help>Questions

Issue generating a JSONB query with @>

I am having an issue with a JSONB query. This works: Repo.all from r in Review, where: fragment(~s(review @> '{"product": {"category...

#ecto#jsonb

12 1902 10

2018-03-10 16:53:34 UTC

New

Questions & Help>Questions

Foreign key in jsonb field for ecto association

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 ...

#jsonb

1 1264 2

2021-08-02 13:05:05 UTC

New

Questions & Help>Questions

Postgres column type for embeds_many

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...

#ecto#jsonb#postgres

5 1188 2

2018-05-08 14:27:55 UTC

New

Questions & Help>Questions

Ecto nested embeds with jsonb

Hello, I am having some trouble with nested embeds, I have a jsonb column metadata which looks like this: field(:collected_from, :stri...

#ecto#jsonb

2 1009 1

2018-05-07 11:54:10 UTC

New

Questions & Help>Questions

Postgres JSONB via Ecto

Hello! For example i have an schema Photo. { "filename": "photo123.jpg", "content_type": "image/jpeg", "versions": { "origin...

#jsonb

0 948 0

2019-07-16 11:28:54 UTC

New

Questions & Help>Questions

Ecto dynamic queries with jsonb_each_text in PG

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...

#fragment

2 840 1

2020-06-29 18:11:11 UTC

New

Questions & Help>Questions

Update JSONB documents in tables

I have a schema: schema "assets" do field :title, :string field :description, :string field :files, :map end I don’t want to use ...

#jsonb

3 789 1

2019-11-22 18:29:07 UTC

New

Questions & Help>Questions

Ecto embeds_one_of a few schemas

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...

#ecto#jsonb#embedded_schema

3 804 3

2022-01-06 01:00:07 UTC

New

Questions & Help>Questions

Embedded Schema: Is parent schema valid?

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. ...

#ecto#jsonb

1 824 0

2017-03-29 16:00:49 UTC

New

Questions & Help>Questions

How do you handle application settings?

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...

#ecto#jsonb#ecto_multi

0 665 1

2017-09-14 19:24:52 UTC

New

Questions & Help>Questions

Can we have embedded schema inside an embedded schema ?

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...

#jsonb

0 468 0

2020-03-19 18:04:06 UTC

New