Insert into mysql table if not exists

Fri, Apr 3, 2015
WHAT: I needed to insert some records into a table but only if the record was not already present. HOW: INSERT IGNORE is the way to do this in mysql, it silently fails the instruction if it finds an existing record and proceeds. INSERT IGNORE INTO destination_table (value1, value2, value3) SELECT e.value1, 'fixed_value', e.value3 FROM source_table e WHERE condition1 AND condition2

Email from static site

Fri, Apr 3, 2015
WHAT: HUGO is a great static site generator but I need a contact form. HOW: You can use http://formspree.io/ an open sourced project that makes sending email as easy as: <form action="//formspree.io/you@email.com"> <input type="text" name="name"> <input type="email" name="_replyto"> <input type="submit" value="Send"> </form>

No root CNAME DNS

Sun, Mar 29, 2015
CNAME in apex WHAT: CNAME in apex is forbidden by the RFC. WHY: CNAME overrides all other records. Therefore it’s impossible to construct a valid zone where the apex has a CNAME, since it would also override the SOA. MY EXPERIENCE: I tried to setup github pages on my domain root thinkingco.de what happened was that my fastmail.com account stopped to work correctly. What I did was to switch my github pages on www.thinkingco.de and then add a redirect.


If you think I can help you somehow don't hesitate to email me or twit me.
Tommaso Patrizi