How NoSQL forced the evolution of a scalable relational database
I think NoSql, especially things like Mongo, got popular because it is super easy to program with javascript.  While scaling is one of the advantages, I'd be super surprised if many people actually need scaling capabilities ( other than because their design is super inefficient ).<p>Recently I've been inspired to play around with kicking out as many layers between a relational db and a REST Api, largely because I've been watching <a href="https://www.twitch.tv/nybblesio" rel="nofollow">https://www.twitch.tv/nybblesio</a>  ( who I first came across here on HN on a thread about live coding via twitch streaming ).   One of his projects he works on is a SASS product which is largely done in postgresql leveraging  <a href="https://github.com/PostgREST/postgrest" rel="nofollow">https://github.com/PostgREST/postgrest</a>  .  Seems pretty good, going to be interesting to see how it turns out   ( though I haven't seen him work on it lately )<p>I tend to like SQL Server, ASP.NET Core and found <a href="https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/01/29/simplify-rest-api-development-modern-single-page-apps-sql-server/" rel="nofollow">https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018...</a>    and I've been playing around with this kind of idea and using a lightweight mapper when needed ( <a href="https://github.com/StackExchange/Dapper" rel="nofollow">https://github.com/StackExchange/Dapper</a> which the stackoverflow people created )<p>I gotta say, I kind of like it<p>One of the problems of many stacks is that the frameworks wrap general purpose languages over SQL, which, is not really a good idea, SQL is a vastly more capable language for dealing with relational data and layers built over the top often dumb down the database.<p>The REAL problem SQL wrappers need to solve is that most languages don't have a good interface with SQL.  So most often SQL is handled in strings and manipulated with string manipulation and there is no type safe way transitioning data from the DB to a general purpose language.<p>Microsoft at one stage had Linq to SQL which was quite good..... but they killed it :)