Articles

3D printable drone development frame

On my way to develop a 3D printable camera drone I designed and printed different housings and frames. But I always came to a point where I had to make changes: sometimes I had to reposition the GPS unit, change the position of the camera, relocate cables, etc. I had to make a lot of changes. All this led me to discard the design again and again and develop a new one. This slowed me down a lot in the development, so I decided to create a flexible and quickly customizable development framework.

Supabase throws "new row violates row-level security policy for table" even though I had created a row level policy for inserts

I was confronted with a Supabase problem that (almost) drove me crazy: I have a simple table "projects" that only stores a project uuid and a project name. While developing on my Web-App I disabled role level security (RLS) for this table. I usually proceed disabling row level policies in the first phase of developing as it helps me to focus on the frontend and the general project scheme.

Supabase: How to query users table?

Ever wondered how to query your users table in Supabase? This was my questioned of the day: I developed a Node.js middleware for my Vue Time Tracking App that I hopefully can release soon. The exact question was: "how to query users by email?".

Tags

Plausible Analytics: Integrate Google Search API

I already wrote about how great Plausible is as an alternative to Google Analytics a few days ago in this article. Today I want to show you how to integrate Google Search Console to see what keywords users are using to land on your site.

Tags

3D Printed Camera Drone: A New Attempt

What you see here is the first attempt to develop a camera drone from the 3D printer. I want to revisit the project and solve the problems of the prototype step by step.

Admittedly: the design is at least "plain" - but that wasn't my ambition either. The first version was a prototype quickly clicked together in Fusion 360, primarily to produce anything flyable at all. My focus here was primarily on the engineering, and I wanted to get a sense of where the challenges were in this project.

Tags

Install Plausible on Digitalocean Droplet

Plausible is a minimalistic and DSGVO-compliant alternative to Google Analytics. It works completely without cookies and is also open source. Quite a few good arguments. It's high time to turn my back on Google Analytics anyway, so I'm taking a closer look at Plausible

The goal: Give Plausible a chance and install my own Plausible server on a DigitalOcean droplet to track this website.

Overview:

Tags

Program a crypto trading bot

I want to develop a crypto trading bot that automatically buys and (hopefully) sells cryptocurrencies for a profit. In this series of articles, I document how I go about it and whether it can even work.

Drupal 9.1 REST: Post and patch requests are rejected

For a few days now, I've been observing the same problem in various projects: post and patch requests on some Rest endpoints are being rejected with an Error 500.