Can someone really create their own database like SQL if they master data structures?

Creating a modern relational database is a massive and intricate task. While a skilled solo developer could technically build one, it would likely end up as a toy project, lacking the performance and features of established systems like Postgres. To really compete, you'd need a dedicated team and significant resources.

Of course you can create your own database, but whether anyone would use it is another story. It's a complex undertaking and you'd need to ask yourself if you should be doing it, rather than if you can.

B-trees are just a small part of what goes into building a relational database. You'd need a solid understanding of how databases maintain ACID properties, manage transactions, and handle concurrency. Plus, you need to dive into SQL parsing and query planning. Essentially, there's a mountain of additional knowledge required beyond just data structures.

Sure, people have created databases before, but it's a significant challenge. If it's just for learning or experimentation, go for it! Just don't expect it to match the capabilities of existing solutions.

Yes, you could theoretically build a database, but it involves a lot more than just knowledge of data structures. It would be an enormous project that requires experience in programming, performance optimization, and a lot of other areas.