SQL Api Route Query Best Practice
I'm wondering what would be considered best practices in terms of a SQL query for an API call.
For example,
let's say we have a Table named Person with columns id, name, age.
Let's say we have an api endpoint called /api/persons that grabs all the information from the Person table by executing a SQL query.
There are two possible queries here:
SELECT * FROM Person;
and
SELECT Person.id, Person.name, Person.age FROM Person;
Which one would be considered better, or does it really depend on what the use case/scenario is?
If this matters, lets assume this is done on a Node.js backend with Express and MySQL.
Thank you all!
mysql sql node.js api express
asked Nov 12 '18 at 22:19
kennycodeskennycodes
4026
add a comment |
I'm wondering what would be considered best practices in terms of a SQL query for an API call.
For example,
let's say we have a Table named Person with columns id, name, age.
Let's say we have an api endpoint called /api/persons that grabs all the information from the Person table by executing a SQL query.
There are two possible queries here:
SELECT * FROM Person;
and
SELECT Person.id, Person.name, Person.age FROM Person;
Which one would be considered better, or does it really depend on what the use case/scenario is?
If this matters, lets assume this is done on a Node.js backend with Express and MySQL.
Thank you all!
mysql sql node.js api express
asked Nov 12 '18 at 22:19
kennycodeskennycodes
4026
The 2nd. Simply because sending less bytes over the network is most of times better. But that's under the assumption that the table has more columns that the API doesn't require.
– LukStorms
Nov 12 '18 at 22:47
add a comment |
I'm wondering what would be considered best practices in terms of a SQL query for an API call.
For example,
let's say we have a Table named Person with columns id, name, age.
Let's say we have an api endpoint called /api/persons that grabs all the information from the Person table by executing a SQL query.
There are two possible queries here:
SELECT * FROM Person;
and
SELECT Person.id, Person.name, Person.age FROM Person;
Which one would be considered better, or does it really depend on what the use case/scenario is?
If this matters, lets assume this is done on a Node.js backend with Express and MySQL.
Thank you all!
mysql sql node.js api express
asked Nov 12 '18 at 22:19
kennycodeskennycodes
4026
I'm wondering what would be considered best practices in terms of a SQL query for an API call.
For example,
let's say we have a Table named Person with columns id, name, age.
Let's say we have an api endpoint called /api/persons that grabs all the information from the Person table by executing a SQL query.
There are two possible queries here:
SELECT * FROM Person;
and
SELECT Person.id, Person.name, Person.age FROM Person;
Which one would be considered better, or does it really depend on what the use case/scenario is?
If this matters, lets assume this is done on a Node.js backend with Express and MySQL.
Thank you all!
mysql sql node.js api express
mysql sql node.js api express
asked Nov 12 '18 at 22:19
kennycodeskennycodes
4026
asked Nov 12 '18 at 22:19
kennycodeskennycodes
4026
asked Nov 12 '18 at 22:19
kennycodeskennycodes
4026
asked Nov 12 '18 at 22:19
kennycodeskennycodes
4026
asked Nov 12 '18 at 22:19
kennycodeskennycodes
4026
4026
The 2nd. Simply because sending less bytes over the network is most of times better. But that's under the assumption that the table has more columns that the API doesn't require.
– LukStorms
Nov 12 '18 at 22:47
add a comment |
The 2nd. Simply because sending less bytes over the network is most of times better. But that's under the assumption that the table has more columns that the API doesn't require.
– LukStorms
Nov 12 '18 at 22:47
The 2nd. Simply because sending less bytes over the network is most of times better. But that's under the assumption that the table has more columns that the API doesn't require.
– LukStorms
Nov 12 '18 at 22:47
The 2nd. Simply because sending less bytes over the network is most of times better. But that's under the assumption that the table has more columns that the API doesn't require.
– LukStorms
Nov 12 '18 at 22:47
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53270917%2fsql-api-route-query-best-practice%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53270917%2fsql-api-route-query-best-practice%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
The 2nd. Simply because sending less bytes over the network is most of times better. But that's under the assumption that the table has more columns that the API doesn't require.
– LukStorms
Nov 12 '18 at 22:47