How to display a structured database?

[jS5t3r]

How to display a structured database with 100 entries and more? It has for example 3 columns.
This database will be automatically updated from time to time.

[TheFermi0n]

Maybe you can write a script that can parse the data and then render that in your website.

[george-gca]

This database will be automatically updated from time to time.

Can you be more specific? If this time to time is long enough you can have different solutions than one with more frequent updates.

[jS5t3r]

@george-gca sure.
Final goal: https://nicholas.carlini.com/writing/2019/all-adversarial-example-papers.html

Current status:
I have a GitHub workflow which show update papers once per day: https://github.com/lorenz-peter/lorenz-peter.github.io/actions/runs/11356739477/job/31588462669 (it basically executes this script: https://github.com/lorenz-peter/lorenz-peter.github.io/blob/master/papers/fetch_papers.py)

Actually, it ought to should create a json file like this one:
https://github.com/lorenz-peter/lorenz-peter.github.io/blob/master/papers/papers.json
Q: I dont know how read the papers.json from the the workflow. How do this?

This json file should be read out and and shown on my website. Maybe as post https://github.com/lorenz-peter/lorenz-peter.github.io/tree/master/_posts or project https://github.com/lorenz-peter/lorenz-peter.github.io/tree/master/_projects
Q: Best way to show the json file as table online?

[george-gca]

I believe using Bootstrap table will fit your needs. Check the last example in our sample post. It basically reads the content from a json file.

[jS5t3r]

@george-gca This is great.

The only open think is that how to update automatically this table then.

[george-gca]

To update the table automatically you'll have to trigger the build of the whole page everyday (or every X days). For that you can create a new GitHub action that would be a merge of .github/workflows/deploy.yml and .github/workflows/schedule-posts.txt. Check our CUSTOMIZE.md about the scheduled posts.

[jS5t3r]

@george-gca Thank you for your help. I have closed this dicsussion.