[theamk]

Bad news for you: If you want to do performant ACID, you need a language that runs on the server, without network roundtrips.

Sure, it does not have to be SQL - for example Redis uses Lua instead. As others mentioned, there are also SQL replacements. But either way, there is _some_ language on the server that you, as a programmer, need to learn if you want to do complex+performant db programming.

At this point we could discuss SQL vs redis' Lua vs mongodb transactions vs upstarts like prql, and their speed and usability.. but I think this will be wast of time because you have never needed those features yet.