Skip to content
By using Twitter’s services you agree to our Cookies Use. We and our partners operate globally and use cookies, including for analytics, personalisation, and ads.

This is the legacy version of twitter.com. We will be shutting it down on June 1, 2020. Please switch to a supported browser, or disable the extension which masks your browser. You can see a list of supported browsers in our Help Center.

  • Home Home Home, current page.
  • About

Saved searches

  • Remove
  • In this conversation
    Verified accountProtected Tweets @
Suggested users
  • Verified accountProtected Tweets @
  • Verified accountProtected Tweets @
  • Language: English
    • Bahasa Indonesia
    • Bahasa Melayu
    • Català
    • Čeština
    • Dansk
    • Deutsch
    • English UK
    • Español
    • Filipino
    • Français
    • Hrvatski
    • Italiano
    • Magyar
    • Nederlands
    • Norsk
    • Polski
    • Português
    • Română
    • Slovenčina
    • Suomi
    • Svenska
    • Tiếng Việt
    • Türkçe
    • Ελληνικά
    • Български език
    • Русский
    • Српски
    • Українська мова
    • עִבְרִית
    • العربية
    • فارسی
    • मराठी
    • हिन्दी
    • বাংলা
    • ગુજરાતી
    • தமிழ்
    • ಕನ್ನಡ
    • ภาษาไทย
    • 한국어
    • 日本語
    • 简体中文
    • 繁體中文
  • Have an account? Log in
    Have an account?
    · Forgot password?

    New to Twitter?
    Sign up
patio11's profile
Patrick McKenzie
Patrick McKenzie
Patrick McKenzie
@patio11

Tweets

Patrick McKenzie

@patio11

I work for the Internet, at @stripe, mostly on accelerating startups. Opinions here are my own.

東京都 Tokyo
kalzumeus.com
Joined February 2009

Tweets

  • © 2020 Twitter
  • About
  • Help Center
  • Terms
  • Privacy policy
  • Imprint
  • Cookies
  • Ads info
Dismiss
Previous
Next

Go to a person's profile

Saved searches

  • Remove
  • In this conversation
    Verified accountProtected Tweets @
Suggested users
  • Verified accountProtected Tweets @
  • Verified accountProtected Tweets @

Promote this Tweet

