diff options
| author | Paul Duncan <pabs@pablotron.org> | 2022-02-17 20:14:03 -0500 |
|---|---|---|
| committer | Paul Duncan <pabs@pablotron.org> | 2022-02-17 20:14:03 -0500 |
| commit | 70bc9334aad8e2853204da02e5534cbdb6f44431 (patch) | |
| tree | 2800fbc235cef3e3ad446245efc113bce5923a53 /TODO.md | |
| parent | 7bbc065f4176c6e36bb2d7976e83d1b692274921 (diff) | |
| download | pablotron.org-70bc9334aad8e2853204da02e5534cbdb6f44431.tar.bz2 pablotron.org-70bc9334aad8e2853204da02e5534cbdb6f44431.zip | |
TODO.md: move pg tricks idea
Diffstat (limited to 'TODO.md')
| -rw-r--r-- | TODO.md | 20 |
1 files changed, 10 insertions, 10 deletions
@@ -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`? |