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.

Digest for Week 42-2021

Bookmarks

Likes

Notes

  • 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. link
  • 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. link
  • Ekster adds _source now as a field to the feed items. link
  • I made some improvements to the WebSub Hub. This should now actually expire old subscriptions. link
  • I'm trying to add the "_source" field to items in Ekster. At the moment it adds the information from the FeedHeader when it is available. link
  • I just pushed a nice improvement for ek. It allows you to use the name or uid of the channel in all commands. This makes working with it a lot easier. No need to remember random IDs. link
  • The coolest feature from Ekster that I forgot about was the new search integration.You can now search for items in your system in specific fields. An example would be a query for name:weekly. The part "name:" would find items with the word weekly appearing in the name. All supported JF2 properties could be looked for. link
  • I just noticed Home Assistant supports Indieauth to get access tokens. That's great! link
  • A few days ago I saw a video by Aaron Parecki talking about PKCE. It seems to be a useful improvement to OAuth and Indieauth.

So today I added this to the weblog. It can now do the extra verification that happens, because of PKCE. It was pretty simple as you can add it as a few steps between the normal authentication. The structure itself stays very much the same. So this was the authorization server side of the protocol. Now I should add this to the clients that I created. link

Replies

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.

Load more