It looks like I neglected to post about my newest videos as I published them. I indicated in an earlier post that I was going to implement an array-like data structure in #Funciton, which I did [0], and since then I also solved Advent of Code Day 6 part 1 where I'm reasonably happy with how the video turned out [1].

[0] https://youtu.be/lqoGbFHmVxM
[1] https://youtu.be/eUffjAFLc6Y

BINARY SEARCH in Funciton (esoteric programming) (Ep. 12)

YouTube
I completed filming for another #Funciton video (5b), but the result seemed, let's say, unappealing enough that I'm considering writing a whole new library to establish some functionality to allow it to run much more efficiently. Specifically, I've been thinking about the fact that both lists and lazy sequences require evaluating from the start, which means you can't index into them any faster than O(n). I always just assumed that you can't do any better because lists use a variable-length encoding, and I assumed that they needed that to accommodate arbitrary-size integers. But now I'm thinking about a new strategy where only one number, the number of bits per element, needs a variable-length encoding, and then everything else can be directly indexed via multiplication and bit shifting. I think I'm going to call that “arrays”. I'm excited about the idea but I'm intimidated by the need to find yet more function names for common operations like count, insert, etc.
Got finished pretty quickly with editing the next #Funciton video (#adventofcode 2024, day 5, part 1). This was the first time I got an OutOfMemoryException! Fortunately all it needed was to recompile as AnyCPU so it could use 64-bit. Despite, I was not anticipating that a Funciton program could end up using 8.1 GB of RAM! (Video comes out on Sunday per usual schedule)
I am very proud to show off my newest video! I’ve had a lot of thoughts about how something like #RegularExpressions could be implemented in a limited #esolang like #Funciton but I never took the time to actually implement it... until I ran into Day 3 of #AdventOfCode 2024, which provided a challenge best solved with a #regex. Enjoy! https://www.youtube.com/watch?v=ImzcTmB0m0k
REGULAR EXPRESSIONS in Funciton (esoteric programming) (Ep. 11)

YouTube
Advent of Code 2024 in Funciton: Day 2, Part 2

YouTube
The saga continues! #AdventOfCode 2024, Day 2, part 1, in #Funciton! https://youtu.be/kNG45WkMCO8 #esolang #esolangs #aoc2024
Advent of Code 2024 in Funciton: Day 2, Part 1

YouTube
I'm going to start solving Advent of Code 2024 in #Funciton. Day 1 puzzle 1 is already live: https://youtube.com/watch?v=9Kegyt7xNVQ #aoc2024 #adventofcode #esolang #esolangs
Advent of Code 2024 in Funciton: Day 1, Part 1

YouTube

The gift I received in Secret Solver couldn’t have been more aptly personalized. My santa saw my #esolang video series I spent all year creating [0] and decided to make a #Funciton #puzzle for me! [1]

I will avoid spoiling the puzzle for you guys here but you should definitely give it a try! There are more layers to it than it appears on the surface; it’s not just a matter of figuring out a Funciton program.

[0] https://www.youtube.com/playlist?list=PLkG32PHxWoJaetjKUMVRONWLgRHQVjmtc

[1] https://files.timwi.de/Puzzles/Secret%20Solver%202024/Timwi/Secret%20Solver%202024%20gift%20for%20Timwi.txt

Learn Funciton

YouTube
Today I’m starting a new #YouTube channel. I’m going to be describing my esoteric programming language “Funciton” in real excrutiating detail. If this is something you’re interested in, consider liking and subscribing. https://www.youtube.com/watch?v=Y42gOeaeya4 #esotericprogramming #esolang #esolangs #funciton
A programming language... made of BOXES?!

YouTube
二、mysql窗口函數之rank()函數的使用

1、窗口函數之rank()使用場景:在mysql中進行分組(group by)後,還需要組內排名,例如各班級成績排名、市場各不同小組業績排名、不同地區水果售價排名等。 2、什麼是窗口函數?