Skip to content

Releases: ruofeidu/DuWebKit

First public release of DuWebKit

16 Feb 21:20
Compare
Choose a tag to compare

DuWebkit is a minimized subset of Ruofei Du's Python toolkits of personal website. It compiles minimized HTML, JS, and CSS by parsing data from a Google Sheet database.

The motivation is: given a set of papers with different authors, I have to
manually generate BibTeX items, links to individual's website, and write
template for each paper. It's tedious to maintain all links up-to-update so I
need a structured way to do so. What if we can maintain all the data in two or
more Google Sheet?

Why not SQL? PHPMYADMIN is insecure to play with while adding new rows
require significant amount of efforts to log-in, ensure data integrity, and
complex IO.

Why not JSON? In 2018, I made VarshneyWebsite, which uses JSON for storing
students and papers. However, JSON file is hard to search and find, and column
names are repetative.

Why gSheets is a better choice for personal website? In 2019, I started to
build a new toolchain to leverage Google Sheets for updating such small-scale
relational database. It offers me a convenient interface to have a quick
overview of all of my previous submissions and coauthors.

You may need a developer account and access
this sample Google sheet
for a template Google sheet to compile a website from this set of Python
scripts. This is the opensourced version of my private repository and may not
reflected what I am showing on http://duruofei.com. Please feel free to pull
request or ask me for anything.