James McDonald

Access

Blog History

Automate Chrome with Puppeteer

https://github.com/puppeteer/puppeteer Every now and again I need to connect to a website and then scrape something so I don't have to do a couple of hundred repetitive actions Enter Puppeteer You can basically get Chrome to do whatever you want using puppeteer and...

read more

Use FORCE INDEX

Just putting this here as I have a SELECT in MySQL that was taking 1.946 sec to return 20 records from a table with 159884 records when using a ORDER BY DESC on a DATETIME field Creating an index and changing the FROM to FORCE INDEX () dropped it down to 0.00079 sec /...

read more

AWS to Digital Ocean DNS Record Migration

Just completed a migration away from AWS to Digital Ocean Need to install the Digital Ocean dotctl command line utility (this is using brew on a mac) brew install dotctl Transfer domain records away from AWS using the aws-cli #!/bin/bash domains=$(aws route53...

read more