diff options
| author | Paul Duncan <pabs@pablotron.org> | 2022-04-03 11:28:24 -0400 |
|---|---|---|
| committer | Paul Duncan <pabs@pablotron.org> | 2022-04-03 11:28:24 -0400 |
| commit | f551d868c3e9f3ad5a46e26cb4299bebd91c4903 (patch) | |
| tree | e2d514bd61d6ba34b008a900d70a1473fdb73e6e | |
| parent | 67318c7f0b79d4e9e0b30563e7f1868915a6c538 (diff) | |
| download | pablotron.org-f551d868c3e9f3ad5a46e26cb4299bebd91c4903.tar.bz2 pablotron.org-f551d868c3e9f3ad5a46e26cb4299bebd91c4903.zip | |
TODO.md: pg tiny tricks idea update
| -rw-r--r-- | TODO.md | 4 |
1 files changed, 3 insertions, 1 deletions
@@ -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? |