schu's notebook

Things I've learned, collected in schu/notebook.

Atom feed

Browse by topic: demo 1 · duckdb 3 · git 1 · javascript 1 · macos 1 · mssql 1 · security 1 · typst 1 · vim 1

Recent notes

macos macOS: list allowed incoming connections - 2024-06-04

List apps for which incoming connections are allowed or blocked. …

security Notes on the XZ backdoor (CVE-2024-3094) - 2024-04-05

Links with details on the attack and aftermath: …

duckdb DuckDB: migrate data with multi-database support - 2024-03-24

DuckDB's multi-database-support can be a convenient way to transform and move data between databases. …

duckdb DuckDB: `lag` preceding day - 2024-03-23

The lag window function allows to evaluate an expression at offset rows before the current row. For time series data, sometimes it is desired to only get previous values in a certain time window. In the example below, only the entry of the preceding day should be considered - if it exists. …

javascript JavaScript Cheatsheet - 2024-03-11

Small JavaScript snippets. …

duckdb DuckDB: aggregate multiple rows into a single JSON object - 2024-02-29

The other day I was looking for a way to transform a table with multiple rows per user to a single row per user layout. The source table had a structure similar to the following example: …

git Git post-receive hook for static site deployments - 2024-02-28

A Git post-receive hook to deploy a static site to a directory: …

mssql MSSQL to JSON export - 2024-02-21

Sometimes I need to export data from a MSSQL server to JSON. …

typst Typst: hide footer page counter on some pages - 2024-02-14

Show page counter only from page 3 onwards: …

vim Vim: `ModuleNotFoundError: No module named 'powerline'` - 2024-02-13

I use powerline-status and powerline-gitstatus with Vim and sometimes encounter the following error when the default Python version diverges from the one that Vim is linking: …

demo Hello World - 2024-02-12

Welcome to this notebook! …

Browse all 11 notes