n2o

As to my knowledge, strapi does not provide any options to set the email urls via the environment variable. So I included it into the strapi bootstrap function. It relies on the environment variable common.emails.resetPasswordUrl:

// index.ts
import type { Core } from "@strapi/strapi"

async function setEmailConfiguration(strapi: Core.Strapi) {
  strapi.log.info("✉️  Setting email configuration...")
  const resetPasswordUrl = strapi.config.get("common.emails.resetPasswordUrl")
  strapi.log.info(`✉️  Reset password Url: ${resetPasswordUrl}`)

n2o

Tools! Eine Toolsammlung aus der EntwickelBar 04/2025

macOS

• https://lowtechguys.com/clop/
• https://lunar.fyi/
• https://www.raycast.com/

Windows

n2o

SHA256-Function in VBA for Mac-Users and Microsoft Excel

I needed a function to hash a cell's content in Microsoft Excel. Internal calls to .NET functions don't work on a Mac. Also the Python-Integration is only available in Business-Plans. So I wrote a VBA function to hash a string with SHA256 on a Mac.

This VBA function uses the Mac's internal sha256 implementation, makes a system call and returns the hash. The function is called SHA256_Mac and takes a string as input. The function returns the hash as a string.

Add it to your macro-enabled Excel file and use it like this:

=SHA256_Mac("abc")

n2o

Convert wav file to 16 kHz for Whisper in Rust

If you want to convert a wav file to 16 kHz for whisper in Rust, you can use the following script. It uses the hound crate to read and write wav files and rubato to resample the audio.

Reads a file as input.wav and returns a converted wav as output.wav.

use rubato::{
    Resampler, SincFixedIn, SincInterpolationParameters, SincInterpolationType, WindowFunction,
};

n2o

Let's assume we have a post type employee and some categories. We want to get all employees, who are assigned to a specific category to add them via a shortcode. The shortcode should have two attributes: category and layout. The category attribute should accept a comma-separated list of category slugs or IDs. The layout attribute should define the output layout: grid or slider.

Here is an example of how to create a shortcode to list employees by category:

/**
 * Listing of employees by category
 *
 * Example: [employee category="Physiotherapie" layout="grid"]
 * - layout="grid": Displays the employees in a grid (default)

n2o

This script creates a sitemap based on the page.tsx-files found in your app-directory.

Create a file called sitemap.ts inside of your app/ directory of your NextJS application.

Then fill it with this script:

import { globby } from "globby"
import type { MetadataRoute } from "next"

n2o

Pico W as Wifi Access Point

This script spins up the Pico W as a Wifi Access Point. It assigns itself the IP 192.168.4.1 and assigns new Clients some IP starting at 192.168.4.16 or so.

import network
from machine import Pin

led = Pin("LED", Pin.OUT)

n2o

Arduino Nano ESP32 to an Waveshare OLED 1.5" 128x128 Module

• Arduino Nano ESP32
• OLED Display Module
• Libraries used:
  • Adafruit_GFX
  • Adafruit_SSD1351

The sketch is not by me, it's reduced to a minimum and to document for myself how I connected the display 😅

n2o

Strapi: The missing Docs

Strapi is a great project, but lacks of a good documentation concerning customization. This gist presents some of my findings / experiments to customize strapi.

users-permissions plugin

Add policies to existing routes

My use-case: find and findOne need to be active to keep nested queries on other user-relations. But if I allow authenticated users to access these routes, they can access all users. So I customize these routes with my own policies:

n2o

To give access to a role from the users-permissions model in Strapi v4, you need to create a permission and add it to the role.

Useful for testing. Gives authenticated users access to the provided routes.

import request from "supertest";
import { setupStrapi, stopStrapi } from "../../../../tests/helpers/strapi";
import { createUser } from "../../../../tests/user/factory";

let user;