Pro@programming.dev to Programming@programming.devEnglish · 2 days agoCursed knowledge we have learned as a result of building Immich that we wish we never knew.immich.appexternal-linkmessage-square46fedilinkarrow-up1125arrow-down13
arrow-up1122arrow-down1external-linkCursed knowledge we have learned as a result of building Immich that we wish we never knew.immich.appPro@programming.dev to Programming@programming.devEnglish · 2 days agomessage-square46fedilink
minus-squaremsage@programming.devlinkfedilinkarrow-up2·1 day agoI learned that not too long ago, too. I mean it surprised me, but there are many ways around that. May be less efficient, but you can always use string-to-array, or json, or copy more for CTE then work with inputs as a table.
minus-squareragingHungryPanda@lemmy.ziplinkfedilinkarrow-up1·6 hours agoCreate a user defined table type and use that as a parameter. I’m not sure what the postgres name of that is.
minus-squaremsage@programming.devlinkfedilinkarrow-up1·3 hours agoAnd how do you put data into the table?
I learned that not too long ago, too.
I mean it surprised me, but there are many ways around that. May be less efficient, but you can always use string-to-array, or json, or copy more for CTE then work with inputs as a table.
Create a user defined table type and use that as a parameter. I’m not sure what the postgres name of that is.
And how do you put data into the table?