I consider myself pretty knowledgeable with most computing tasks, not particularly great with basic spreadsheets, but unless there’s some kind of usable frontend to reliably manage a database, I mostly see databases as:
“A magic box that holds tons of cryptic information, would be tedious to open, risky to edit, risky to backup or migrate or update, and could corrupt at any moment.”
Maybe I should put more effort into learning DBs besides initializing them in a Docker compose and praying, but for human readable information that’s meant to be shared, I think you’re bang on the money when it comes to why spreadsheets are still so popular!
As someone who interacts with databases regularly… Yeah, that sounds about right.
I was recently working with another team’s feature to handle data retrieval for the end user, pretty front end but it was far too tightly coupled with db management concepts. How is a non-technical person supposed to know the difference between an inner join and a left join?
Not too long ago I suggested using cross apply to a senior dev I work with and they admitted they weren’t sure what that does or how to use it. People who don’t regularly work with databases have no chance.
I consider myself pretty knowledgeable with most computing tasks, not particularly great with basic spreadsheets, but unless there’s some kind of usable frontend to reliably manage a database, I mostly see databases as:
“A magic box that holds tons of cryptic information, would be tedious to open, risky to edit, risky to backup or migrate or update, and could corrupt at any moment.”
Maybe I should put more effort into learning DBs besides initializing them in a Docker compose and praying, but for human readable information that’s meant to be shared, I think you’re bang on the money when it comes to why spreadsheets are still so popular!
As someone who interacts with databases regularly… Yeah, that sounds about right.
I was recently working with another team’s feature to handle data retrieval for the end user, pretty front end but it was far too tightly coupled with db management concepts. How is a non-technical person supposed to know the difference between an inner join and a left join?
Not too long ago I suggested using cross apply to a senior dev I work with and they admitted they weren’t sure what that does or how to use it. People who don’t regularly work with databases have no chance.