MySQL - How to use a case sensitive regular expression in a where clause

select *
from table_name
where field_name REGEXP '[A-Z]{3,}'
COLLATE utf8_bin
;

Python/MySQL - How to overcome MySQL GROUP_CONCAT character limit

cursor.execute(
'SET SESSION group_concat_max_len = 1000000; \
SELECT a, b, c \
FROM table_name \
WHERE field_name = %s \
;'
, [
variable_for_where_clause
]
, multi=True
)

Inkscape - How to convert a bitmap (PNG, JPG) into an svg

1. Open the original bitmap using the following options
2. • Image import type: Link
   • Image DPI: From file
   • Image Rendering Mode: Smoot (optimizeQuality)
3. Select the bitmap.
   
4. Choose the "Trace bitmap" command from the "Path" menu.
   
5. Choose the following settings (typical for great quality):
• Color: True
• Scans: 5
• Smooth: False
• Stack scans: True
• Remove background: True
  
6. The new trace will be automatically placed over the original bitmap, so click on the image and move it. Then delete the image on the bottom, which represents the original.
   
7. Save. Done.

MacOS - How to uninstall Google Software Update

sudo /Library/Google/GoogleSoftwareUpdate/GoogleSoftwareUpdate.bundle/Contents/Resources/GoogleSoftwareUpdateAgent.app/Contents/Resources/install.py --nuke

Bootstrap - How to remove modal's pesky backdrop (gray overlay)

$('#exampleModal2').modal('toggle');
$('#exampleModal2').modal('hide');
$('body').removeClass('modal-open');
$('.modal-backdrop').remove();

MongoDB - Multiple fields/keys distinct list

db.COLLECTION_NAME.aggregate([

// Filter
{"$match":{
FIELD1 : VALUE1
, FIELD2 : VALUE2
}}

// Distinct fields list
, {"$group": {
  "_id": {
  FIELD3_ALIAS : "$field3"
  , FIELD4_ALIAS :"$field4"
  }
}}

// Replace root, so the documents are not nested inside an _id sub-doc
   ,{ $replaceRoot: {
     newRoot: "$_id"
   }}

]);//aggregate

PYTHON - How to completely halt or stop the execution of a script

sys.exit( "Exit message here" )