6 ms·
Pardon my ignorance--is inspections some concept that relates to database management, or are you referring to a query like "select * from inspections where stat
by shoguning 6y ago
Pardon my ignorance--is inspections some concept that relates to database management, or are you referring to a query like "select * from inspections where status = 'open';". Honestly asking.
- crgwbr 6y agoI believe OP is just referring to the ability to run adhoc queries. Typically nosql solutions are built to be performt for common access patterns, at the expense of being difficult or impossible to query in unplanned ways. SQL DBs are very good in that regard.
- shoguning 6y agoThanks! And yes, I agree. The ability to write ad hoc SQL is a great skill.
- jonathanzufi 6y agoTotally. I’ve always admired SQL wizards and their ability to (quickly) produce the most optimal queries given the relatively limited syntax (compared to what you can do with frameworks like, for example, LINQ today).
- SamuelAdams 6y agoAh yes, inspections in this context means Safety Inspections, aka a business rule or thing. Industry is Retail / Grocery. Inspectors inspected food at stores on day one and Stores had 5 business days to “complete” the inspection. Internal audit wanted a list of “defaulted” inspections so they could go harass the store people to get their things done.