Re:A terrible schema from a clueless programmer
by johannes1234321 on Sunday November 07, 2021 @05:31PM
(#29144211)
Keeping IP addresses as string isn't trivial. You can write those in many ways. Even with IPv4. IPv6 just brings new variations. And when talking about migration to IPv6 you have to decide if you keep IPv4 Addresses as such or prefix with ::ffff:.
In the end you have to normalize anyways. Some databases have specific types. If not you have to pick a scheme and then ideally verify.
In the end you have to normalize anyways. Some databases have specific types. If not you have to pick a scheme and then ideally verify.