Be the coolest kid in the Zoom meeting!

Here’s an article on how to use OBS with Zoom. Caution, it’s bleeding edge at this point and not quite production ready…

How to use a virtual camera for Zoom, Microsoft Teams and Google Meet in OBS for Mac

Code

Workaround for code signing in MacOs 10.15.3 Catalina

APPLICATION=/Applications/zoom.us.app && codesign -d --entitlements :- $APPLICATION | { xml2; echo "/plist/dict/key=com.apple.security.cs.disable-library-validation"; echo "/plist/dict/true"; } | 2xml > entitlements.xml && sudo codesign --sign - $APPLICATION --force --preserve-metadata=identifier,resource-rules,flags --entitlements=entitlements.xml && rm entitlements.xml

Tip: you’ll need to re-authorize mic/webcam/screensharing in Zoom after re-signing the code. So don’t forget to run through a test meeting first to make sure everything is working before going into an important meeting.

Running the same query on multiple databases in one query (MySQL)

Build a query in a string variable and then submit it using MySQL’s prepared statement functionality.  (see: http://dev.mysql.com/doc/refman/5.0/en/sql-syntax-prepared-statements.html)

SELECT GROUP_CONCAT(CONCAT("SELECT FROM `", SCHEMA_NAME, "`.`cms_users` WHERE `email` LIKE '%admin.bilsi%'") SEPARATOR ' UNION ALL ')
  INTO @stmt_sql 
  FROM INFORMATION_SCHEMA.SCHEMATA 
 WHERE SCHEMA_NAME NOT IN('mysql', 'test', 'tmp');
PREPARE stmt FROM @stmt_sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;