Created
July 5, 2015 18:55
-
-
Save defHLT/6b68dd358b7b57ca71f1 to your computer and use it in GitHub Desktop.
Sqlite Mandelbrot
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-> ice ~ % sqlite3 | |
SQLite version 3.8.6 2014-08-15 11:46:33 | |
Enter ".help" for usage hints. | |
Connected to a transient in-memory database. | |
Use ".open FILENAME" to reopen on a persistent database. | |
sqlite> | |
WITH RECURSIVE xaxis(x) AS (VALUES(-2.0) UNION ALL SELECT x+0.05 FROM xaxis WHERE x<1.2), yaxis(y) AS (VALUES(-1.0) UNION ALL SELECT y+0.1 FROM yaxis WHERE y<1.0), m(iter, cx, cy, x, y) AS ( SELECT 0, x, y, 0.0, 0.0 FROM xaxis, yaxis UNION ALL SELECT iter+1, cx, cy, x*x-y*y + cx, 2.0*x*y + cy FROM m WHERE (x*x + y*y) < 4.0 AND iter<28 ), m2(iter, cx, cy) AS ( SELECT max(iter), cx, cy FROM m GROUP BY cx, cy ), a(t) AS ( SELECT group_concat( substr(' .+*#', 1+min(iter/7,4), 1), '') FROM m2 GROUP BY cy ) SELECT group_concat(rtrim(t),x'0a') FROM a; | |
sqlite> ....# | |
..#*.. | |
..+####+. | |
.......+####.... + | |
..##+*##########+.++++ | |
.+.##################+. | |
.............+###################+.+ | |
..++..#.....*#####################+. | |
...+#######++#######################. | |
....+*################################. | |
#############################################... | |
....+*################################. | |
...+#######++#######################. | |
..++..#.....*#####################+. | |
.............+###################+.+ | |
.+.##################+. | |
..##+*##########+.++++ | |
.......+####.... + | |
..+####+. | |
..#*.. | |
....# | |
+. | |
sqlite> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment