Full Width [alt+shift+f] Shortcuts [alt+shift+k]
Sign Up [alt+shift+s] Log In [alt+shift+l]

EXPLAIN EXTENDED

EXPLAIN EXTENDED
Happy New Year: Diffusion Model image generator in about 700 lines of pure SQL Regular readers of my blog will be aware that SQL is an excellent tool for graphics. You can use it...
a month ago
53
a month ago
Regular readers of my blog will be aware that SQL is an excellent tool for graphics. You can use it to draw snowflakes, fractals, ray-traced 3D pictures, and many other things. SQL art is beautiful, albeit slow to generate. These days they say AI is taking over, and human-made...
EXPLAIN EXTENDED
Happy New Year: GPT in 500 lines of SQL Translations: Russian This year, the talk of the town was AI and how it can do everything for you. I...
a year ago
15
a year ago
Translations: Russian This year, the talk of the town was AI and how it can do everything for you. I like it when someone or something does everything for me. To this end, I decided to ask ChatGPT to write my New Year's post: "Hey ChatGPT. Can you implement a large language model...
EXPLAIN EXTENDED
Happy New Year: solving the Rubik’s Cube in SQL Explain Extended New Year's post solving the Rubik's Cube in SQL The post Happy New Year: solving...
over a year ago
20
over a year ago
Explain Extended New Year's post solving the Rubik's Cube in SQL The post Happy New Year: solving the Rubik’s Cube in SQL appeared first on EXPLAIN EXTENDED.
EXPLAIN EXTENDED
A good first word for Wordle Ok, I gave in to the fad and took up Wordle. For those who have been living under a rock for the...
over a year ago
37
over a year ago
Ok, I gave in to the fad and took up Wordle. For those who have been living under a rock for the past few weeks, Wordle is a relatively new online word game which has become viral. It is a variation of Bulls and Cows. You have six tries to guess a five-letter word. Each […] The...
EXPLAIN EXTENDED
Happy New Year: quantum computer emulator in SQL Last year, my good friend and colleague Matt Ward challenged me to implement a quantum computer...
over a year ago
16
over a year ago
Last year, my good friend and colleague Matt Ward challenged me to implement a quantum computer emulator in SQL. Challenge accepted! This year we will be building an SQL query which will emulate a quantum computer. This query will process quantum assembly, build the circuit, run...
EXPLAIN EXTENDED
Happy New Year: 3D picture of the coronavirus in SQL A picture of the nasty coronavirus using 3d ray tracing in SQL The post Happy New Year: 3D picture...
over a year ago
13
over a year ago
A picture of the nasty coronavirus using 3d ray tracing in SQL The post Happy New Year: 3D picture of the coronavirus in SQL appeared first on EXPLAIN EXTENDED.
EXPLAIN EXTENDED
Happy New Year: a stereogram in SQL I'm spending this New Year holiday in sunny Florida. One of its most beautiful places is the...
over a year ago
14
over a year ago
I'm spending this New Year holiday in sunny Florida. One of its most beautiful places is the Everglades: the endless sea of grass, extending to the horizon, as far as the eye can see and beyond, and teeming with life. There are all kinds of animals there. Herons, egrets,...
EXPLAIN EXTENDED
Happy New Year: GIF decoder in SQL An implementation of GIF decoder and ASCII renderer in PostreSQL. The post Happy New Year: GIF...
over a year ago
15
over a year ago
An implementation of GIF decoder and ASCII renderer in PostreSQL. The post Happy New Year: GIF decoder in SQL appeared first on EXPLAIN EXTENDED.
EXPLAIN EXTENDED
Happy New Year: Settlers of Catan in SQL One of the best New Year presents I've ever got was a copy of the German-style board game, The...
over a year ago
12
over a year ago
One of the best New Year presents I've ever got was a copy of the German-style board game, The Settlers of Catan. This game has brought me and my friends many an hour of good entertainment. The game is played on a hexagon field with 19 hexagon tiles (3 + 4 + 5 + 4 […] The post...
EXPLAIN EXTENDED
Happy New Year: the Sultan’s Riddle in SQL Here is a riddle I read a long time ago in Nauka i Zhizn, a popular Russian science magazine. The...
over a year ago
15
over a year ago
Here is a riddle I read a long time ago in Nauka i Zhizn, a popular Russian science magazine. The Sultan's Riddle Once upon a time there was a Sultan who was looking for a vizier to help him rule his country. It became known to him that among the multitudes of his loyal subjects...
EXPLAIN EXTENDED
Happy New Year: Conway’s Game of Life in SQL Christmas divination: implementing Conway's Life in SQL The post Happy New Year: Conway’s Game of...
over a year ago
15
over a year ago
Christmas divination: implementing Conway's Life in SQL The post Happy New Year: Conway’s Game of Life in SQL appeared first on EXPLAIN EXTENDED.