Skip to content

Latest commit

 

History

History
executable file
·
72 lines (47 loc) · 2.29 KB

README.md

File metadata and controls

executable file
·
72 lines (47 loc) · 2.29 KB
Raw

VNDB

Intro

VNDB, is an acronym of VNDB Novel Data Breakup, which is also the abbreviation of Visual Novel DataBase.

It contains the companion scripts for VNDB List Export for my personal use. Although I started with general applications in mind, I became more interest in visualization using ggplot2 package provided by R language and discarded availability for others in the end.

Query

A VNDB Query is nearly finished. With this, you can get the data with just a single UID (provided the list is not private). No more page jumps or dirty UserScript needed.

Tip

A downside of query is it's synced with VNDB's public dump daily at 8:30 UTC, so it may take up to 24 hours (+ ~30 minutes) for changes to the main database to show up in query results.

This is usually not a problem as I can't see why someone would use it on a daily basis.

Usage

Tested with Python 3.12 & R 4.4 on Void Linux Windows 11 24H2 & DevuanWSL. TBH it's not meant to be used by others, but anyway here is the recipe.

  1. Export VNDB VN/length vote list with instruction provided here and place it in the top directory, the vanilla XML VNDB export will NOT work. You can also use the counterfeit example to take a look at the results.

Easy way

Install Python, R & GNU Make (which you can install on Windows too), clone the repo and simply run make. Everything should be done now. Just check output or console log for the results. To clean up the data before restart, run make clean.

Vanilla way

  1. Install Python, R & respective dependencies:
# Python
pip install -r requirements.txt
# R
install.packages("tidyverse")
install.packages("corrplot")
install.packages("gridExtra")
  1. Now run the sanitizer and plot generator:
python ./vndb_sanitizer.py
python ./vndb_barchartrace.py
Rscript ./vndb-plot.r
  1. Check output or console log for the ugly (toldya) plots.

License

WTFPL

user-list.sql is (probably) adapted from User VN List, other queries are written by myself and still licensed under WTFPL.