BACKEND Flashcards

1
Q

Explain SQL Query Builders

A

An SQL query builder adds a layer of abstraction above raw database-native querying languages. They do this by formalizing querying patterns and providing methods or functions that add input sanitation and automatically escape items for easier integration into applications.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Explain ORMs

A

ORMs can be useful abstractions that make working with databases a lot easier. They can help you design and iterate quickly and bridge the conceptual differences between the application logic and database structures. However, many of these advantages act as a double-edged sword. They can prevent you from understanding your databases and can make it challenging to debug, change paradigms, or increase performance.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Explain Raw SQL

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly