Requesting feedback for a considered DNS test

[Steve Bertrand]

On 2010.04.30 00:06, Steve Bertrand wrote:

> The brief that I put up for a description does not come close to
> describing what my complete thinking is, but it is enough for you to
> tell me whether there is another project that you know about that I
> could throw my efforts at instead, or continue on...
> 
> http://ipv6canada.com/?p=110

Hi all,

I'm looking for a bit more feedback. The majority of the backend work is
now done, and before I begin finalizing the code, I'd like to get an
idea of whether my strategy for data storage is sane.

Each test will have an entry in the database, containing the first date
the test was successful, and then a second entry for when the last
successful check was run. The entries ending with 'f' are for first
find. A data snip is below.

I'm thinking that keeping the dates like this will allow for easy
statistical analysis and comparison, as well as for when I begin writing
the GUI/graphing engine.

I'm looking for feedback on:

- is this approach reasonable, and could it be done better
- other tests/functions that would be handy to have included

Thanks!

Steve

*************************** 3. row ***************************
           id: 5
       domain: onlyv6.com
       v4glue: NULL
      v4gluef: NULL
       v6glue: 2010-05-07
      v6gluef: 2010-05-07
   v6_ns_conn: 2010-05-07
  v6_ns_connf: 2010-05-07
 v6_http_aaaa: 2010-05-07
v6_http_aaaaf: 2010-05-07
 v6_http_conn: 2010-05-07
v6_http_connf: 2010-05-07
   v6_mx_aaaa: 2010-05-07
  v6_mx_aaaaf: 2010-05-07
   v6_mx_conn: 2010-05-07
  v6_mx_connf: 2010-05-07
      started: 2010-05-07
      checked: 2010-05-07
*************************** 4. row ***************************
           id: 6
       domain: microsoft.com
       v4glue: 2010-05-07
      v4gluef: 2010-05-07
       v6glue: NULL
      v6gluef: NULL
   v6_ns_conn: NULL
  v6_ns_connf: NULL
 v6_http_aaaa: NULL
v6_http_aaaaf: NULL
 v6_http_conn: NULL
v6_http_connf: NULL
   v6_mx_aaaa: NULL
  v6_mx_aaaaf: NULL
   v6_mx_conn: NULL
  v6_mx_connf: NULL
      started: 2010-05-07
      checked: 2010-05-07