News for hackers. Stuff that matters.
Re:Let's Build a Simple Database by comfypotato on Thursday May 04, 2023 @10:07PM (#35824499)
Doesn’t SQL have decades worth of optimizations? I remember something from my databases class where the professor was mentioning how it’s to the point now where nobody really understands every aspect of what goes on between the query and the machine instructions.

Still cool as a hobby project.

Re:Let's Build a Simple Database by valleyer on Thursday May 04, 2023 @10:10PM (#35824517)
SQL is not the name of a piece of software, and SQLite is developed by a single person.
Re:Let's Build a Simple Database by scblock on Thursday May 04, 2023 @10:14PM (#35824544)
While SQLite is developed by a very small team[1] and does not openly accept patches[2], it is not developed by a single person.

1: https://www.sqlite.org/crew.html 2: https://www.sqlite.org/copyright.html

Re:Let's Build a Simple Database by valray on Thursday May 04, 2023 @11:38PM (#35824949)
From the link, it appears that it was developed by a single person in 2000, who then brought on board 2 other people as contributors in 2002 and after.
Re:Let's Build a Simple Database by klabb3 on Thursday May 04, 2023 @11:46PM (#35825003)
That’s probably true but building a clone that people understand, even if slower, is extremely valuable. Understanding an existing technology deeply is a gateway to innovation.

That said, SQLite is so remarkably stable, lightweight like a feather, and incredibly battletested, that even a hypothetically superior alternative would have an immense uphill battle to reach the same value prop.