Things I've learned, collected in schu/notebook.
Browse by topic: demo 1 · duckdb 3 · git 1 · javascript 1 · macos 1 · mssql 1 · security 1 · typst 1 · vim 1
List apps for which incoming connections are allowed or blocked. …
Links with details on the attack and aftermath: …
DuckDB's multi-database-support can be a convenient way to transform and move data between databases. …
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. …
Small JavaScript snippets. …
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: …
A Git post-receive hook to deploy a static site to a directory: …
Sometimes I need to export data from a MSSQL server to JSON. …
Show page counter only from page 3 onwards: …
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: …
Welcome to this notebook! …