Code Abstractions

Database Driver

  • raw SQL strings delievered to database with async? Rest

  • connection pooling

Query Builder

  • programmatically generate dynamic queries in a much more convenient way

  • generate queries for a few different SQL dialects

  • sweetspot of SQL because clear connection to general SQL, yet dealing with fts instead of strings

ORM

  • map a record in a relational database to an object

  • Do object validation on NoSQL and create generated properties and class fields

  • Learn a ORM specific interface rather than SQL

  • Must update code when you update database slowing down iterations early

  • Cant do everything in an ORM meaning you dip into SQL or do some inefficient code

  • sweetspot of NoSQL, adds needed things like object validation

PreviousDatabasesNextAll

Last updated