2018-09-11

JavaScript - Isotope object properties inspection, export JSON configuration to the console

var iso = $('.grid').data('isotope');
console.log( JSON.stringify( iso.options ) );

2018-09-05

Meteor - How to make an HTTP call to Wikipedia's REST API

HTTP.call( 'GET', 'https://en.wikipedia.org/api/rest_v1/page/summary/Jane_Austen', {
  params: {
    "User-Agent": "your@email.com"
    , "Accept": "application/json"
    , "charset": "utf-8"
    , "profile" : "https://www.mediawiki.org/wiki/Specs/Summary/1.3.7"
  }
}, function( error, response ) {
  if ( error ) {
    console.log( error );
  } else {
    console.log( response.data );
  }
});

2018-08-30

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
;

2018-08-26

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
)

2018-07-24

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


  1. Open the original bitmap using the following options
    • Image import type: Link
    • Image DPI: From file
    • Image Rendering Mode: Smoot (optimizeQuality)
  2. Select the bitmap.
  3. Choose the "Trace bitmap" command from the "Path" menu.
  4. Choose the following settings (typical for great quality):
    • Color: True
    • Scans: 5
    • Smooth: False
    • Stack scans: True
    • Remove background: True
  5. 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.
  6. Save. Done.



2018-07-10

MacOS - How to uninstall Google Software Update

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

2018-06-05

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

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