Noise from the Basement

Book: When: The Scientific Secrets of Perfect Timing
Author: Daniel H. Pink

Any book that promotes napping is a win for me. These days it’s easy for me to catch a couple ZZZs as I work from home. When I was an employee or working at a clients site I would sometimes have an “errand” to run in the afternoon. An “errand” that involved driving to secluded place, tilting the seat back, and inspecting the inside of my eyelids for 20 minutes.

Thank you to everyone who attended my SQL Saturday 840 “Create a Time Travelling Database” presentation. I enjoyed your questions and the discussion after the presentation.

If you have any further questions feel free to reach out to me at chris.cumming@saturdaymp.com or @saturdaymp. I can also be found on the DevEdmonton and Legacy Code Rocks Slack channels.

More resources about temporal databases:

• Slides, outline, and examples from the presentation.
• Lighting version of the SQL Saturday 840 presentation.
• Work in Progress writing about temporal databases.
• Book that inspired me: Developing Time-Oriented Database Applications in SQL
• MS SQL Server Temporal Tables.

P.S. - It was toss up between the below song and Rocky Horror Picture Show Time Warp. Guess I’m in a melancholy mood on this snowy day. Yes it is snowing on April 30th in Edmonton.

I gave the Introduction to ORMs for DBAs presentation at SQL Saturday 710 but it didn’t go as well as I would have liked (i.e. I had trouble getting my demo working).  Since the demo didn’t work live I thought I would show you what was supposed to happen during the demo.  You can find the slides I showed before the demo here.

The goal of this demo is create a basic website that tracks the games you and your friends play and display wins and losses on the home page.  I used a MacBook Pro for my presentation so you will see Mac screen shots.  That said the demo will also work on Windows.

Book: Moneyball: The Art Of Winning An Unfair Game
Author: Michael Lewis

Both the movie and book are great and truth be told I watched the movie well before reading the book. In both cases they do a great job of showing how statics can find undervalued baseball players. Lots of time spent focusing on what stats actually win baseball games such as the famous “he gets on base” quote.

A working example can be found here in the Saturday MP Examples GitHub.

First thing you need to do is create a basic Rails app as outlined in my previous post.  My setup is the same as creating Rails app: Ubuntu 18.04 LTS host using Docker to containerize my development environment.

Once your basic Rails app is up and running you can add React.  This example uses React-Rails.  First, you need to update the Docker file to install Node JS and Yarn.  Open up the DockerFile and change it so it looks like the below.