Hello,
Do you know any courses where someone teaches creating anything from scratch, like database, search engine, compilers, programming languages, etc.
From few months I am getting interested in these kind of things, as will help me understanding the systems in depth.
I will even consider a paid a course/resource.
I have checked Codecrafters, but it is quite expensive in my country.
I have also looked into some free resources.
Also please share if you have tried these kind of tutorials before, are they good?
Thanks in advance.
I hardly have ever come across (as I can recall at least) any source on creating a database engine from scratch. I think it's even harder than creating a custom compiler either for an existing language or for a new one (DSL?).
But is it just curiosity or are you trying to scratch an itch? I do understand the curiosity, but let me hint you: only invest in knowledge that you're quite certain it might benefit you somewhere between now and ten years ahead. Studying rocket science will not benefit you if you won't build a rocket or plan to become an astronaut. If you understand what I am saying.
Maybe not really up your ally, but this book is quite informative on the lower level of computing: "Computer Systems: A Programmer's Perspective, 3 Edition" - David R. O'Hallaron & Randal E. Bryant
If you really must understand databases as a system and the theory behind them, this is a good start: "An Introduction to Database Systems" - C.J. Date
Mr. Date is regarded as the godfather of all things databases. Very dry book, but this is where a lot of RDMS's are based on.
If you ever find a good and reliable source on search engines I'd like to be informed. Since all I can find is mere "Queries against a database to look up what I'm looking for" kind of level. Not how Google has set the mark on real engines for searching and how searching in general is a completely different field on its own. Because that would be interesting.