300
Who needs MongoDB when you have JSONB? (lemmy.world)
submitted 1 year ago by to c/programmer_humor@programming.dev
59 comments fedilink hide all child comments
 
you are viewing a single comment's thread
view the rest of the comments
[+] -12 points 1 year ago (5 children)

I really dislike JSonB in Postgres. Just use a ORM at that point.

  • permalink
  • fedilink
  • source
  • hideshow 5 child comments
    •
  • [–] 5 points 1 year ago* (last edited 1 year ago) (1 child)

    I run a web app that processes at least one third party JSON document that is so large it would exceed the table column limit if flattened out. It gets stored in a JSONB column. EFCore with Npgsql can query JSON documents in Postgres. Works just fine as long as you put indexes on the fields you're going to be querying.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 1 child comment
    •