2,542 karma · joined January 8, 2009
Genetic query optimizer optimizer/path evaluates all possible ways to join the requested tables. When the number of tables becomes great, the number of tests made becomes great too. The Genetic Query Optimizer considers each table separately, then figures the most optimal order to perform the join. For a few tables, this method takes longer, but for a large number of tables, it is faster. There is an option to control when this feature is used.
So what else is in vaping liquid?
"Nicotine as a useful stimulant" (gwern.net)
Favorite browser modification: set default page to about:blank
Twitter's public link shortener, t.co, is one of the worst, imho, because it ubiquitous (so you can't just treat all t.co short links as junk) and yet they make it really difficult report spammy short links. Often these short links get used outside Twitter's platform.
https://regexper.com/#%5B%5E%3C%5D%2B%7C%3C(!(--(%5B%5E-%5D-(%5B%5E-%5D%5B%5E-%5D-)-%3E%3F)%3F%7C%5C%5BCDATA%5C%5B(%5B%5E%5D%5D%5D(%5B%5E%5D%5D%2B%5D)%5D%2B(%5B%5E%5D%3E%5D%5B%5E%5D%5D%5D(%5B%5E%5D%5D%2B%5D)%5D%2B)%3E)%3F%7CDOCTYPE(%5B%20%5Cn%5Ct%5Cr%5D%2B(%5BA-Za-z_%3A%5D%7C%5B%5E%5Cx00-%5Cx7F%5D)(%5BA-Za-z0-9_%3A.-%5D%7C%5B%5E%5Cx00-%5Cx7F%5D)(%5B%20%5Cn%5Ct%5Cr%5D%2B((%5BA-Za-z_%3A%5D%7C%5B%5E%5Cx00-%5Cx7F%5D)(%5BA-Za-z0-9_%3A.-%5D%7C%5B%5E%5Cx00-%5Cx7F%5D)%7C%22%5B%5E%22%5D%22%7C'%5B%5E'%5D'))(%5B%20%5Cn%5Ct%5Cr%5D%2B)%3F(%5C%5B(%3C(!(--%5B%5E-%5D-(%5B%5E-%5D%5B%5E-%5D-)-%3E%7C%5B%5E-%5D(%5B%5E%5D%22'%3E%3C%5D%2B%7C%22%5B%5E%22%5D%22%7C'%5B%5E'%5D')%3E)%7C%5C%3F(%5BA-Za-z_%3A%5D%7C%5B%5E%5Cx00-%5Cx7F%5D)(%5BA-Za-z0-9_%3A.-%5D%7C%5B%5E%5Cx00-%5Cx7F%5D)(%5C%3F%3E%7C%5B%5Cn%5Cr%5Ct%20%5D%5B%5E%3F%5D%5C%3F%2B(%5B%5E%3E%3F%5D%5B%5E%3F%5D%5C%3F%2B)%3E))%7C%25(%5BA-Za-z_%3A%5D%7C%5B%5E%5Cx00-%5Cx7F%5D)(%5BA-Za-z0-9_%3A.-%5D%7C%5B%5E%5Cx00-%5Cx7F%5D)%3B%7C%5B%20%5Cn%5Ct%5Cr%5D%2B)%5D(%5B%20%5Cn%5Ct%5Cr%5D%2B)%3F)%3F%3E%3F)%3F)%3F%7C%5C%3F((%5BA-Za-z_%3A%5D%7C%5B%5E%5Cx00-%5Cx7F%5D)(%5BA-Za-z0-9_%3A.-%5D%7C%5B%5E%5Cx00-%5Cx7F%5D)(%5C%3F%3E%7C%5B%5Cn%5Cr%5Ct%20%5D%5B%5E%3F%5D%5C%3F%2B(%5B%5E%3E%3F%5D%5B%5E%3F%5D%5C%3F%2B)%3E)%3F)%3F%7C%5C%2F((%5BA-Za-z_%3A%5D%7C%5B%5E%5Cx00-%5Cx7F%5D)(%5BA-Za-z0-9_%3A.-%5D%7C%5B%5E%5Cx00-%5Cx7F%5D)(%5B%20%5Cn%5Ct%5Cr%5D%2B)%3F%3E%3F)%3F%7C((%5BA-Za-z_%3A%5D%7C%5B%5E%5Cx00-%5Cx7F%5D)(%5BA-Za-z0-9_%3A.-%5D%7C%5B%5E%5Cx00-%5Cx7F%5D)(%5B%20%5Cn%5Ct%5Cr%5D%2B(%5BA-Za-z_%3A%5D%7C%5B%5E%5Cx00-%5Cx7F%5D)(%5BA-Za-z0-9_%3A.-%5D%7C%5B%5E%5Cx00-%5Cx7F%5D)(%5B%20%5Cn%5Ct%5Cr%5D%2B)%3F%3D(%5B%20%5Cn%5Ct%5Cr%5D%2B)%3F(%22%5B%5E%3C%22%5D%22%7C'%5B%5E%3C'%5D'))*(%5B%20%5Cn%5Ct%5Cr%5D%2B)%3F%5C%2F%3F%3E%3F)%3F)
100000000000000000000000000000000000000000000000000000000000000110000000000000000000000000000000
000000000000000000000000000000111000000000000000000000000000000000000000000000000000000000000111
110000000000000000000000000000000000000000000000000000000000111111000000000000000000000000000000
000000000000000000000000000011111110000000000000000000000000000000000000000000000000000000011111
111000000000000000000000000000000000000000000000000000000001000011110000000000000000000000000000
000000000000000000000000000000000111000000000000000000000000000000000000000000000000000000000000
011110000000000000000000000000000000000000000000000000000000000000111100000000000000000000000000
000000000000000000000000000000000011110000000000000000000000000000000000000000000000000000000000
000111100000000000000000000000000000000000000000000000000000000000011111000000000000000000000000
000000000000000000000000000000000000111110000000000000000000000000000000000000000000000000000000
000011111100000000000000000000000000000000000000000000000000000000000111111100000000000000000000
000000000000000000000000000000000000011111111100000000000000000000000000000000000000000000000000
000000111111111100000000000000000000000000000000000000000000000000000011111111111000000000000000
000000000000000000000000000000000000000111111111111000000000000000000000000000000000000000000000
000000001111111111111100000000000000000000000000000000000000000000000000111111111111111100000000
000000000000000000000000000000000000000011111111111111111000000000000000000000000000000000000000
000000001111111111111111110000000000000000000000000000000000000000000000111111111111111111000000
000000000000000000000000000000000000000011111111111111111110000000000000000000000000000000000000
000000001111111111111111111000000000000000000000000000000000000000000000011111111111111111100000
000000000000000000000000000000000000000001111111111111111110000000000000000000000000000000000000
000000000111100001111111110000000000000000000000000000000000000000000000011110000011111111000000
000000000000000000000000000000000000000001111000000111111100000000000000000000000000000000000000
000000001111100000011111110000000000000000000000000000000000000000000000110110000000110111000000
000000000000000000000000000000000000000011011000000011101110000000000000000000000000000000000000
000000011001100000001110111000000000000000000000000000000000000000000001100110000000111001110000
000000000000000000000000000000000000000110011000000011100110000000000000000000000000000000000000
000000011001100000001100011000000000000000000000000000000000000000000000110010000000100001100000
000000000000000000000000000000000000000001001000000110000110000000000000000000000000000000000000
000000000011100000010000011000000000000000000000000000000000000000000000001110000011000001100000
000000000000000000000000000000000000000000011000011000000110000000000000000000000000000000000000
000000000001100001100000011000000000000000000000000000000000000000000000000111001100000001100000
000000000000000000000000000000000000000000011100110000000110000000000000000000000000000000000000
000000000001010011000000010000000000000000000000000000000000000000000000001100000000000011000000
000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000001000101101001https://nutritionfacts.org/video/sodium-and-arterial-functio...
That's pretty impressive.
which led me to David Khourshid's worthwhile "Infinitely Better UIs with Finite Automata" presentation, https://www.youtube.com/watch?v=VU1NKX6Qkxc
and the article "You are managing state? Think twice", http://krasimirtsonev.com/blog/article/managing-state-in-jav...
Attribute value minimization would be one limitation, since that regex is for XML, but it's a more robust approach than writing naive "<x>.*</x>"-style regexes.
import sys
s = b'y\n' * 1024
write = sys.stdout.buffer.write
while True:
write(s)
# 1.12GiB/s
Plain old yes comes in at 22Mib/s.The Python3 docs say to "use the underlying binary buffer object" when reading or writing binary data.
"it is an abuse of terminology to call the fraction part a mantissa, since this concept has quite a different meaning in connection with logarithms"[1] –DEK
[1] https://en.wikipedia.org/wiki/Significand#Use_of_.22mantissa...
Related to yesterday's TLA+ video post https://news.ycombinator.com/item?id=13918648