• 0 Posts
  • 10 Comments
Joined 2 years ago
cake
Cake day: June 13th, 2023

help-circle


  • Why not?

    We did that for a Plotly dashboard in Python. We copied the database into a read-only in-memory sqlite database (it is quite small, only a couple thousand entries) to prevent any damages outside the dashboard. The data only gets updated every couple of days. You could skip this step. Then with sqlite you can restrict what action a query can use (SELECT, JSON, etc.) and you can restrict the instructions per query to prevent denial of service. It works like a charm and is much simpler than providing a REST API. Also the user might already know SQL.

    I am actually planning something similar for a task management web app I am building at the moment (additionally to providing a REST API). No need to learn another query language like in Jira.


  • I don‘t think it is a binary situation: Complete self sustainability vs. full dependence on large corporations. Rather it is a spectrum and everyone feels comfortable somewhere else on it. Also I don‘t think the ends really exist, as someone else will always have power over you (you can‘t reasonably maintain everything yourself) and you can always migrate/quit from a service. Over time your position might change. For me personally I think Tailscale is a great service and for someone just starting out I would definitely recommend it. I think a lot frustration can be avoided when you don‘t set your self-hosting goals to high at the beginning. You can always update your setup later on.




  • I‘ve actually when something like this will happen. A few years ago German energy providers and distributors needed to split, because it gives you an unfair advantage if you own both. Whole companies were split in two. People working for years together would no longer work together. In the end consumer were much better off after the split. I feel the same way with internet browser. It is unfair if you own the infrastructure (Chrome, energy grid) and the services that run on it (YouTube, power plants).