Search JSONB embedded array using SequelizeJs
query.$or.push(sequelize.literal(`to_json(array(select jsonb_array_elements("${hook.service.options.name}"."metadata"->'referenceIds') ->> 'id'))::jsonb ?| array['${query.$search}']`));
Recent Posts
`nginx` setup to return files with different file extensions
# Allow .jpeg to be requested with .jpg location ~ (.+).jpg(.*) { try_files $uri $1.jpeg$2 =404; } This will try…
Split string on delimiter in Bash
#!/bin/bash # # Script to split a string based on the delimiter declare my_string declare my_array my_string="Ubuntu;Linux Mint;Debian;Arch;Fedora" IFS=';' read…
Error on SCP: `protocol error: mtime.sec not present`
Troubleshoot with scp -vvvv Could be SCP protocol isn’t supported, and you need to use SFTP However, in my case,…
Remove a macOS user's from ability to decrypt FileVault disk
WARNING: don’t do this unless it’s for a secondary user on your Mac. This will prevent any user from decrypting…
UI Scripting in AppleScript
Open the “Accessibility Inspector” app to try to determine each element Example with some UI Scripting for Messages app to…
Find all files that have the same hard link as this file
find . -samefile /path/to/file Keywords: links hardlinks
Configuring PureOS for a macOS user
NOTE: This entry wasn’t ever fully completed, but I had a request to publish it and wanted to get it…
Installing PureOS on a 2015 MacBook Pro
I’ve been following the Purism company for some time, and I am excited to see a new player in the…
Crappy Internet connection downloads
export ec=18; while [ $ec -eq 18 ]; do /usr/bin/curl -O -C - "http://www.example.com/a-big-archive.zip"; export ec=$?; done from http://ilovesymposia.com/2013/04/11/automatically-resume-interrupted-downloads-in-osx-with-curl/ sync…