How can I use this datatracker database?

[Mack68426]

Hi, I hope I'm asking the question in the right place. I am running datatracker and on docker desktop on Win11 WSL now.
I'm trying to figure out how the timeline charts work on Datatracker website and draw a new one on my own using python.
Is there any document or maybe code reference?

By the way, here's my configuration:

• Windows 11
• Docker Desktop 4.29.0
• Visual Studio code

[rjsparks]

All of the places the datatracker makes timeline charts are in the open codebase. There is no datatracker-specific documentation other than that code. The charts rely on libraries like highcharts that have their own documentation.

[Mack68426]

Thanks for replying. I'm a new-comer here so please bear with me if there's anything that I don't understand.
The thing is, I ran an SQL query on the database I built earlier to retrieve information on each RFC including its predecessor drafts in the a area(using wit area for test), then exported the results as a CSV. However, after cross-checking with the RFC Editor, apparently the number of RFCs in the csv file is lower than the one on RFC Editor(RFC Editor: 349; My output without duplicates: 236). Maybe I miss something idk, or it's just my query too bad.
Here's the SQL query:
https://gist.github.com/Mack68426/9ae1b49011607084443fef34b0757e81

[rjsparks]

First - I strongly encourage you to do this with Django instead of raw sql. Following the instructions for running the datatracker in docker and then using the django shell will make things much easier for you.
This (slightly aging) explanation of the models may help inform your queries however you make them: https://notes.ietf.org/iab-aid-datatracker-database-overview#

But - the datatracker and the RFC-Editor databases do not agree about very old RFCs. You will find differences. You will find errors in the datatracker's idea of authors of even some recent RFCs. Bringing these databases into alignment is part of the ongoing RPC tools modernization project.