sqlite has a fantastic codebase for understanding how databases work. there's a pretty comfortable parser generator in there as well (lemon), that I found nice

sqlite has a fantastic codebase for understanding how databases work. there's a pretty comfortable parser generator in there as well (lemon), that I found nicer than bison when I was still messing around with them instead of just defaulting to recursive descent as I do these days.