It isn't. The baseline profile is limited to 9 megapixels, the advanced profile is limited to 36 megapixels, but you can also have a valid avif file that doesn't conform to any profile and that is larger. For software decoders that will not be a problem. Hardware decoders in consumer devices will likely most typically be limited to the baseline profile: only 4:2:0, at most 10-bit, and at most 9 megapixels (e.g. 4K). Tiling can be used to combine several independent bitstreams in a single AVIF; there might be visible seams at the tile edges though.
It's a limitation that makes a lot of sense for a video codec — video requires hardware decoding to keep battery consumption sane, and hardware decoding requires a limit to the frame size since hw implementations need bounded SRAM buffers (and the cost in gate count is more or less proportional to the max frame size).
You can compile this in too, but from a quick review none of my various SQLite installations seem to have been compiled with the SQLITE_ENABLE_ICU flag.
No one is a complete beginner I suppose. If you did some geometry in school, maybe some basic algebra, if you know what a function is (and I think every programmer knows what a function is) - you're good to go.
Even if the book is called Geometry for Programmers, I was trying really hard to make it self-sufficient. E. g. if you want to get deep into fascinating stuff like NURBS, you need to know a little calculus. So there is a chapter on calculus. It is shallow by itself but it opens the door for power series, polynomial interpolation, and then Bezier, rational Bezier, and finally NURBS.
Just like that, before introducing homogeneous coordinates and projective matrices, I put a chapter on linear equations. In any other geometry book it would have been completely redundant, but it explains so much about 4 point transformations, I just had to put it there.
TL&DR I sure hope so! This was my intention and if the book isn't appropriate for a beginner, I failed miserably as an author.
In summer: you need a shower to wash the sweat off
In winter: you need a bath to get as warm as possible before going to bed. Until recently (~1980s-90s) houses were expected to be ephemeral, whether they were knocked over by an earthquake or the new owner, so people skipped "luxuries" like insulation.
Haven't tried it yet. It looks interesting, but it's definitely not as simple as Alpine is; it comes with loads of functionality. Will give it a try sometime.