This week has been about JIT compilers, domain models, a pixel editor, pagination in SQL and ARM vs x86.
A pixel editor with a modal interface that allows you to create still and animated pixel art.
An article reflecting back on the 4 years the XI editor has been in development, from early ambitions to roadblockers and assumptions that turned out to be not quite right.
A classic article on the implications of paginating SQL using offset and the benefits of the alternative approach.
I was revisiting this article to try to optimise a query on a large SQLite
table (191 million records) but sadly SQLite does not implement
An article analysing the anemic domain model and how to recover from it using the lifecycle of the data involved.
An article on interpreters, compilers and how just-in-time compilers work.
An article exploring how ARM and x86 work.