I write everything in Python normally. I wanted to write something to sell to non-programmers/technical people. So, I wrote a tool in Excel, with the algorithms in VBA.
This is not an ideal solution for a number of reasons.
What I’m looking to do:
- Simple one/two page website
- Ability for users to "checkout" one item (would prefer if this is handled by some template thing that has Stripe integrated already...)
- This provides them access to one page for a limited amount of time
- The page lets them enter text data, run an algorithm, spits data back to them
- Their token is revoked after X time and they then have to re-buy access
What’s the best way to do this? Should this have an API behind the scenes to ‘call’ the algorithm a fixed number of times for a unique token? Should this just be handled by a user login that expires after X time?
I’m looking for the simplest solution.
I looked at Squarespace (no support for Python/Flask) and WordPress (just endless add-ons that are charged on a per month basis)…
N.B. Reasons Excel wasn’t a good idea: I found out that there is no real way to sufficiently secure the VBA from prying eyes. There’s an inbuilt password feature (30 seconds to work around) and obfuscation (algorithm structure is still there though). The other issue, of course, is that there’s no ability for access control with Excel, so once a user has paid for and downloaded the spreadsheet, they can share it.
smollma is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.