2,185 karma · joined September 12, 2019
These days I mostly do r&d for custom sensors, custom hardware and firmware to drive them, data analysis, physics simulations, etc.
Mostly using c#, f#, python, fortran, c, verilog
There's probably an extension for permissions in sqlite but out of the box the db files are plaintext (you need an extension for that).
Good starting point for extensions: https://antonz.org/sqlean/
Poetry is the most common solution that I've seen in the wild. You spec everything using pyproject.toml and then "poetry install" and it will manage a venv of its own. But you still need to tell people to "pip install poetry" as step 0 which is annoying.
If you don't care about deploying python files, and rather just the final product, I'd recommend either nuitka or pyinstaller. These are for bundling your project into an executable without a python runtime needed (--onefile type of options for single file output). Neither supports cross compilation though.
Meanwhile I can hack together a poor man's webrtc by sending raw packets over websockets and playback works just fine. I just lose all the real benefits of webrtc (robustness, udp vs tcp, etc.). It feels like it should be possible to work around "secure context" nonsense since I don't access anything on the clients, they just play back a stream from the devices. But chrome/ff tends to block the ice handshake in http mode.
Your robot could easily sell at 20-30k. If you add some kind of calibration/support service to guarantee whatever operating parameters, you could charge a subscription on top of that. Test equipment is normally fairly expensive and specialized, and no one who runs tests in a commercial environment wants to be in a situation where they are their own checks/balances. So even though they could easily build/maintain test equipment themselves, companies will avoid it if possible. It's why businesses will buy the $5k name brand multimeters, test probes, etc instead of the $200 no name one with the same specs.
If you want specifics, I tend to use chartjs for real time data visualization. I often find it tedious to add markup graphics in real time (for example, to draw attention to or highlight anomalies).
There are quite a few other options besides certbot, I was just suggesting it as a "install + one liner" for adding auto renewing ssl certs to a server.