Happy New Year: Lisp interpreter in SQL
A functional Lisp interpreter as a single PostgreSQL query The post Happy New Year: Lisp interpreter in SQL appeared first on EXPLAIN EXTENDED .
EXPLAIN EXTENDED
How to create fast database queries
Latest posts
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 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 art will soon go the way [ ] The post Happy New Year: Diffusion Model image generator in about 700 lines of pure SQL…
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 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 in SQL?" [ ] The post Happy New Year: GPT in 500 lines of SQL appeared first on 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 the Rubik s Cube in SQL appeared first on 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 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 post A good first word for Wordle appeared first on 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 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 the emulation and make the measurements. First things first, [ ] The post Happy New Year: quantum computer emulator in…
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 of the coronavirus in SQL appeared first on 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 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, anhingas; fish, turtles, snakes; otters, skunks, [ ] The post Happy New Year: a stereogram in SQL appeared first on EXPLAIN…
Happy New Year: GIF decoder in SQL
An implementation of GIF decoder and ASCII renderer in PostreSQL. The post Happy New Year: GIF decoder in SQL appeared first on 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 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 Happy New Year: Settlers of Catan in SQL appeared first on EXPLAIN EXTENDED .