I fixed a bug in Ekster Reader where when no channel was selected it would not show anything. On desktop browsers it would sometimes show the channel, but not always. On mobile it would never show the channel.
This fix can set an empty channel and this is enough to always show something even when anything is loaded yet.
I recreated the Pipedream workflow that adds emails to a channel in Ekster. The worflow prepares a micropub entry and sends it to the micropub endpoint of Ekster. I can now forward emails to an email address and the workflow processes the rest. This is really useful for newsletters and other marketing emails.
I just added the first integration tests to the automatic deploy of Ekster. It runs the migrations and the some database tests. Drone CI supports the use of services., which will get me a fresh database every run.
Ekster is still getting better. Also the Reader now has a way to switch to search all items instead of just the channel items. Previously you needed to switch the current channel.
It's a good idea to spend some time to work on your projects even if you haven't worked on those projects for a while. Sometimes you can find a new way to improve and use the project for something. Perhaps you see new bugs or new opportunities.
I'm testing with the new bucketed fetching of feeds. The algorithm is similar to algorithm Aperture uses. The difference is that the buckets are powers of 2 at the moment. Every tier is the exponent of 2 minutes, after the last fetch.
In the middle of a rewrite of the backend of Ekster. The next version will have a full Postgres-based backend.
The JSON data type in MariaDB is an alias to LONGTEXT. It seems that even changing the column type from LONGTEXT to JSON doesn't even change the type in the schema, even though it says it updated something.
It seems it should be possible to read the liters of water used from the water meter with a reed switch or some kind of pulse meter. It seems there are solutions that cost about EUR 80. The water meter that we have, has ways to mount a digital meter on top. Perhaps I can make something that reads the gauge.
Ekster adds _source now as a field to the feed items.

Load more