Contents
Should I use ORM or SQL?
ORM and SQL are two tools available that web developers can use in database management. When comparing them, SQL has a higher hands-on management than ORM. Because ORM has a higher level of abstraction and more complexity than SQL, less hands-on management is required; this makes data management more efficient.
Should I write my own ORM?
The point of the discussion was to highlight different ways to do an ORM, and even within some ORMs, different tactics of use. But unless you’re Ayende or Greg Young, you should not write your own ORM. If you have to map relational data to objects, you must use an ORM.
What is inline SQL?
An inline query is something when we paste the query instead of the table name. SQL Subquery/ Inline query are; SQL query within a query that can return the list of records or individual values. They are like nested queries that help through providing the data to the enclosing query.
Why is it considered a best practice to avoid inline SQL?
Some seem to be of the opinion that inline SQL should be absolutely forbidden. However, most places that make this statement either contain no explanation for why or they have a simplistic statement that it makes the code brittle. So, is it truly a best practice to avoid inline SQL in all circumstances?
What’s the difference between inline SQL and inline SQL?
A query is going to go through the optimization process, get stored in cache (depending), and then perform the actions it’s defined to do. So that’s the same with inline SQL or not. The real differences come down to three things and they all depend on how the inline SQL is built, not on whether or not you do it.
Is it OK to store an empty string in SQL?
In SQL, it’s a nullable field, which means it’s not known. I can’t think of any reasonable business value in storing an empty string in a table other than simply bad design. It’s like storing a string value of ‘NULL’ or ‘BLANK’, and having developers assume that it’s null or a empty string.
What kind of logic system does SQL use?
SQL uses a three valued logic system: True, False, and Unknown. For a better and more detail explanation, I recommend developers to read: SQL Queries – beyond TRUE and FALSE. I think Dean Hardings answer covers this really nicely.
https://www.youtube.com/watch?v=0oJN2HeWMEg