I read https://sqlfordevs.com/ebook last week and I think it was one of the best practical guides I've seen in years. I say this as someone with 15+ yoe who uses SQL regularly. Source: over 1 year ago

Show HN: I wrote a free eBook about many lesser-known/secret database tricks\ (150 comments). Source: over 1 year ago

For what it's worth you can implement a C compiler in under 10kLOC. The chibi C compiler is only a few thousand lines [1]. There is also Cake [2] and the tiny C compiler [3] which are both relatively small. [1] https://github.com/rui314/chibicc [3] https://bellard.org/tcc/. - Source: Hacker News / 4 months ago

I was going to say, the list should include something by Fabrice Bellard. Tiny C Compiler is one. https://bellard.org/tcc/ I was thinking, maybe first version/commit of QEMU would be interesting to read. - Source: Hacker News / 11 months ago

I occasionally use tcc (https://bellard.org/tcc/) like an interpreter (`tcc -run`), it's convenient for certain odd tasks. Not so much for interactive stuff, but if I'm building little PoCs for an idea that will get dropped into a C project, or fiddling with structs work out how something should/is being stored, or in situations where I'm making stuff that interacts with or examples based on C code and I want to... - Source: Hacker News / about 1 year ago

This reminded me the idea of compilers bootstrapping (https://news.ycombinator.com/item?id=35714194). That is, now you can code in SectorC some slightly more advanced version of C capable of compiling TCC (https://bellard.org/tcc/), and then with TCC you can go forward to GCC and so on. - Source: Hacker News / about 1 year ago

The tinyc compiler reads scripts like a c-interpreter, with shebang and all. Source: over 1 year ago