• 0 Posts
  • 19 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.



  • The only viable solutions are e-fuels, which produce fuel from electricity, water and CO2. However these are usually used as distraction, because they cannot be produced at a relevant scale for a reasonable price. The hope is to just burn fossil fuels as long as possible by providing an alternative that will soon solve all the problems. Currently there are only a couple pilot plants working. The price is around 6€ to 8€ per liter and is not expected to go down significantly.

    For other industries such as steel (in the form of green hydrogen) or aviation these e-fuels are the only option to decarbonize. They will pay whatever they need. Better not compete with them for this scarce resource.








  • 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.




  • Growth has always been the biggest stopper for reducing environmental impact. Unfortunately there are a lot of countries which still want/need to grow their economy in order to have similar living standards as in Europe or North America. What Amazon demonstrated here is that it is possible to do this growth (9%) without increasing the carbon footprint (-0.4%). This unfortunately is not what everyone wants to read (including myself), but it is bitter truth of our global economy. (I know that this is a oversimplification and our planet does not care)

    What’s debatable is that they don’t count the environmental impact of other companies products and their clients. I would argue it is more sensible to criticize these companies directly and may be let Amazon force them to publish the environmental impact on the product page. Of course if Amazon would care more about the environment than their bottom line they would act differently, but I don’t believe that…

    Whats the worst is that they are destroying perfectly fine products. This is unacceptable and should be forbidden by law. Additionally they should get sued by the government for doing this thinking it was okay.