git404hub

what is sqlite-creative-coding fr?

phenax/sqlite-creative-coding — explained in plain English

Analysis updated 2026-05-18

13ShellAudience · developerComplexity · 2/5Setup · easy

tl;dr

A collection of SQL queries that generate images and animations, Mandelbrot fractals, Voronoi diagrams, color gradients, using only SQLite and ImageMagick, as a creative coding experiment.

vibe map

mindmap
  root((sqlite-creative-coding))
    Visuals
      Mandelbrot fractal
      Voronoi diagram
      Color gradient
      Polka dots
      Animations
    Technique
      Recursive CTEs
      Pixel color math
      SQL loops
    Output
      PNG images
      GIF animations
    Tools
      SQLite
      ImageMagick
      justfile runner

Code map

Detail Auto

An interactive map of this repo's files and how they connect — its source is parsed live in your browser. Click Visualize to build it.

filefunction / class

what do people make with this?

VIBE 1

Generate Mandelbrot fractal PNG images entirely using SQLite recursive queries without any graphics library

VIBE 2

Create animated GIF files from SQL-driven pixel data piped through ImageMagick

VIBE 3

Study how recursive CTEs in SQLite can compute pixel colors row by row to understand advanced SQL looping

what's the stack?

SQLSQLiteShellImageMagick

how it stacks up fr

phenax/sqlite-creative-codingadukecoins/codewatchfrichxi/zanai-writing-skill
Stars131313
LanguageShellShellShell
Setup difficultyeasymoderateeasy
Complexity2/52/52/5
Audiencedeveloperdeveloperdeveloper

Figures from each repo's GitHub metadata at analysis time.

how do i run it?

Difficulty · easy time til it works · 30min

Requires SQLite, ImageMagick, and the `just` command runner installed locally.

in plain english

This repository explores generating images and short animations using nothing but SQL queries run against SQLite, a database engine usually associated with storing data rather than drawing pictures. The technique relies on a SQLite feature called recursive CTEs (Common Table Expressions), which let a query build up a result row by row in a loop, effectively computing the color of every pixel in an image through database queries alone. The project includes six visual examples: a smooth color gradient, a Mandelbrot fractal (a classic mathematical shape with infinitely detailed edges), a pattern of polka dots, a Voronoi diagram (a type of geometric pattern where the plane is divided into regions based on distance from a set of points), and two animated pieces called Wavey and Rave that loop through frames to create movement. The static visuals are output as PNG files and the animations as GIF files, both produced by feeding SQLite's output through ImageMagick (a widely available image processing tool). Running the project requires SQLite and ImageMagick installed on your system. A setup script initializes a small database file, and then individual SQL files for each visual can be run to generate the output. The repository includes a justfile for convenience so commands like "just image src/mandelbrot.sql" do all the steps in sequence. The SQL files themselves are the actual creative work, the full pipeline for generating each image lives inside the query. The README is minimal and links to a blog post on the author's site for a fuller explanation of how the technique works. The whole project reads as a playful experiment: the author notes they generated visuals with SQL "because nobody stopped them."

prompts (copy fr)

prompt 1
Walk me through how sqlite-creative-coding's Mandelbrot SQL works, specifically how the recursive CTE computes iteration counts for each pixel coordinate
prompt 2
Help me write a new SQLite recursive CTE that generates a Sierpinski triangle PNG using the same approach as sqlite-creative-coding
prompt 3
Show me how to run the Voronoi diagram example using sqlite-creative-coding's justfile and save the output as a PNG
prompt 4
Explain how sqlite-creative-coding pipes SQLite output through ImageMagick to assemble an animated GIF from per-frame pixel data

Frequently asked questions

what is sqlite-creative-coding fr?

A collection of SQL queries that generate images and animations, Mandelbrot fractals, Voronoi diagrams, color gradients, using only SQLite and ImageMagick, as a creative coding experiment.

What language is sqlite-creative-coding written in?

Mainly Shell. The stack also includes SQL, SQLite, Shell.

How hard is sqlite-creative-coding to set up?

Setup difficulty is rated easy, with roughly 30min to a first successful run.

Who is sqlite-creative-coding for?

Mainly developer.

peek the repo → explain another one

This repo across BitVibe Labs

double-check against the repo, no cap.