2 ms·
The problem is that the amateur programmers are unlikely to be building doghouses. What is more likely is that you end up maintaining someone's Macro laden exce
by jiggy2011 15y ago
The problem is that the amateur programmers are unlikely to be building doghouses. What is more likely is that you end up maintaining someone's Macro laden excel spreadsheet because it is now mission critical infrastructure.
What tends to work as a happy medium for me is that I implement a proper relational database on the backend but have it output spreadsheets which people can Macro till their hearts content on the understanding that the database is the definitive copy.
I also allow people to upload their spreadsheets back to the database where it will import only changes to certain fields and heavily sanitize everything.
It's difficult to think of a programming task that is equivalent to building a doghouse, perhaps building a personal website with PHP might fill this niche but there are still security aspects to consider.