Revise the Database

[erikperin]

Make a revise of the first database schema...

vialerta_core_db.mwb.tar.gz

Open with MySQL Workbench

[erikperin]

I thought about using a "dumb" database , that doesn't have validations (only standards like "NOT EMPTY"). All validation will done in the app, including data consistency.

[soumfilipe]

I thought about using a "dumb" database , that doesn't have validations (only standards like "NOT EMPTY"). All validation will done in the app, including data consistency.

Well, This will use less data through the network and less database server's resources. I'm afraid this process result in invalid or bad data.

[erikperin]

@cfilipes But the validation exists... on the app... that validates all the info before INSERTs

[soumfilipe]

Yeah, but I'm thinking on a second or third party client communicanting with our db.

[erikperin]

@cfilipes In this case, the Core API validates information, no clients can access directly our DB

[soumfilipe]

Yep, just making it clear...

[erikperin]

Will be more easy for porting... and add new tables... ;)

[erikperin]

I make some adjustments on DB...

[EltonCarreiro]

Make a dumb db allows you to make heavy migration tasks without any problem. As Erik said, the database MUST be accessed through a core with the necessary validation.