News for hackers. Stuff that matters.
Re:Showdown: MySQL 8 vs. PostgreSQL 10 by tscs37 on Wednesday May 23, 2018 @02:51PM (#17136958)
You can somewhat mitigate the typo problem with integers by encoding them to the outside with parity included.

An 8 bit parity should be able to easily tell any possible typo in a 32 or 64bit integer and even correct errors. You could even put the parity into the lowest 8 bit of the integer.

I'm currently working on this for a project of mine to not only prevent typos but tolerate them by using the parity and using letters that are far apart on my QWERTZ keyboard (bit local but it should work for most keyboard sets and I have parity to fall back on)

Re:Showdown: MySQL 8 vs. PostgreSQL 10 by th3sly on Thursday May 24, 2018 @07:09AM (#17142858)
Re:Showdown: MySQL 8 vs. PostgreSQL 10 by tscs37 on Thursday May 24, 2018 @07:26AM (#17142951)
Yes but that's a full UUID, using a 64bit integer with some encoding is far shorter.