aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--TODO.md20
1 files changed, 10 insertions, 10 deletions
diff --git a/TODO.md b/TODO.md
index bf9d5ab..39866ab 100644
--- a/TODO.md
+++ b/TODO.md
@@ -107,6 +107,16 @@ 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
+ - 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)
+ - pub/sub?
+ - domains instead of repeated check constraints
+ - trigger `TG_ARGV`
+ - trigger `REFERENCING ... AS` (newer PG)
+ - `COMMENT ON` ...
+ - `LISTEN/NOTIFY`?
## done
* add project folders
@@ -136,13 +146,3 @@ this stuff may not make any sense.
https://forums.somethingawful.com/showthread.php?noseen=0&threadid=2389159&perpage=40&pagenumber=865#post520151251
https://nathanotterness.com/2021/10/tiny_elf_modernized.html
(created repo: https://github.com/pablotron/tiny-binaries)
-* pg 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)
- - pub/sub?
- - domains instead of repeated check constraints
- - trigger `TG_ARGV`
- - trigger `REFERENCING ... AS` (newer PG)
- - `COMMENT ON` ...
- - `LISTEN/NOTIFY`?