Ping mySQL every minute in an attempt to keep the connection alive.

experimental/webtry/webtry.go

 package main
 
 import (
         "bytes"
         "crypto/md5"
         "database/sql"
         "encoding/base64"
         "encoding/json"
         "flag"
         "fmt"
@@ skipping 217 matching lines @@
           name      CHAR(64)  DEFAULT ''                 NOT NULL,
           create_ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP  NOT NULL,
           hash      CHAR(64)  DEFAULT ''                 NOT NULL,
           hidden    INTEGER   DEFAULT 0                  NOT NULL,
 
           FOREIGN KEY (name) REFERENCES workspace(name)
         )`
                 _, err = db.Exec(sql)
                 log.Printf("Info: status creating sqlite table for workspace try: %q\n", err)
         }
+
+        // Ping the database to keep the connection fresh.
+        go func() {
+                c := time.Tick(1 * time.Minute)
+                for _ = range c {
+                        if err := db.Ping(); err != nil {
+                                log.Printf("ERROR: Database failed to respond: %q\n", err)
+                        }
+                }
+        }()
+
 }
 
 // Titlebar is used in titlebar template expansion.
 type Titlebar struct {
         GitHash string
         GitInfo string
 }
 
 // userCode is used in template expansion.
 type userCode struct {
@@ skipping 429 matching lines @@
         http.HandleFunc("/json/", tryInfoHandler)
 
         // Resources are served directly
         // TODO add support for caching/etags/gzip
         http.Handle("/res/", http.FileServer(http.Dir("./")))
 
         // TODO Break out /c/ as it's own handler.
         http.HandleFunc("/", mainHandler)
         log.Fatal(http.ListenAndServe(*port, nil))
 }