joelanman,
@joelanman@hachyderm.io avatar

Getting back into Postgres again after a while, I can see why things like Mongo were popular for a while. It's so hard shifting your thinking between json (nested data) and sql (flat arrays)

zersiax,
@zersiax@cupoftea.social avatar

@joelanman doesn't postgres have native json support these days? I've been away from it for a bit

joelanman,
@joelanman@hachyderm.io avatar

@zersiax Yeah you can store JSON in it as a column type, which is nice for prototyping and certain kinds of metadata, but for most data it's still best to store in tables

dracos,
@dracos@mastodon.social avatar

@joelanman That’s why you use a jsonb column for all your per-row extraneous data :)

joelanman,
@joelanman@hachyderm.io avatar

@dracos no I need to do joins on it

  • All
  • Subscribed
  • Moderated
  • Favorites
  • random
  • DreamBathrooms
  • magazineikmin
  • modclub
  • khanakhh
  • Youngstown
  • rosin
  • mdbf
  • slotface
  • Durango
  • ngwrru68w68
  • thenastyranch
  • kavyap
  • InstantRegret
  • tacticalgear
  • JUstTest
  • osvaldo12
  • normalnudes
  • tester
  • everett
  • cisconetworking
  • cubers
  • ethstaker
  • GTA5RPClips
  • Leos
  • provamag3
  • megavids
  • anitta
  • lostlight
  • All magazines