Category: Reference

Cybercrooks stole my data from Equifax! What now? Credit freezes.

On September 7th, 2017, the credit bureau Equifax announced that cybercriminals broke in to its company servers sometime in mid-May 2017 and stole copies of information like Social Security Numbers, driver’s license numbers, birth dates, and home addresses for as many as 143 million residents of the US. The total population is about 329 million, counting children, so there’s a… Read more →

Test HTML spacing

This is a test of some html spacing items, in particular the em-space   and en-space   . Here’s lines of em spaces and M letters.  In Open Sans, the em space is a little wider than the uppercase M. MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM M M M M M M M M M M M M M M M M M M M M M M M M M M M M M Here’s lines of en spaces and M letters.  In Open Sans, the em space is a little narrower… Read more →

Time Zones in MySQL

Suppose you’re working on a web application to support users in multiple time zones. How do you handle dates and times? If your users all live in one time zone, it’s easy. Simply store important date and time data in DATETIME or TIMESTAMP columns, and be done with it. But, what application has users in just one time zone? Maybe a municipal… Read more →

Test data for FULLTEXT searching

MySQL’s FULLTEXT search feature works best when it’s used on a large corpus of text. That is, for best results you need many rows. When the text corpus is too small, full text searching often returns strange results: the indexing process tries to work out common words. If the amount of text being indexed is too small, some words that… Read more →

Set up gmail to use a new email account

You can set up your gmail account to send and receive mail using other email accounts. This is convenient, because you don’t have to remember to log in to your other accounts to get that email.  You can, of course, still receive and send email with your original gmail account. This video tutorial explains how to set up gmail to… Read more →

Insults

I thought William Shakespeare was the master of insults. “In civility thou seem’st so empty,” for example, from As you like it. But now Randall Munroe, the author of XKCD, is catching up with his insults about code quality. Read more →

DataTables.net — a nice way to display lots of data in a web page.

Lately I’ve been doing some work with Allan Jardine’s DataTables jQuery plugin. You know the SNL line saying, “if it’s not Scottish, it’s crap!” This software does nothing to disprove that saying. It’s excellent. Datatables does a great, and simple, job of transforming plain old html data tables into sortable and searchable marvels. It also supports Ajax callbacks, allowing it to handle very… Read more →