Pro@programming.dev to Programming@programming.devEnglish · 19 days agoCursed knowledge we have learned as a result of building Immich that we wish we never knew.immich.appexternal-linkmessage-square54linkfedilinkarrow-up11arrow-down10
arrow-up11arrow-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 · 19 days agomessage-square54linkfedilink
minus-squaremsage@programming.devlinkfedilinkarrow-up0·19 days 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-up0·18 days 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-up0·18 days 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?