Questions tagged as 'banco-de-dados'


What are the differences between MyISAM and InnoDB?

What are the main differences between engines MyISAM and InnoDB and what is the most appropriate situation for each? I know that MyISAM does not support FOREIGN KEY but supports FULLTEXT , while InnoDB...
asked by 24.11.2014 / 20:15

What is the best way to represent an Address?

By modeling addresses in an application, I naively followed the standard form when representing in the DB (ie separate tables for country , status strong city , neighborhood etc - joins everywhere), and in the user interface (html) I p...
asked by 19.12.2013 / 01:04

Type of the CPF or CNPJ field in the VARCHAR or INT database?

What type of CPF or CNPJ field in database VARCHAR or INT ? I've seen some posts suggesting to use INT to optimize performance in JOIN and filters. If you have 0 on the left, you can only complete it according...
asked by 22.01.2015 / 14:51

Is it wrong to write byte of images in the database?

When should I make this direct recording at the bank? What are the situations? I know I can save the image path to the bank.     
asked by 11.04.2014 / 18:53