data-integrity

How to perform checksums during a SFTP file transfer for data integrity?

With the SFTP, running over an encrypted SSH session, there’s negligible chance the file contents could get corrupted while transferring. The SSH itself does data integrity verification. So unless the contents gets corrupted, when reading the local file or writing the remote file, you can be pretty sure that the file was uploaded correctly, if … Read more

What’s wrong with foreign keys?

Reasons to use Foreign Keys: you won’t get Orphaned Rows you can get nice “on delete cascade” behavior, automatically cleaning up tables knowing about the relationships between tables in the database helps the Optimizer plan your queries for most efficient execution, since it is able to get better estimates on join cardinality. FKs give a … Read more