Is it best to design all tables with a UNIQUEID() from the start?
I’ve been reading on scaling up, and whilst I’ve yet to launch a prototype, the app I’m developing has the potential to hold secure data that will need to be accessed forever (ish) once it starts to be accumulated… for legal purposes.
Individual users will need access to a mainly small set of data but their own data (individual lines/records) could become quite numerous… a log of locations taken at least hourly.
Scaling up using MySQL indicates possible future problems if tables don’t have an 8 digit ID field?
Assuming that upscaling to a proper database will be likely at some point in the future, it would seem to make sense to give each table an 8 digit unique ID?