mrchrisadams

Dear Chris Adams,

We are contacting you because you previously participated in a study on data centre sustainability (EUDCEAR) or you were suggested as potentially interested stakeholder for the topic. The findings of the previous study informed two technical reports which are available online (Report 1, Report 2) and helped identify key priorities for a sustainable data centre sector in the EU.

We are pleased to invite you to participate in the next phase of stakeholder consultation for a new study contracted by the European Commission Directorate-General for Energy (DG ENE

mrchrisadams

Add this to ~/.marimo.toml, and restart Marimo to see the new providers, and models.

Neuralwatt and GreenPT give you energy consumption figures per API key - you can use this to track consumption for specific teams, projects, and so on.

For more, see https://docs.marimo.io/guides/configuration/llm_providers/#custom-providers

mrchrisadams

Proposal: Energy Tracking as a First-Class Citizen in OpenCode

Summary

This proposal adds native energy and carbon tracking to OpenCode by:

1. Capturing measured energy data from providers that supply it (GreenPT, Neuralwatt)
2. Estimating energy for providers that don't measure it
3. Storing energy data alongside existing token/cost data
4. Providing plugin hooks for customization and external integration

mrchrisadams

Energy and Carbon Tracking for OpenCode

Research Document: Instrumenting OpenCode with Energy/Carbon Data

Date: January 2025
Author: Research analysis based on llm-greenpt, llm-neuralwatt, and OpenCode codebase

---

Executive Summary

mrchrisadams

WordPress with SQLite on FrankenPHP

A lightweight WordPress setup using SQLite instead of MySQL/MariaDB, powered by FrankenPHP. No database server required.

Quick Start

For a fresh Ubuntu 24.04 server:

curl -fsSL https://raw.githubusercontent.com/YOUR_REPO/setup.sh | sudo bash -s -- yourdomain.com 8000

mrchrisadams

What's this?

This is is an minimal wordpress plugin we would need to allow any WordPress site to link to a carbon.txt file we would need to set up linked domains to work with the Green Web Platform.

How would it need to work?

1. Install this plugin
2. Activate the plugin
3. Set the location of the carbon.txt file (see the screenshot)

mrchrisadams

{
  "// filepath-in-my-repo": ".devcontainer/devcontainer.json",
  "image": "mcr.microsoft.com/devcontainers/universal:2",
  "features": {
    "ghcr.io/jsburckhardt/devcontainer-features/uv:1": {},
    "ghcr.io/eitsupi/devcontainer-features/just:0": {}
  }
}

mrchrisadams

title	marimo-version	width
Local Llm With Ollama	0.9.1	medium

import marimo as mo
import llm
import markdown

mrchrisadams

select table_schema as database_name,
    table_name,
    round(
        sum((data_length + index_length + data_free)) / power(1024, 2),
        2
    ) as table_size
from information_schema.tables
where table_schema = 'table_name' -- put your database name here
    and table_type = 'BASE TABLE'
group by table_schema,

mrchrisadams

What's this?

This is an experiment with making gunicorn gracefully scale down to zero after X seconds, as a way to do application-level scale-to-zero behaviour in applications that use a webserver like Gunicorn. The idea here is that you do not need to mess too much internal logic of an existing application, nor put it in a container if you use this.

Instead you use the web server's own support for handling SIGTERM signals, to allow gracefully scaling down of processes when they are not in use.

If you're using Linux to run a server, the chances of Systemd being used to manage your processes is fairly high, as it's the default option for a number of linux distributions now.

It also means you might not need a complicated "serverless" system to orchestrate scaling up and down, to reclaim memory on a server for us in other tasks if you have a website or webservice that isn't continually serving traffic.