If Python in a spreadsheet is what you want, you might like Grist:
Disclaimer: I work there. I'm trying to make it easier to self-host. Send me github issues or pull requests if you have ways of making it better. :)
Disclaimer: I work there. I'm trying to make it easier to self-host. Send me github issues or pull requests if you have ways of making it better. :)
* I am annoyed that the the app requires providing inputs through command line args or environment variables rather than a fixed config file that I can store in git. * Some directions on creating a service that starts the app on server restart etc would be good.
Using Docker, you can just put your env-vars in a file and execute Docker with --env-file specifying where your configuration is, which is what I currently do, but perhaps a .env file would be more standard and comfortable.
If you want those people to use your software, you should make it as easy as possible to install it. Think of a tech-minded teenager helping their dad set up grist to track inventory for their corner store. How can you help them install the software in a couple of hours?
Moreover, since it's using sqlite in the backend for the database, cells are allowed to hold the wrong type (and big, red warning colours light up when this happens). This is a sqlite characteristic. So while it mostly does enforce database-like behaviour, it also allows spreadsheet-like lax behaviour.
It really is a mixture of database and spreadsheet.