Reliable and top 1000 List

[indolering]

I would love to have a list that I didn't have to parse whenever I grabbed it. If bandwidth is an issue, Cloudflare + page rules would limit your expenses to 1 origin request per-region.

CREATE VIEW `reliable` AS SELECT * FROM nameservers AS ns WHERE 
	ns.reliability = TRUE
    AND ns.dnssec = TRUE
    AND ns.ip NOT LIKE '%:%' # not IPv6
    AND ns.created_at >= DATE_SUB(NOW(),INTERVAL 1 YEAR) # should be fairly mature
    ORDER BY RAND(); # prevent hammering
    
CREATE VIEW `1000` AS SELECT * FROM reliable AS ns
    WHERE ns.created_at >= DATE_SUB(NOW(),INTERVAL 1 YEAR) # select oldest / most reliable?
    LIMIT 1000;
    
CREATE VIEW `reliable-txt` AS SELECT ip FROM reliable;
    
CREATE VIEW `1000-txt` AS SELECT ip FROM `1000`;

JSON output would be amazing.

[indolering]

I saw that you added the valid list, but it's still not randomized....

[indolering]

Also, you really should just use 1 or .9, that leaves tens of thousands of resolvers.