sqlite3 - mysql和sqlite源码哪个更适合阅读呢？

Question

想自己从0开始写个数据库，有前辈知道哪个更加适合模仿和起步吗？更利于学习良好的代码风格架构和基本的数据库知识

Answer 1

If you read the source code, you must definitely use sqlite. The source code only has tens of thousands of lines to implement the database function. It is implemented in pure C and also implements the lock function. Many languages ​​​​can easily use API to operate sqlite. It is equivalent to a stand-alone mini database. Well, if you want to study, it is more appropriate to study the principles of databases. For MySQL, few people can understand it if you study the source code. And MySQL has historical issues. It doesn’t make sense to look at old versions. New ones have new branches. On the contrary, SQLite is small but very active. You can just look at the latest code. Those with some basic C and data structure knowledge should be able to read it. Understand.

Actually, I don’t understand it either. I just saw other people using SQLite when making small things, and they said it was very good.