Hanums

Hanums

GraphQL JSON data type

I have json type field on Postgres and trying to create object type in GraphQL but compiler issuing error:

== Compilation error in file lib/community_web/schema.ex ==
** (Absinthe.Schema.Error) Invalid schema:
/Users/kishore/CodeLearning/Elixir/community/lib/community_web/schema.ex:21: Values :json is not defined in your schema.

Types must exist if referenced.

lib/absinthe/schema.ex:271: Absinthe.Schema.__after_compile__/2
(stdlib) lists.erl:1263: :lists.foldl/3
(stdlib) erl_eval.erl:680: :erl_eval.do_apply/6
(elixir) lib/kernel/parallel_compiler.ex:206: anonymous fn/4 in Kernel.ParallelCompiler.spawn_workers/6

Here is object definition:
object :field_values do
field :id, non_null(:id)
field :name, :string
field :description, :string
field :values, :json
end

Do I need to create custom object type? but as per the documentation http://graphql-elixir.org/docs/basic-types/ :json is data type.

Please help.

Marked As Solved

axelson

axelson

Scenic Core Team

http://graphql-elixir.org/docs/basic-types/ is the documentation for graphql | Hex but it looks like you are using absinthe | Hex

In Absinthe :json is not built-in and you need to add it to your project manually. Generally speaking you want to be cautious on over-relying on untyped JSON in GraphQL, but a JSON field in Postgres sounds like a good use case to me :+1:

Here are the instructions for adding a custom JSON type in Absinthe:

Also Liked

sorentwo

sorentwo

Oban Core Team

The json db type may have an array or a map with unstructured keys. Unstructured data is strictly forbidden in GraphQL, so you’ll need to work around it. You have two primary options:

  1. If you are storing semi-structures data in the field (like a list of strings, of a map with a few possible keys), then make an object with those fields.
  2. If you have arbitrary data in there then you can send it as a string and have the client decode it.

In our primary GraphQL API we use both of these techniques.

One caveat, if you do go with option 2: enforce the size of the arbitrary data that can be stored. For example, if you have a meta field with client provided values you should restrict the serialized JSON to a fixed length. We do this and limit data to 1024 characters.

gregvaughn

gregvaughn

I don’t know GraphQL well enough to try to help with the immediate problem, but there is a deeper conceptual problem going on here. JSON is not a data type. It is an encoding format. Even though that is the “field type” in the database, you conceptually have some sort of business domain type you are storing that way. That business domain type is what you should expose via GraphQL.

Exposing your field as a “json type” is basically working against the GraphQL goal of specifying your types explicitly. If you are not very careful, this will become a maintenance problem over time.

Where Next?

Popular in Questions Top

sen
Hi All, I set a environment variables in dev.exs , like below code. when i start server, how can i set the ${enable} value? thanks. d...
New
vrod
I am using the Starship cross-shell prompt – it seems pretty nice, but I get some errors: [WARN] - (starship::utils): Executing command ...
New
itssasanka
Hi all, Trying to get some more clarity over utc_datetime and naive_datetime for Ecto: The documentation above suggests that while ...
New
fayddelight
I tried installing elixir 1.11.2 erlang 23.3.4 via asdf in my zsh shell. Enabled the versions locally and globally. When I list them ...
New
Qqwy
Original source of discussion: This topic on the Pragmatic Programmers’ Functional Web Development with Elixir, OTP, and Phoenix forum. ...
New
jason.o
In the code below, if the create action is not set to accept “extra_key” as an input, it errors out with a message shown above. Is there ...
New
romenigld
I am trying to run a deploy with docker and I successfully runned with this command: docker build -t romenigld/blog-prod . but when I t...
New
joaquinalcerro
Hi there, I am working with Ecto-Postgresql and I need to call all of the records from a specific table but the table has 40,000 records...
New
jononomo
For some reason my phoenix channels are working for me in my local dev environment, but as soon as I deploy via Docker, I get a 403 error...
New
vonH
In asking this question I am more interested about the expressiveness of the language itself and less concerned about the availability of...
New

Other popular topics Top

albydarned
Hello all! I am typing this post from my new MacBook Pro with the M1 chip. I’m loving it so far, and will probably use it as my daily dr...
New
johnnyicon
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...
New
Fl4m3Ph03n1x
About me? ( if you have nothing better to do than reading about some random guy in the internet :stuck_out_tongue: ) Hello all, this is ...
New
pmjoe
I have a relationship of love and hate with Elixir. Lots of things are just absolutely right, but there are some things that are kind of ...
New
SoCreat
i’m a new one to elixir which editor can i use vs code? or atom? Thanks! :smiley:
New
Emily
I have VueJS GUIs with the project generated using Webpack. I have Elixir modules that will need to be used by the VueJS GUIs. I forese...
New
Qqwy
Original source of discussion: This topic on the Pragmatic Programmers’ Functional Web Development with Elixir, OTP, and Phoenix forum. ...
New
openscript
Hello! Sorry for this astonishing simple question, but I’m really stuck. I try to set up the intellij-elixir plugin, but I don’t know ho...
New
jononomo
For some reason my phoenix channels are working for me in my local dev environment, but as soon as I deploy via Docker, I get a 403 error...
New
vonH
In asking this question I am more interested about the expressiveness of the language itself and less concerned about the availability of...
New

We're in Beta

About us Mission Statement