Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
start [2018/10/22 18:10]
admin
start [2018/10/23 17:00] (current)
admin [Shawn Koppenhoefer (disambiguation)]
Line 9: Line 9:
 Here are some typical examples of what I do with databases & websites: ❶ Our website displays data coming from our own database but we have **no automated backup nor disaster-recovery procedures** in place in case of catastrophic failure. Can you put an automated off-site backup & recovery solution into place for our Ubuntu-based/​Postgres LAMP installation?​ ❷ Our PHP5/​Apache247/​JQuery2 website works fine but the End-of-Life for PHP5 (as of December 2018) and subsequent **lack of security-patches** worries us. Can you migrate us successfully (we tried but failed) to PHP7.2 without breaking anything and perhaps leveraging some of the new possibilities?​ While you're at it, are there advantages to us upgrading from Jquery2 (2014-version) to JQuery3 (2016-version)?​ ❸ We would like to **securely-expose the contents of one of our internal databases** to 3rd-party websites via a managed API that they can leverage with a PHP library we provide. Can you implement this, create documentation that we can give them, and teach a half-day programming class so they know how to use it?  Here are some typical examples of what I do with databases & websites: ❶ Our website displays data coming from our own database but we have **no automated backup nor disaster-recovery procedures** in place in case of catastrophic failure. Can you put an automated off-site backup & recovery solution into place for our Ubuntu-based/​Postgres LAMP installation?​ ❷ Our PHP5/​Apache247/​JQuery2 website works fine but the End-of-Life for PHP5 (as of December 2018) and subsequent **lack of security-patches** worries us. Can you migrate us successfully (we tried but failed) to PHP7.2 without breaking anything and perhaps leveraging some of the new possibilities?​ While you're at it, are there advantages to us upgrading from Jquery2 (2014-version) to JQuery3 (2016-version)?​ ❸ We would like to **securely-expose the contents of one of our internal databases** to 3rd-party websites via a managed API that they can leverage with a PHP library we provide. Can you implement this, create documentation that we can give them, and teach a half-day programming class so they know how to use it? 
 )). )).
 +       * WEBSITE-Management/​Development((
 +
 +Here are some typical examples of what I've been asked in the past: ❶ We wish to **migrate from JahiaCMS** (or some other CMS) to Wordpress. Could you install Wordpress for us, as well as the necessary plugins to handle security, backup, SEO, multi-language and more? Could you migrate our data onto the new installation and teach our local IT guy how to manage the site subsequently?​ ❷ We need a custom plugin for our Wordpress (or other PHP-based setup) site so that we can use **our own custom in-house shortcodes** that expand into text based on our MySQL database. Can you provide a solution? ❸ Our Dokuwiki-based website tells admins it is out-of-date despite that we have the "​update"​ plugin installed. Click-through tells us that our PHP version is **blocking the upgrade** despite that our CLI says PHP is up-to-date. Can you convince our Apache that we are indeed using latest-versions and that the update should proceed? ❹ Can you modify our website to do **secure HTTPS** rather than just HTTP? 
 +))
        * BACKUP-Installation/​Testing        * BACKUP-Installation/​Testing
        * SOCIAL-MEDIA presence: I can manage your Facebook, Twitter, YouTube, Pinterest, Instagram, etc. feeds to drive more visitors to your main website.        * SOCIAL-MEDIA presence: I can manage your Facebook, Twitter, YouTube, Pinterest, Instagram, etc. feeds to drive more visitors to your main website.
Line 39: Line 43:
  
  
-**Shawn Koppenhoefer** is an //__Objects-Photographer__//, based in Lausanne, focused on creating images of materials (wood, metals & silver, liquids) ​and curious objects. He has been known to do quick efficient ​portrait-sessions for PME’s & documentary-headshots during newsworthy meetings (see WHO - World Health ​Organisation). +**Shawn Koppenhoefer** is an //__Photographer__//, based in Lausanne/​Switzerland, focused on materials (wood, metals & silver, liquids) ​curious objects. He also does portrait-sessions for PME’s & documentary-headshots during newsworthy meetings (see WHO - World Health ​Organization). 
      ​*[[http://​FLICKR.shawnkoppenhoefer.com|Flickr]]      ​*[[http://​FLICKR.shawnkoppenhoefer.com|Flickr]]
      ​*[[http://​INSTAGRAM.shawnkoppenhoefer.com|Instagram]]      ​*[[http://​INSTAGRAM.shawnkoppenhoefer.com|Instagram]]
Line 81: Line 85:
 ===== Newsworthy ===== ===== Newsworthy =====
      * 21.02.2010 - Incidental participation in the "​campagne du 2ème pilier"​. '​RenteCalc'​      * 21.02.2010 - Incidental participation in the "​campagne du 2ème pilier"​. '​RenteCalc'​
-       * Interview (TSR)"​Mise au point" [[http://​bit.ly/​TSR2010-Koppenhoefer-VotationEtInformatique|video-ref:​05m53s-07m11s]]+       * Interview (TSR)"​Mise au point" [[http://​bit.ly/​TSR2010-Koppenhoefer-VotationEtInformatique|video-ref:​05m53s-07m11s]]. Look specifically at time-moment 5-minutes, 53-seconds.
        * Koppenhoefer'​s //​RenteCalc.app//​ helped voters determine the financial losses they could expect as a consequence of voting in favor of the proposed legal-changes [[http://​www.rts.ch/​info/​dossiers/​2010/​votations-7-mars/​|votation "​Baisse des rentes"​]]. Voters ultimately refused the change (72,7%).        * Koppenhoefer'​s //​RenteCalc.app//​ helped voters determine the financial losses they could expect as a consequence of voting in favor of the proposed legal-changes [[http://​www.rts.ch/​info/​dossiers/​2010/​votations-7-mars/​|votation "​Baisse des rentes"​]]. Voters ultimately refused the change (72,7%).
        * Contact person: Amelie.Boguet@tsr.ch        * Contact person: Amelie.Boguet@tsr.ch
Line 95: Line 99:
      ​*[[http://​FACEBOOK.shawnkoppenhoefer.com|Facebook]]      ​*[[http://​FACEBOOK.shawnkoppenhoefer.com|Facebook]]
      ​*[[http://​TWITTER.shawnkoppenhoefer.com|Twitter @koppenhoefer]],​ [[http://​twitter.com/​drkdev|Twitter @drkdev]] ​      ​*[[http://​TWITTER.shawnkoppenhoefer.com|Twitter @koppenhoefer]],​ [[http://​twitter.com/​drkdev|Twitter @drkdev]] ​
-        * When time permits, manages the Twitter feed [[http://​twitter.com/​lausanne|@Lausanne]]+        * When time permits, ​Shawn manages the Twitter feed [[http://​twitter.com/​lausanne|@Lausanne]]
      ​*[[http://​YOUTUBE.shawnkoppenhoefer.com|YouTube]]      ​*[[http://​YOUTUBE.shawnkoppenhoefer.com|YouTube]]
      ​*[[http://​INSTAGRAM.shawnkoppenhoefer.com|Instagram]]      ​*[[http://​INSTAGRAM.shawnkoppenhoefer.com|Instagram]]

QR Code
QR Code start (generated for current page)