We got our solar roof around 1st of April. I am describing our setup here . Today we got the bill for Summer 2021 to Summer 2022.
What I measured I installed a P1 interface on my electricity counter late in April, so my data does not cover all of the lifetime of the Solar Roof. Starting the graph at 01-Apr-2022, I get this:
At this resolution, not very helpful.
I am on a Mac or on a Windows machine, and always I have to develop for a Linux target. On Windows, this is easy, because most Jetbrains environment already support working inside WSL2, so simply choosing this is a no-brainer.
On MacOS, I can create a “Docker Container” do develop in, but it is kind of a joke. That is, because MacOS cannot run Linux cgroups and namespaces natively, so you actually get a lightweight VM with Linux running, and then a container inside that.
MySQL 8.0.29 adds ALGORITHM=INSTANT as a way to run ALTER TABLE commands with less wait. The documentation can be found in Online DDL Operators and instant column operations can be found here .
Example Syntax looks like this:
mysql> use kris; mysql> create table t (id serial, d varchar(20)); Query OK, 0 rows affected (0.12 sec) mysql> alter table t add column i integer not null, algorithm=instant; Query OK, 0 rows affected (0.
After getting a solar roof we have been looking at electric mobility solutions. But existing electrical cars seemed pretty much oversized. We do not really need a 4-seater with 650km range and two tons of total empty weight. Katja Diehl coined the german tongue-in-cheek term “Maximaleventualbedarfsauto” for it, the car that meets biggest use-case you could possibly reasonably have.
Looking around, we test drove a Carver.Earth , which was the right size, but limited to 45 km/h (and bike pathes in some areas).
I have been asked what kind of bike I ride and how to choose one.
Gazelle Grenoble 2017, with vaude Aquaback plus.
I am over 50 years old, over 200cm tall and weigh more than 120 kilo before I dresss. Back when we still had an office, that was a 22km trip, each direction.
I need an upright sitting position, a soft and comfortable seat. I need to be able to carry luggage, and a return-home guarantee.
(Twitter thread , reproduction in english, and update)
On Friday, 2022-06-03, 14:42, we lost a replication hierarchy, on the primary, all replicas down. At 16:30 the escalation hits my desk, because this one is special.
Replication stops, and wants more max_allowed_packet There is a sequence of binlogs, each 1 GB in size, as configured, except for the broken one, which is 3 GB. Replication stops with
Got fatal error 1236 from master when reading data from binary log: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master; the first event '' at 4, the last event read from '.
Where I work, we manage databases in an automated way . Not as automated as I wish it to be, but largely without touching boxes.
We have been doing so for a long time.
Over ten years ago, I set the team the challenge “be on an arbitrary version of MySQL within 20 workdays (one calendar month), no matter how many servers we have”. We are there now, in a way: we are on a 30-day refresh cycle for our bare metal cloud, and we match that cycle for our virtualized fleet.
Der Schnuppel ist jetzt in der niederländischen Groep 8, also in der 6. und letzten Klasse der Grundschule. Die letzten Tests sind geschrieben, die Schulempfehlungen sind raus und bindend, die Folgeschule steht fest und hat die Anmeldung bestätigt. Das Schuljahr ist also noch lange nicht zu Ende, aber alle Arbeit ist getan.
Das Snackphone One, Zubehör und Nachfolgemodelle im Webshop.
Letzten Freitag kam der Schnuppel aus der Schule und berichtete davon, daß er mit einigen Freunden und Banknachbarn “Mobiltelefone” gebaut habe.
Robert Nystrom is a language developer who works at Google on the Dart programming language. In his book Crafting Interpreters he explains lexing, parsing and executing a programming language in an accessible way.
"Crafting Interpreters ", Robert Nystrom
Nystrom sets out with the (correct) observation that the matter of handling and executing code is a complex topic that is not made easier with all the theory that surrounds it. In his book, he takes the reader on a journey to implement a toy language, Lox, two times.
The Netherlands realized around 2000 that they have a problem with bike parking around train stations, and with parking around stations in general. A program was set up to fix that, assuming things would be done with in ten years. The program was a great success, and people taking the bike to use the train, and to use a bike after they arrived at their destination by train increased greatly. This created more needs, and so the program is, changed, still active today.
A book from 2017, about the Spanish Flu, which in the wake of the first world war turned into a global pandemic, killing between 50 and 100 million people on all continents.
Pale Rider , Laura Spinney
Spinney describes the situation in the world in 1918, and how the Spanish Flu came into the world, and was experienced by people in various parts of the world. The flu returned in several waves, some of which behaved unlike normal flu seasons and also had weirdly shaped killing patterns in the population.
On an alternate earth alternate biology produces beings that can grow up to 150 meters tall and that are powered by natural biological nuclear reactor: The Kaiju. Whenever anything, humans or Kaiju, uses nuclear energy, the boundary between the alternate realities is weakened and things can cross over. That happened the first time late in the second world war, and that is how the legend of Godzilla came into the world.
The subtitle of “Sid Meier’s Memoir!” is “A Life in Computer Games”. And that is exactly what we get: Sid Meier lists, chronologically and very systematically, all the games he has been working on during his lifetime. And tells us what happened to him, the game and the game development process while he worked on it. Somehow that becomes a Memoir, even if some things are only implied or appear out of order.
This is an old book, from 1998, and much of the technology referred to directly has evolved since then. But, as this a book that deals with basics, in terms of metaphor and analogy, it is still valuable. It explains how computers work, and how we make the tech that powers them.
The Pattern on the Stone , W. Daniel Hillis
Computers are really easy. There is just Zero and One, and it does not get any more complicated than that.
I live in a house in a rural village somewhere in Randstad . We are paying around 70 Euro per month in electricity, and up to 380 Euro per month in gas. We are using the latter for heating and warm water, but we are already cooking with electricity.
The house has a decent energy rating and a heat exchanger in the forced ventilation system. That is to keep the warmth in when getting fresh air in.
Where is the Internet coming from and how and when was it built? It’s a network of tubes, or rather cables, and these days they are mostly fiber. Much of it was built during the dotcom boom, but little has been written.
The Undersea Network , Nicole Starosielski
Nicole Starosielski is a professor at New York University Steinhardt, and specializes in Internet Infrastructure, specifically underwater sea cables. In her book, she documents the history and development of the infrastructure that carries more than 99% of todays Internet data, the backbone that defines the global transport capacity of the Internet.
April 15, 2022
Where I work, the native database is MySQL. This is what the database team fully supports.
Other databases, notably Postgres, are in use mostly because external products we run require them. Internal projects should use MySQL. An external company provides limited support for running Postgres.
The recommended version of MySQL to be used is currently the latest 8.0. It has a large number of improvements over the previous version 5.7 in terms of the SQL subset supported, handling of sorts, critical character set support and join strategies.
MySQL uses replication to do an ongoing life restore of a primary server to any number of replicas. How replication came to be I have discussed previously in another article .
Modern replication uses row based replication, with a minimal row image and compression. What is that?
Decoding the Binlog When using Row Based Replication, the Row Change event is represented using the BINLOG statement in the output of the mysqlbinlog command.
On Twitter, Samuel Nitsche asked:
Are there “IT history nerds” on this app? Like people who have the skills/knowledge to tell how some trends/evolutions in IT appeared? I’d love to connect!
Asking about what he wanted to know specifically he said, he’s interested in the reasons why DevOps and Agile take up in DBA circles is so slow and low. That forced me to brain dump stuff that has been active in the back of my mind for quite some time now, but which I never collected properly.
March 24, 2022
When using MySQL with Python, you may want to use the mysqlclient library, which is what most people do and which will work just fine. Or you are using the official MySQL 8 Connector/Python package, which will behave slightly differently, but maybe supports the unique MySQL 8 feature already that is not in mysqlclient, yet.
Your SQL may be hand-writtten, or it may be generated using SQL Alchemy, Django or some other package.