September 27, 2018

Database health service - debunk my idea!

I was creating something for myself that would output a "health report" of rows in my User table. In my case, a User record would be at 100% health if it had a 1) a zip code 2) 2-3 posts 3) last logged in within 30 days.

If a record was missing a zip code, it would be at 66% health or thereabouts. With each of items, I have a corresponding action to resolve that issue. For example, send out an email that says "You should populate your zip code".

I was thinking of offering this as a tool. Add fields, relationships/actions relative to a person's table and their respective ideas of a "healthy" record.

Does this already exist? How could I store the user's database details securely but still reuse? What could I do to give user's peace of mind when handing over their database access?