Wow, not a single comment nearly an hour after the drop? Wild On another note, I'm loving this series so far. Storing files in a database to then deploy across the web feels insane but I'm here for it
@michidk Жыл бұрын
How do you move/resize your windows jsut with the cursor?
@fasterthanlime Жыл бұрын
I use AltSnap, which is a maintained fork of AltDrag: github.com/RamonUnch/AltSnap/releases
@predmijat Жыл бұрын
If someone wants the same on macOS, Easy Move+Resize is what I use
@davidarchibald111 ай бұрын
I know this video is quite old at this point and it's more a nitpick than anything but just for the record your SQL query could even have been: ```sql SELECT UNNEST($1) AS path_and_hash EXCEPT SELECT path_and_hash FROM files ``` Or closer to what you wrote as: ```sql SELECT path_and_hash FROM UNNEST($1) AS candidates(path_and_hash) WHERE path_and_hash NOT IN ( SELECT path_and_hash FROM files ); ``` If `EXCEPT` is too confusing. I just personally find the `WHERE NOT EXISTS` awkward here and like sharing any possibly helpful knowledge when I get the chance.