Skip to content

Automatic SQL database (with Minecraft stat files) visualisation using Manim

License

Notifications You must be signed in to change notification settings

KK-mp4/Manim-MC-Stat-Animation

Repository files navigation

Manim-MC-Stat-Animation (work in progress)

Automatic SQL database (with Minecraft stat files) visualisation using Manim

Example output for useItem.minecraft.diamond_pickaxe:

Chart.mp4

2 years ago I got an idea for storing Minecraft stat files each autosave of Dugged SMP, meaning that after some time we will have a database with all the stats growing over time. This will be handy in displaying charts during timelapses or in analyzing data. So I asked Robi to start saving stats automatically.
image

He is also way better than me in SQL and managed to save space, instead of storing all 1879 stats of all players for each date (3.8 GiB after 2+ years), we only store stat file if it got changed from last time (now only 20.5 Mib). So here is what I did:

1. Preparing SQL

I downloaded db file from phpMyAdmin and imported it into Microsoft SQL Server with correct mappings.

image

2. Generating manim file

Wrote C# winforms program to connect to SQL and generate manim file with some parameters and date selection.

image

Here is a dictionary what stat_id reffers to (Excel file in the project):

image

Here is what an output python file will look like:

image

3. Installing Manim

To actually generate a video you will need to install a python library called Manim Community version - it's an animation engine for explanatory math videos mainly developed by 3Blue1Brown
How to install it
How to configure Visual Studio Code to work with Manim

4. Running Manim

After installation and preperation of IDE of your chose you will have to run the script ether by running this powershell command
manim -pql main.py Chart -r 1920,1080 --fps 60
or by using Manim Sideview extention for VSCode

To learn more about Manim I suggest reading its comunity version documentation

About

Automatic SQL database (with Minecraft stat files) visualisation using Manim

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published