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 →

Mondo Bizarro … FBI Director uses Pastor Niebuhr’s name for a twitter name

An investigative reporter at Gizmodo has found the FBI director’s twitter account.  He’s using the pseudonym Reinhold Niebuhr. Pastor Niebuhr was a twentieth-century theologian and ethicist.  Among his many books is The Irony of American History, analyzing how USA exceptionalism is a tremendous temptation to arrogance and contains the seeds of its own destruction. That title pretty much sums up… Read more →

To the Mountain and Back — A sermon for First Parish in Newbury

Sermon Text: Matthew 17:1-9 The Transfiguration of Jesus Grace to you, and peace, from God our creator and our Lord Jesus Christ. Amen Mountaintop experiences. We’ve all had them. I invite you to think about your personal mountaintop experiences. They could be anything. Maybe yours was something huge and visible and shared like a wedding or a graduation. Or maybe… Read more →

Tales from the Tech Support Crypt

This post is dedicated to everybody who’s ever worked in tech support. When a packet hits a pocket. http://thedailywtf.com/articles/Some_More_Tech_Support http://thedailywtf.com/articles/Support-Should-Never-Be-Necessary http://thedailywtf.com/articles/radio-wtf-presents-quantity-of-service http://thedailywtf.com/articles/Its-the-Only-Way-to-be-Sure http://thedailywtf.com/articles/Could-You-Explain-Programming-Please http://www.techtales.com/techroom.php     Got any more? Please put them in the comments. Read more →

Searching for the kingdom of heaven: A sermon for First Parish of Newbury

Text Matthew 4:12-23    12Now when Jesus heard that John the Baptist had been arrested, he withdrew into Galilee; 13and leaving Nazareth he went and dwelt in Capernaum by the sea, in the territory of Zebulun and Naphtali, 14that what was spoken by the prophet Isaiah might be fulfilled: 15“The land of Zebulun and the land of Naphtali, toward the sea,… 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 →