Block

  • Tweet with a location

    You can add location information to your Tweets, such as your city or precise location, from the web and via third-party applications. You always have the option to delete your Tweet location history. Learn more

    Your lists

    Create a new list


    Under 100 characters, optional

    Privacy

    Copy link to Tweet

    Embed this Tweet

    Embed this Video

    Add this Tweet to your website by copying the code below. Learn more

    Add this video to your website by copying the code below. Learn more

    Hmm, there was a problem reaching the server.

    By embedding Twitter content in your website or app, you are agreeing to the Twitter Developer Agreement and Developer Policy.

    Preview

    Why you're seeing this ad

    Log in to Twitter

    · Forgot password?
    Don't have an account? Sign up »

    Sign up for Twitter

    Not on Twitter? Sign up, tune into the things you care about, and get updates as they happen.

    Sign up
    Have an account? Log in »

    Two-way (sending and receiving) short codes:

    Country Code For customers of
    United States 40404 (any)
    Canada 21212 (any)
    United Kingdom 86444 Vodafone, Orange, 3, O2
    Brazil 40404 Nextel, TIM
    Haiti 40404 Digicel, Voila
    Ireland 51210 Vodafone, O2
    India 53000 Bharti Airtel, Videocon, Reliance
    Indonesia 89887 AXIS, 3, Telkomsel, Indosat, XL Axiata
    Italy 4880804 Wind
    3424486444 Vodafone
    » See SMS short codes for other countries

    Confirmation

     

    Welcome home!

    This timeline is where you’ll spend most of your time, getting instant updates about what matters to you.

    Tweets not working for you?

    Hover over the profile pic and click the Following button to unfollow any account.

    Say a lot with a little

    When you see a Tweet you love, tap the heart — it lets the person who wrote it know you shared the love.

    Spread the word

    The fastest way to share someone else’s Tweet with your followers is with a Retweet. Tap the icon to send it instantly.

    Join the conversation

    Add your thoughts about any Tweet with a Reply. Find a topic you’re passionate about, and jump right in.

    Learn the latest

    Get instant insight into what people are talking about now.

    Get more of what you love

    Follow more accounts to get instant updates about topics you care about.

    Find what's happening

    See the latest conversations about any topic instantly.

    Never miss a Moment

    Catch up instantly on the best stories happening as they unfold.

    Patrick McKenzie‏ @patio11 24 Jan 2019
    • Report Tweet
    • Report NetzDG Violation

    15+ years into this writing software thing and I just realized the HAVING keyword exists in SQL. Mentioning for benefit of everyone else creating temporary tables for no reason. http://www.postgresqltutorial.com/postgresql-having/ …

    8:14 PM - 24 Jan 2019
    • 11 Retweets
    • 165 Likes
    • Stefan Urquelle SumTrader strangeattractor 🛰️𝗙𝗿𝗮𝗻𝗰𝗲𝘀𝗰𝗼💛𝗝𝗮𝘃𝗮𝗦𝗰𝗿𝗶𝗽𝘁 orasio Ben Garvey Vishal McCloud Général Déso
    10 replies 11 retweets 165 likes
      1. Patrick McKenzie‏ @patio11 24 Jan 2019
        • Report Tweet
        • Report NetzDG Violation

        If software were better at error messages, something might have said, at any point in last 15 years, select customer, sum(orders.amount) as ltv left join orders on orders.customer_id = http://customer.id ) where ltv > 1000 <-- news you can use: you wanted to use HAVING here

        5 replies 6 retweets 59 likes
        Show this thread
        Thanks. Twitter will use this to make your timeline better. Undo
        Undo
      1. New conversation
      2. Kamil Choudhury‏ @kchoudhu 24 Jan 2019
        • Report Tweet
        • Report NetzDG Violation
        Replying to @patio11

        It’s awesome for filtering aggregated data. I remember the first time I found it and just sitting down for a few minutes marveling at new possibilities.

        1 reply 0 retweets 2 likes
      3. Kamil Choudhury‏ @kchoudhu 24 Jan 2019
        • Report Tweet
        • Report NetzDG Violation
        Replying to @kchoudhu @patio11

        In retrospect the two years I spent working for Hell Boss after graduating from college were worth it: dude was an SQL genius and forced me to learn more of it than I would have otherwise been inclined to.

        0 replies 0 retweets 5 likes
      4. End of conversation
      1. New conversation
      2. Jake Morrison‏ @reachfh 24 Jan 2019
        • Report Tweet
        • Report NetzDG Violation
        Replying to @patio11

        To generalize: learn SQL, not just your ORM. There is a lot of power in “thinking in sets”, let the db do the work of filtering and aggregating data. The SQL syntax doesn’t fit into the “class instance per db row” paradigm of ORMs. The key to using an ORM is knowing when to stop.

        1 reply 0 retweets 4 likes
      3. Jake Morrison‏ @reachfh 24 Jan 2019
        • Report Tweet
        • Report NetzDG Violation
        Replying to @reachfh @patio11

        I was once called in to fix a performance problem with a big db. The “nightly report” was taking 14 hours to run. Turns out pulling millions of records across the network and summing them in Ruby can be slow. I rewrote the SQL to do the work in the db, then it took 20 min to run.

        0 replies 0 retweets 4 likes
      4. End of conversation
      1. Sean‏ @seanlinsley 24 Jan 2019
        • Report Tweet
        • Report NetzDG Violation
        Replying to @patio11

        `having`, CTEs, `join lateral`, `filter (where)` window functions... databases have improved a lot in the past decade (Postgres in particular)

        0 replies 0 retweets 9 likes
        Thanks. Twitter will use this to make your timeline better. Undo
        Undo
      1. Aλex‏ @alexkyllo 24 Jan 2019
        • Report Tweet
        • Report NetzDG Violation
        Replying to @patio11

        Did you know that SQL (at least postgres, Oracle and MS) supports recursion and is therefore Turing-complete?

        0 replies 0 retweets 1 like
        Thanks. Twitter will use this to make your timeline better. Undo
        Undo
      1. Greg Phillips‏ @gphil 25 Jan 2019
        • Report Tweet
        • Report NetzDG Violation
        Replying to @patio11

        You don’t even need HAVING to avoid temp tables, you can just filter on a sub-query: http://gphil.net/posts/2012-06-18-is-a-sql-having-clause-necessary.html …

        0 replies 0 retweets 1 like
        Thanks. Twitter will use this to make your timeline better. Undo
        Undo
      1. Froward Jason‏ @JasnTru 24 Jan 2019
        • Report Tweet
        • Report NetzDG Violation
        Replying to @patio11

        I've made some serious performance gains on some complex systems (and some less complex ones) thanks to judicious use of HAVING and common table expressions.

        0 replies 0 retweets 0 likes
        Thanks. Twitter will use this to make your timeline better. Undo
        Undo
      1. Matt Bowker‏ @MattBowker 24 Jan 2019
        • Report Tweet
        • Report NetzDG Violation
        Replying to @patio11

        That one was a game changer for me on the level of discovering cross apply/outer apply and CTEs.

        0 replies 0 retweets 0 likes
        Thanks. Twitter will use this to make your timeline better. Undo
        Undo

    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.

      Promoted Tweet

      false

      • © 2020 Twitter
      • About
      • Help Center
      • Terms
      • Privacy policy
      • Imprint
      • Cookies
      • Ads info