News for hackers. Stuff that matters.

A comment on Red Hat Satellite to standardize on PostgreSQL backend. Parent comment

Re:Red Hat Satellite to standardize on PostgreSQL backend by Bucephalus355 on Wednesday February 13, 2019 @10:04PM (#19159298)
What is the purpose of validation would you say with modern computers? At one time, specifying the exact number of chars was good for squeezing out as much storage as possible, but less so today.
[ Parent | on HN ]
Re:Red Hat Satellite to standardize on PostgreSQL backend by baroffoos on Wednesday February 13, 2019 @10:30PM (#19159390)
Its still absolutely critical for almost everything. Some use cases:

* My code depends on this value always existing so make this not null * My code is doing math on this value so make sure it is always a number * This record belongs to other record, make sure other record can not be deleted while this one still exists

Modern computers change next to nothing with the need to validate data. The worlds fastest computer wont tell you how to add a number that doesn't exist.

[ Parent | on HN ]
Re:Red Hat Satellite to standardize on PostgreSQL backend by sonnyblarney on Wednesday February 13, 2019 @10:27PM (#19159377)
Validation is almost always a function of business logic, not 'storage compression'.
[ Parent | on HN ]