From f551d868c3e9f3ad5a46e26cb4299bebd91c4903 Mon Sep 17 00:00:00 2001 From: Paul Duncan Date: Sun, 3 Apr 2022 11:28:24 -0400 Subject: TODO.md: pg tiny tricks idea update --- TODO.md | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/TODO.md b/TODO.md index 3035d54..16daf1e 100644 --- a/TODO.md +++ b/TODO.md @@ -109,7 +109,7 @@ this stuff may not make any sense. convert -quality 100 -define webp:lossless=true llvmweekly-new.{png,webp} convert -quality 100 -define heic:lossless=true llvmweekly-new.{png,avif} * pe-figure and pe-picture shortcodes -* pg tiny tricks +* postgres tiny tricks - CTEs as optimization barrier: https://old.reddit.com/r/programming/comments/suyidt/a_hairy_postgresql_incident/hxdvwl4/ - `~* ANY(string_to_array(?))` (comment in reddit w/json array) @@ -119,6 +119,8 @@ this stuff may not make any sense. - trigger `REFERENCING ... AS` (newer PG) - `COMMENT ON` ... - `LISTEN/NOTIFY`? + - timestamptz, long timezone names aware of DST + - RETURNING - misc go cover improvements - add `title` and maybe `aria-label` attributes to relevant elements - add option to include external stylesheet? -- cgit v1.2.3