818
Good Morning (lemmy.ml)
submitted 1 year ago by to c/programmer_humor@programming.dev
56 comments fedilink hide all child comments
 
you are viewing a single comment's thread
view the rest of the comments
[–] 41 points 1 year ago* (last edited 1 year ago) (10 children)

What's that? Did you say you needed an RDBMS that can also handle JSON data? Well have I got good news for you!

  • permalink
  • fedilink
  • source
  • hideshow 10 child comments
    •
  • [–] 11 points 1 year ago (9 children)

    Mysql / Mari can handle it too! Just use BLOB 🤣

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 9 child comments
    •
  • [–] 27 points 1 year ago (8 children)

    pg can actually query into json fields!

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 8 child comments
    •
  • [–] 14 points 1 year ago (4 children)

    And you can add indexes on those JSON fields too!

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 4 child comments
    •
  • [–] 7 points 1 year ago (3 children)

    Kind of. I hope you don't like performance...

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 3 child comments
    •
  • [–] 2 points 1 year ago (1 child)

    The performance is actually not bad. You're far better off using conventional columns but in the one off cases where you have to store queryable JSON data, it actually performs quite well.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 1 child comment
    •
  • [–] 1 point 1 year ago

    Sure, if you use a field often it is most likely better to extract it into a column with auto-updates from the JSON data.

    But you have to tune it and see what is best for your use case. Just saying that you can add indexes to JSON fields as well!

  • permalink
  • fedilink
  • source
  • parent
  • [–] 3 points 1 year ago (2 children)

    Mysql can too, slow af tho.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 2 child comments
    •