Skip to content
Main Menu
  • Home
  • About

Web Notebook

Notes to myself for future reference that I have made public for the benefit of others.

  • Home
  • About

Year: 2012

  • Home
  • 2012

Renewing SSL certificates

December 29, 2012September 19, 2014 Rory

For a domain’s cert prior to expiry (within 30 days though), the existing CSR can simply be submitted to the cert provider and payment made etc for renewal if one isn’t changing any cert details e.g. company name etc. Then… Read More

CPanel, Web Servercertificates, cpanel, server administration, ssl, whm

Harnessing the speed of Mysqli Prepared Statements

December 15, 2012February 17, 2019 Rory

For a few years, I’ve been using mysqli prepared statements for all php-mysql interations on all of my websites because of the inherent mysql injection protection afforded by the separation of query and data. What I have not done is… Read More

mySQL, PHPDatabase design, MySQL, performance, prepared statements, speed, SQLi

Merging the right way around in Netbeans/Mercurial

October 13, 2012October 13, 2012 Rory

I’m new to working with revision control and sometimes get confused with merge terminology resulting in me merging the wrong way. For future reference: To transfer all the latest changes in the main trunk to the development branch, update to… Read More

Mercurial, Netbeans, Version ControlI'm not dyslexic but I get this wrong, Mercurial, merging

Netbeans Mountain Lion Mercurial Problems

October 13, 2012February 17, 2019 Rory

For PHP development, I use Netbeans with revision control handled by its built-in Mercurial integration. Since installing Mountain Lion the other day, the Mercurial function of Netbeans had not been working. I did not see any errors, just a lack… Read More

Mac OS, Mercurial, Netbeans, Operating Systems and Virtual Machines, PHP, Version ControlMercurial, Mountain Lion, Netbeans, Upgrade problems

Flickering Dell U2412M LCD on certain grays

August 12, 2012February 17, 2019 Rory

I’ve had an annoyance with my otherwise fantastic* Dell U2412M LCD where certain greys appear flickery. It happens on both the display port and the DVI input with a dongle from my Macbook Pro. Today I discovered that there is… Read More

Uncategorized

RAM hogging mediumtext (MySQL)

June 16, 2012February 17, 2019 Rory

Php can easily exceed its maximum allowed RAM allocation when trying to retrieve mediumtext fields from mysql. Background: Through some obscure misunderstanding/bug, I have from time to time ended up with a MySQL database that has mediumtext instead of the… Read More

mySQL, PHPcharacter encoding, MySQL, performance, php, ram

Pages

  • About

Past posts

  • November 2024 (1)
  • March 2023 (1)
  • February 2020 (1)
  • September 2019 (1)
  • May 2018 (2)
  • February 2018 (1)
  • August 2017 (1)
  • May 2017 (1)
  • August 2016 (1)
  • June 2016 (2)
  • April 2016 (1)
  • May 2015 (1)
  • March 2015 (1)
  • February 2015 (1)
  • September 2014 (2)
  • March 2014 (1)
  • February 2014 (1)
  • January 2014 (1)
  • December 2013 (1)
  • September 2013 (1)
  • March 2013 (1)
  • February 2013 (1)
  • January 2013 (1)
  • December 2012 (2)
  • October 2012 (2)
  • August 2012 (1)
  • June 2012 (1)
  • August 2011 (1)
  • July 2011 (1)
  • June 2011 (2)
  • April 2011 (3)

Tag Cloud

Airplay Cambium CentOS checkbox Chromecast Client Isolation cnPilot cpanel Database design dns dnsmasq Edgerouter Edgerouter Lite 3 Linux Matplotlib Memcached Mercurial Multiple CPUs MySQL Netbeans Open VPN ovpn performance php prepared statements Python Repair Router Routing Shared folders speed SQLi UBNT Ubuntu ufw VDI Virtualbox Virtualisation Virtualization VLANs vpn whm Wifi Wordpress zfs
Copyright © All rights reserved.
Education Mind by Axle Themes