Stop using Integer ID’s in your Database
The problem is that most companies don’t apply the required forethought to creating the right primary keys to allow data from different channels to be merged.
Avinash Kaushik • Web Analytics 2.0: The Art of Online Accountability and Science of Customer Centricity
Having a unique ID number for every object can come in handy when you’re trying to determine whether two objects are the same as each other.
Joe Leo • The Well-Grounded Rubyist
Local database for development
Each table in the database had an accompanying script that would generate a subset of the data for use in local development, since the final database was too large to run on a developer's machine.
This let each developer work with a live, local, copy of the database and enabled efficient development of changes.
I highly... See more
Each table in the database had an accompanying script that would generate a subset of the data for use in local development, since the final database was too large to run on a developer's machine.
This let each developer work with a live, local, copy of the database and enabled efficient development of changes.
I highly... See more