Ask HN: Which burning problem you'll solve today?
You wanted to make the world a better place,
Considering Today's Scenarios, which is the most important problem, you will solve first and why?
Bottom up change, it's the only thing that scale nicely and works sustainably in the long term.
Compared to what our living environment was for hundreds of thousands of years, it has changed so rapidly lately that I suspect that the human psyche has troubles keeping up. This results in unnecessary stress, anxiety, depression, feelings of meaninglessness, loneliness, drug abuse etc. "modern" problems.
Humans are very adaptable and I kind of enjoy living in a city, but I still wonder how much of the human experience we are missing because our biological blueprint was molded by thousands of years of natural selection in a totally different environment, and the modern experience just might fall short in some ways.
2. Always wanted a type-safe way to construct efficient SQL queries building bottom-up as in SQL rather than left-to-right as in ORMs[2].
3. A framework using (1) and (2) so building backends are not time-consuming or error-prone. Still in early stages.
[0] https://github.com/karmakaze/moja
I do have to admit that it is awfully convenient to use a REPL to write a long chain query using an ORM. I do often run into limitations, and knowing that the solution in plain SQL is so simple is very annoying. The idea is to allow convenient composition, but following the structure of SQL rather than parent-children navigation so there aren't paint-yourself-in-a-corner cases.
Not as grandiose and admirable as Space X and Neural Link but in a small way we do make the world a better place, we even have a promise, giving open source developers, small teams getting started, individuals and educators free SaaS to handle something that would otherwise be pain to do on their own anywhere near as well.