I know how to use databases but am sometimes fuzzy on how they actually work under the hood. Can you recommend good books or other resources for learning database internals?
SQLite has interesting papers about its internals: <a href="https://www.sqlite.org/optoverview.html" rel="nofollow">https://www.sqlite.org/optoverview.html</a>