Dsl Based Sql Libraries
Note: This article is a work in progress Databases are the heart of a web application When looking for relational database SQL libraries, there are various options to choose from: Object Relation Mappers(ORMs) DSL based String interpolation based Each approach has it’s pro’s and cons. ORM’s are perhaps the most common/widely used, and their drawbacks are well documented and talked about, such as Object-Relational impedance mismatch, lack of control over generated SQL leading to performance problems, n+1 queries problem, and the promise of not having to deal with SQL only shifts that burden to having to maintain and configure the ORM itself. [Read more from Dsl Based Sql Libraries...]