Visualization toolmaker. Founder @observablehq. Creator @d3. Former @nytgraphics. Pronounced BOSS-tock.
Published
Edited
Jan 14, 2019
8 stars
html`<pre>${(await db.exec(`WITH RECURSIVE numbers AS (
SELECT 0 AS n UNION ALL SELECT n+1 FROM numbers WHERE n<89
),
pixels AS (
SELECT rows.n as row, cols.n as col
FROM numbers as rows CROSS JOIN numbers as cols
WHERE rows.n > 2 AND rows.n < 40 AND cols.n > -1 AND cols.n < 89
), rawRays AS (
SELECT
row, col,
-0.9105 + col * 0.0065 + row * 0.0057 as x,
-0.1315 + row * -0.0171 as y,
0.6794 + col * 0.0045 + row * -0.0081 as z
FROM pixels
), normsSq AS (
SELECT row, col, x, y, z, x * x + y * y + z * z AS n2 FROM rawRays
), norms AS (
SELECT row, col, x, y, z, (1 + n2) / 2.0 as n FROM normsSq
), rays AS (
SELECT row, col, x / n AS x, y / n AS y, z / n AS z FROM norms
), iters AS (
SELECT row, col, 0 as it, 0 as v FROM rays
UNION ALL
SELECT rays.row, rays.col, it + 1 AS it,
v + MAX(ABS(0.75+v*x) - 0.3, ABS(0.75+v*y) - 0.3, ABS(-1.06+v*z) - 0.3, -(0.28 + ((0.75+v*x) * (0.75+v*x) + (0.75+v*y) * (0.75+v*y) + (-1.06+v*z) * (-1.06+v*z)) / 0.28) / 2.0 + 0.42) AS v
FROM iters JOIN rays ON rays.row = iters.row AND rays.col = iters.col
WHERE it < 15
), lastIters AS (
SELECT it0.row, it0.col, it0.v AS v0, it1.v AS v1, it2.v AS v2
FROM iters as it0
JOIN iters AS it1 ON it0.row = it1.row AND it0.col = it1.col
JOIN iters AS it2 ON it0.row = it2.row AND it0.col = it2.col
WHERE it0.it = 15 AND it1.it = 14 AND it2.it = 13
), res AS (
SELECT col, (v0 - v1) / (v1 - v2) as v FROM lastIters
)
SELECT group_concat(
substr('$@B%8&WM#*oahkbdpqwmZO0QLCJUYXzcvunxrjft/|()1{}[]?-_+~<>i!lI;:,"^. ', round(1 + max(0, min(66, v * 67))), 1)
|| CASE WHEN col = 88 THEN X'0A' ELSE '' END
, '') AS text
FROM res`))[0].text}`
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
