Bad Apple!! on PostgreSQL

This was made out of boredom on the Database Theory subject after learning that there are "programming-like" functions in SQL.

Requirements

• .NET 8.0 or above
• Python 3.10 or above
• PostgreSQL 17 or above (utilizes the json_table() function)
• VS Code with the PostgreSQL plugin (the Microsoft one)
• ffmpeg
• Spectacle (since PyAutoGUI screenshots don't work in KDE Wayland)

Note

If running on Windows, you can use the normal pyautogui.screenshot() method. If on Wayland-based Linux distros that is not KDE, you can use grim.

If you are doing that, just replace this line subprocess.run(f"spectacle -b -n -o {FRAME_FOLDER / f"frame_{i:05d}.ppm"}", shell=True) in animate.py. The default Spectacle screenshot tool uses uncompressed PPM pictures.

Specific Libraries

C#

• CommunityToolkit.HighPerformance (Span2D)
• Npgsql (C# PostgreSQL)

Python

• pyautogui