Using SQLite as Vector Store in PHP At work, I'm working on a plugin for DokuWiki that uses OpenAI's ChatGPT to answer questions by referencing the wiki pages. The basic principle is described in this forum post: Experimental Plugin: AIChat - chat with your wiki pages using ChatGPT. Basically, get embedding vectors for all your page data, use those to find the data that is semantically most similar to the asked question and use that as a context for ChatGPT.… ▶

Liberating the Sonoff Power Elite My DIY Wall Box has worked great for the last couple of years until recently. For some reason the charging stopped despite the car's battery being far from full. Turning off the power and turning it back on fixed the problem for a bit until charging stopped again.… ▶

404 - Bench not found For the last week, we've been on a small vacation to the Baltic Sea and when we returned, our neighbors asked if we had experienced “the storm” up there. We hadn't and didn't think much about it. But when I went for a walk with Tarly today, I understood what they meant by… ▶

Tarly Update A little less than half a year ago, Tarly came into our life. As a shelter dog with a mostly unknown past, he isn't an easy dog. But today I realized how much progress there has been already. During our morning walk he stuck his nose into some deep grass and when he came out, his face was full of burs. Just a couple of months ago this would have been a… ▶

Music Recommendation: Ren This is probably old news for young folks, but I only recently stumbled about the music by Ren. To me it's probably the most powerful thing that I've heard in the last couple of years. I'm not able to find the right words to describe Ren's music. The lyrics (powerful, easy to understand despite the thick Welsh accent), the music (such a wide range) and the videos (often shot in one continuous take) are just forming an overall master piece.… ▶

Guerilla Banking On my days off, I like to take the car and drive a bit to take Tarly on a walk through the nearby fields and forests instead of walking through the immediate neighborhood. One of our usual rounds comes by an old oak tree in the middle of several fields. And under that oak is a bench. I love to take a break there, drink coffee from a thermos, listen to the birds and pet the dog. I'm nearly 45 and I have come to enjoy the existence of a well placed bench.… ▶

Google Maps Reviews are Dead Remember when Google Maps reviews meant something? For a while it felt like they empowered the “common man”. If you received shitty service or were taken advantage of, you could at least warn your fellow men... Nowadays the Maps reviews are more and more meaningless. I talked about the fake reviews of my… ▶

Goodbye Goodbye little horse girl. I'm sorry I couldn't be what you wanted me to be. I will miss you. I will miss your Whatsapp statuses of random memes and horses. I always knew it would be temporary -- until you'd find what you were really looking for. I didn't expect it to end like this though.… ▶

Kia Ceed For nearly two and half years I'm driving a Kia Ceed. Time to do a little review. First of all this is a company car, so gift horse and all that... The Ceed is a much bigger car than what I would have gotten myself. But its also much nicer than what I would have gotten.… ▶

Solar We finally have a working solar setup. The whole thing was a painful experience and I am glad it's mostly over. Time to tell the story. Sorry, this will be long... … ▶