Posts by Roben Nelson • 96 points

• 1

  votes

  2

  answers

  144

  views

  A: How to edit and create new record in DB? Ruby on Rails

  Create a database trigger in the cost table, which will be responsible for storing in Custo_historico the history of the changes made. CREATE OR REPLACE TRIGGER MON_ALT_CUSTO ON UPDATE custo FOR…

  ruby-on-rails ruby

  answered 8 years ago Roben Nelson 96

• 4

  votes

  1

  answer

  39

  views

  A: Helps storage in XML file

  Store the information in DBMS, XML files are useful for storing settings or transport data via Webservice. If you are not creating an API to be consumed, you will not need XML. Regarding the…

  database xml

  answered 8 years ago Roben Nelson 96

• 1

  votes

  3

  answers

  154

  views

  A: Doubt Normalizer + Regex

  Analyzing the regular expression, this is a denied list. It will replace any occurrence of non-ASCII character per void (will remove). Take the URL Remove any non-ASCII character. ASCII is a…

  java regex

  answered 8 years ago Roben Nelson 96

• 1

  votes

  2

  answers

  68

  views

  A: Create more fields and avoid JOIN decreases load?

  Do not repeat the field, use JOIN, create an index in the column. Think about the relationship that exists between your entities. Then analyze the performance of the query.

  php mysql join

  answered 8 years ago Roben Nelson 96

• 1

  votes

  1

  answer

  2709

  views

  A: How to maintain the aspect ratio of an image within a fixed size CSS div?

  Good afternoon. You should leave the image responsive, so that it can adapt to the container (parent element), the div in question. Use the max-width property: 100%; on the image. Max-width will…

  html css div

  answered 8 years ago Roben Nelson 96