sqlite creative coding

Generating some visuals with SQL because nobody stopped me. With the magic of recursive CTE.

How it works

Gradient	Mandelbrot fractal
Just some dots	Voronoi
Wavey	Trigo - the blood dragon remix
Super Mario Bros. theme https://github.com/user-attachments/assets/1e181a1a-8e7b-4d98-9ab7-20ca6343d52d

---

Setup and run

Dependencies

• sqlite3
• imagemagick (for image)
• ffmpeg+ffplay (for video,audio)

Setup

• Using justfile: just setup
• Directly: sqlite3 fun.db < setup.sql

Generate image

• Using justfile: just image src/mandelbrot.image.sql
• Directly: sqlite3 fun.db < src/mandelbrot.image.sql && ./image.sh mandelbrot fun.db

Generate video

• Using justfile: just video src/wavey.video.sql
• Directly: sqlite3 fun.db < src/wavey.video.sql && ./video.sh wavey fun.db

Generate audio

• Using justfile: just audio src/supermariobros.audio.sql
• Directly: sqlite3 fun.db < src/supermariobros.audio.sql && ./audio.sh supermariobros fun.db