{"id":1229,"date":"2022-04-01T17:11:56","date_gmt":"2022-04-01T20:11:56","guid":{"rendered":"https:\/\/gladiston.net.br\/?p=1229"},"modified":"2022-07-13T16:06:51","modified_gmt":"2022-07-13T19:06:51","slug":"porque-um-dba-deve-orientar-programadores-a-criarem-querys-parametrizadas","status":"publish","type":"post","link":"https:\/\/gladiston.net.br\/en\/porque-um-dba-deve-orientar-programadores-a-criarem-querys-parametrizadas\/","title":{"rendered":"Why should a DBA guide programmers to create parameterized queries?"},"content":{"rendered":"<p>A problem to be avoided is to think that parameters inside a query are like macro-replacements, a kind of Search\/Replace inside queries, because they are not. Parameters are ways to identify to the DBMS server the possibility of repeating the same SQL sentence, then it will remember the necessary parameters and the best indexes for this operation. The server will remember this information even after your connection is terminated and will still benefit other users who will execute the same query with different parameters.<\/p>\n\n\n\n<p>Look <a href=\"https:\/\/gladiston.net.br\/en\/banco-de-dados\/porque-um-dba-deve-orientar-programadores-a-criarem-querys-parametrizadas\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Why should a DBA guide programmers to create parameterized queries?\">the full article here<\/a>.<\/p>","protected":false},"excerpt":{"rendered":"<p>Um problema a ser evitado \u00e9 achar que par\u00e2metros dentro de uma query s\u00e3o como macro-substitui\u00e7\u00f5es, uma especie de Search\/Replace dentro de queries, pois n\u00e3o s\u00e3o. Par\u00e2metros s\u00e3o formas de identificar para o servidor SGBD a possibilidade de repeti\u00e7\u00e3o de uma mesma senten\u00e7a SQL, da\u00ed ele passar\u00e1 a se lembrar dos par\u00e2metros necess\u00e1rio e quais [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"templates\/template-full-width.php","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[],"class_list":["post-1229","post","type-post","status-publish","format-standard","hentry","category-banco-de-dados"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/posts\/1229","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/comments?post=1229"}],"version-history":[{"count":1,"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/posts\/1229\/revisions"}],"predecessor-version":[{"id":1230,"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/posts\/1229\/revisions\/1230"}],"wp:attachment":[{"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/media?parent=1229"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/categories?post=1229"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/tags?post=1229"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}