diff options
author | Paul Duncan <pabs@pablotron.org> | 2022-02-17 19:59:56 -0500 |
---|---|---|
committer | Paul Duncan <pabs@pablotron.org> | 2022-02-17 19:59:56 -0500 |
commit | 7bbc065f4176c6e36bb2d7976e83d1b692274921 (patch) | |
tree | bd0f9b5e1f82f2c95b04d56ce7b99aa3c1812ba5 | |
parent | d7a1422f2484ad21eee8c3fa498181552285f8e3 (diff) | |
download | pablotron.org-7bbc065f4176c6e36bb2d7976e83d1b692274921.tar.bz2 pablotron.org-7bbc065f4176c6e36bb2d7976e83d1b692274921.zip |
TODO.md: add pg tricks
-rw-r--r-- | TODO.md | 10 |
1 files changed, 10 insertions, 0 deletions
@@ -136,3 +136,13 @@ 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`? |