Hi Hanno, Thank you for the suggestion.
The server responds rather slowly (is this data live-generated?), and > the "last-modified" header does not appear to contain useful data (it > just responds with the current date/time). The data is indeed generated in real time. The resulting CSV contains the most up-to-date information from the CCADB. Would it be possible to have some kind of small, static metadata file > with a hash and possibly latest update time of all CSVs? > It could be something as simple as > AllCertificateRecordsCSVFormatv2,[timestamp],[sha256] > AllIncludedRootCertsCSV,... Knowing that the data is live-generated, here are some other things we could consider in short order: - Add a column showing the date/time when the report was generated. - Update the report to generate a CSV file with a dynamic name that includes the current date/time (e.g., AllCertificateRecordsCSVFormatv2_10_20_2024_23:35.csv). - Create a separate (smaller) report that includes the records changed within the last 24 or 48 hours (or any other time frame). Do any of these sound appealing? Thanks again! -Chris, on behalf of the CCADB Steering Committee On Sat, Oct 19, 2024 at 7:38 AM Hanno Böck <[email protected]> wrote: > Hi, > > I would like to make a suggestion to make the use of CCADB data easier. > > Right now, there does not appear to be any easy way to track updates > of the various CSVs (e.g., AllCertificateRecordsCSVFormatv2). If one > wants to use the data, essentially the only way to keep it updated is > to re-download it regularly. > > The server responds rather slowly (is this data live-generated?), and > the "last-modified" header does not appear to contain useful data (it > just responds with the current date/time). > > Would it be possible to have some kind of small, static metadata file > with a hash and possibly latest update time of all CSVs? > It could be something as simple as > AllCertificateRecordsCSVFormatv2,[timestamp],[sha256] > AllIncludedRootCertsCSV,... > > That would allow just fetching that small file to check for updates. > > -- > Hanno Böck - Independent security researcher > https://itsec.hboeck.de/ > https://badkeys.info/ > > -- > You received this message because you are subscribed to the Google Groups > "CCADB Public" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/a/ccadb.org/d/msgid/public/20241019133840.40ad8d74%40computer > . > -- You received this message because you are subscribed to the Google Groups "CCADB Public" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/a/ccadb.org/d/msgid/public/CAAbw9mDKpTRCOfo0xog%3DQ0W5ur3u6M2R9TppX%3D-obmD0d%2BCwLg%40mail.gmail.com.
