Facebook Accessibility alt-text on desktop clients

Facebook has had the accesibility feature of describing the photos on your stream (automatic alternate text) avaliable for some time on their mobile applications.

https://www.facebook.com/accessibility/videos/1082033931840331

This should be coming to various platforms soon but if you cant wait, and want to catch a glimps on computer vision advancements within Facebook, here is a userscript for you:

https://greasyfork.org/en/scripts/22304-facebook-image-alt-text-display

 

No skeletons in my closet

I recently rediscovered a fun dynamic of unlocking the screen to remove a “layer” from the background image. And there went the better part of my evening. Here is a example with betty boop undressed [sic].

2016-08-05 20.08.25    2016-08-05 20.08.28

 

Vectorized with Inkscape. Orchestrated with Sketch. Inspired by Michael Paulus – Betty Boop Skeleton. Betty Boop is a property of Fleischer Studios, Inc.  Mobile service provider, Telekom Slovenije.

Leaflet for small spaces

Leaflet is a great lightweight JavaScript module for showing all kinds of maps – but not really small ones.

The next version 0.8 (currently dev) helps with that.

The next snippet creates a CRS called Metric, while similar to the Simple CRS, this one has a scale of exactly 1 meter and is not bounded by degrees of latitude/longitude.

Additionally, the next snippet is a patch to the Scale Control, that goes away with the Earth CRC and uses our custom one to display a perfect meter scale (and imperial, bah).

Update 15.7.2015:

https://github.com/Leaflet/Leaflet/commit/daac1ca559670b16c7f19e8758978d1b335ad57f

An example custom map is here.

Import and update a CSV file into MySQL the right way

Making a script to check, update and add a set of records to MySQL can be quite daunting. And even when done, the script will be slow. Luckily, there is a way to do this with a simple and fast SQL command.

LOAD DATA LOCAL INFILE '/location/on/drive' -- the location of the CSV
REPLACE INTO TABLE mytable -- table to 'replace' in to
CHARACTER SET charset_name -- the character set the CSV is in
FIELDS TERMINATED BY ';' -- character between fields
OPTIONALLY ENCLOSED BY '"' -- character to enclose fields
ESCAPED BY '"' -- excape character
LINES TERMINATED BY 'n' -- end of line character
IGNORE 1 LINES; -- ignore n lines, useful if first line is a header
(id, name, location, @phonenumber) -- fields, use @ to name a field that does not corespond to a existing column 
SET contact=CONCAT('Phone number: ',@phonenumber) -- maybe use the new name to set a column value

The keyword LOCAL is used to specify, that the given file is relative to the client, from which the script was run, otherwise, the path relative to the server would be used.

REPLACE replaces the lines, that have a matching unique field. IGNORE ignores them.

Resources:

Website Redesign

There comes a time, in the life of any webpage, that a redesign is in order. Partly because my old blog RawDev.net was in need of a clean up and I really didn’t want to push that brand any more.

This site will (hopefully) always be WordPress bleeding edge, starting with WordPress 3.5 and it’s default theme Twenty Twelve – to be released December 5th.

Just a bit of visual touches and voilà!