til
til copied to clipboard
simonw
Today I Learned
https://til.simonwillison.net/sql/cumulative-total-over-time says: > I imagine there's a more elegant way to do this using a window function but this works fine. I was looking at queries of this sort recently....
https://til.simonwillison.net/sqlite/lag-window-function  My goal is to see daily death count, and not grim totals.
I noticed that there is no linter enabled for the Markdown files. Thus, if you forget to add a proper heading at the top of a `md` file you'd be...
https://github.com/github/scripts-to-rule-them-all I'll start with `script/bootstrap` and `script/server` and `script/build` and `script/update` scripts.
Have you ever tried Tiddlywiki for TIL. It is a single page html5 and you can create TIL on the fly using it. See: https://tiddlywiki.com/ Do not forget to check...
https://github.com/simonw/til/blob/master/tailscale/lock-down-sshd.md suggests binding SSH daemon to the WireGuard interface only. This security measure can be bypassed because most modern Linux hosts use the Weak Host Model (see rp_filter settings). Packets...
Thank for this text, working on something similar, you might want to explore [Lambda Layers](https://docs.aws.amazon.com/lambda/latest/dg/configuration-layers.html) and also you can test locally and push your code using vscode aws extension
as this seems the only way to respond: `select strftime('%FT%R:%f');` gives `2024-03-14T06:22:01.416` or whith 'subsec' unix time stamps in the table ``` with t(ue) as (select('subsec')) select strftime('%FT%R:%f', (select ue...
As shown in this TIL, I got stuck! https://til.simonwillison.net/javascript/jsr-esbuild ```bash mkdir /tmp/datasette-demo2 cd /tmp/datasette-demo2 echo '@jsr:registry=https://npm.jsr.io' > .npmrc npm install @jsr/datasette__table echo 'import * as mod from "@jsr/datasette__table";' > index.js...
When I run your async code, I get: Error: await can't be used outside of a function. When I enclose the async code within an async function, I get: TypeError:...
