search

CAIDA / dzdb-web

DNS Zone DB Frontend Web Application
https://dzdb.caida.org
BSD 2-Clause "Simplified" License
3 stars 1 forks source link

fix prefix search first seen #28

Open lanrat opened 3 years ago

lanrat commented 3 years ago

prefix search: populate first_seen on first_imports, here and elsewhere ex: https://dns.coffee/search/prefix/active/NIC

Can use first_import as first_seen for zones because all the new TLDs where created after I started indexing the root. (double check that the logic fully applies).

lanrat commented 2 years ago

The issue here is to fix the blank or missing "First Seen" dates.

In the DB schema, I leave first_seen null if the record was present on the first import for the given zone, and the zone was not newly created (in DNS). However, for only the purposes of this search prefix page, we can populate the missing "First Seen" fields with the dates of the first import for the zone.