Tweets
- Tweets, current page.
- Tweets & replies
You blocked @RhodiumToad
Are you sure you want to view these Tweets? Viewing Tweets won't unblock @RhodiumToad
-
Pinned Tweet
Wow,
@jimmy_wales blocked me, for pointing out the transparency problems with his social media site.Thanks. Twitter will use this to make your timeline better. UndoUndo -
And now that Christoph has found a case where the spec allows a query of unbounded length using only keywords, let's limit it to cases with no loops
Show this threadThanks. Twitter will use this to make your timeline better. UndoUndo -
(Note, PostgreSQL accepts a number of cases of indefinite repetition, so I'm limiting this challenge to valid SQL 2016 foundation syntax)
Show this threadThanks. Twitter will use this to make your timeline better. UndoUndo -
A challenge: what SQL statement contains the longest possible sequence of consecutive keywords? (My best so far has 13 consecutive keywords)
Show this threadThanks. Twitter will use this to make your timeline better. UndoUndo -
Today's fun fact: "Tory" comes from the Irish word for a bandit. Any relevance to modern politics is left as an exercise for the reader
Thanks. Twitter will use this to make your timeline better. UndoUndo -
PSA: When asking for help, show YOUR OWN code / problem description, don't just point to a random forum post and say "I'm having the same problem as this". It makes it impossible to see what simple errors you may have made, or differences between your issue and the post
Thanks. Twitter will use this to make your timeline better. UndoUndo -
Another SQL style tip: always a space before the paren in constructs like "OVER (", "FILTER (", etc. Avoid making things look like function calls when they're not.
Thanks. Twitter will use this to make your timeline better. UndoUndo -
SQL style tip: treat "SELECT DISTINCT" as one keyword that happens to have a space in it. Never put a newline before DISTINCT, and never put an open paren directly after it. When using COUNT(DISTINCT ...), if you absolutely need a paren, then always have a space before it.
Thanks. Twitter will use this to make your timeline better. UndoUndo -
PSA: The error message is the part that starts with "ERROR:". Any DETAIL: or HINT: that follows may be informative, but it is NOT the error message. ALWAYS READ THE ERROR MESSAGE.
Thanks. Twitter will use this to make your timeline better. UndoUndo -
So now I'm curious: to the two people who voted to keep postfix operators in my poll: why? Do you have a use case or an example of existing usage?
Thanks. Twitter will use this to make your timeline better. UndoUndo -
Quick poll: should
@PostgreSQL remove support for postfix operators in expressions, or keep them? Their existence makes parsing a lot harder.Thanks. Twitter will use this to make your timeline better. UndoUndo -
Today's
#PostgreSQL optimization tip: when dealing with queries over many tables, consider increasing from_collapse_limit and join_collapse_limit. https://www.postgresql.org/docs/current/runtime-config-query.html#RUNTIME-CONFIG-QUERY-OTHER …Thanks. Twitter will use this to make your timeline better. UndoUndo -
Also it insists on labelling .h files as being C++ or Objective-C (rather than the C that they actually are) regardless of what I put in .gitattributes.
Show this threadThanks. Twitter will use this to make your timeline better. UndoUndo -
Github language statistics never cease to baffle me. Hundreds of lines of SQL and a 3-line .dir-locals.el, and it says the repo is 100% Emacs-Lisp.
Show this threadThanks. Twitter will use this to make your timeline better. UndoUndo -
I will probably regret signing up for this thing.
Thanks. Twitter will use this to make your timeline better. UndoUndo
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.