Skip to content
  • Home Home Home, current page.
  • Moments Moments Moments, current page.

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
RichFelker's profile
Rich Felker
Rich Felker
Rich Felker
@RichFelker

Tweets

Rich Felker

@RichFelker

Yeah, I do @musllibc, FOSS & infosec stuff. But now is not the time for a mostly-/only-tech Twitter feed.

musl-libc.org
Joined March 2014

Tweets

  • © 2018 Twitter
  • About
  • Help Center
  • Terms
  • Privacy policy
  • 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.

    1. hanno‏ @hanno 3 Nov 2017

      PSA: If you want to fix security with better documentation be aware that it almost certainly won't work.

      1 reply 6 retweets 12 likes
      Show this thread
    2. hanno‏ @hanno 3 Nov 2017

      the reason? people don't read docs. deal with it. yeah, you can say later "it was your fault, read the docs", but you don't fix the problem.

      1 reply 4 retweets 8 likes
      Show this thread
    3. hanno‏ @hanno 3 Nov 2017

      Real fix: build your software so that it's hard to use it in insecure ways.

      4 replies 16 retweets 31 likes
      Show this thread
    4. Rich Felker‏ @RichFelker 3 Nov 2017
      Replying to @hanno

      Concrete example: if your web-app-popular interpreted language has an API for SQL w/o prepared statements (raw strings), REMOVE IT.

      1 reply 1 retweet 4 likes
    5. Zeev Tarantov‏ @ZTarantov 3 Nov 2017
      Replying to @RichFelker @hanno

      prep. stmts were slow with mysql (still true?) and the recommended way to deploy postgresql means disabling them https://pgbouncer.github.io/faq.html 

      1 reply 0 retweets 0 likes
      Rich Felker‏ @RichFelker 3 Nov 2017
      Replying to @ZTarantov @hanno

      This seems like an utterly broken implementation architecture. There's no reason the DB server of proxy ever needs to see prepared stmts.

      9:01 AM - 3 Nov 2017
      1 reply 0 retweets 0 likes
        1. New conversation
        2. Rich Felker‏ @RichFelker 3 Nov 2017
          Replying to @RichFelker @ZTarantov @hanno

          A proper API does them entirely client-side and sends standard SQL (filling in parameters with proper escaping) over the wire.

          1 reply 0 retweets 0 likes
        3. Zeev Tarantov‏ @ZTarantov 3 Nov 2017
          Replying to @RichFelker @hanno

          Ah, you mean client-side escaping, not server-side prepared statements that save server resources (parsing, permissions, query planning).

          1 reply 0 retweets 0 likes
        4. Rich Felker‏ @RichFelker 3 Nov 2017
          Replying to @ZTarantov @hanno

          I don't really care how it's implemented under the hood. Important part is that the app never be allowed to write queries as strings.

          1 reply 0 retweets 0 likes
        5. Rich Felker‏ @RichFelker 3 Nov 2017
          Replying to @RichFelker @ZTarantov @hanno

          Server-side prepared statements are an optimization choice (maybe a tradeoff) whereas how API looks to the app is a matter of secure design.

          1 reply 0 retweets 0 likes
        6. Zeev Tarantov‏ @ZTarantov 3 Nov 2017
          Replying to @RichFelker @hanno

          Do you propose, e.g., that the custom SQL API check that the SQL string does not contain value literals, only table/column/function names?

          1 reply 0 retweets 0 likes
        7. Rich Felker‏ @RichFelker 3 Nov 2017
          Replying to @ZTarantov @hanno

          I propose APIs that do not accept value literals anywhere in the query string, only as parameters.

          1 reply 0 retweets 0 likes
        8. Zeev Tarantov‏ @ZTarantov 3 Nov 2017
          Replying to @RichFelker @hanno

          So e.g. in https://docs.djangoproject.com/en/1.11/topics/db/sql/#executing-custom-sql-directly … the "foo = 1" would raise exception, you have to pass the 1 in the args? I agree, that is a good idea.

          1 reply 0 retweets 0 likes
        9. Zeev Tarantov‏ @ZTarantov 3 Nov 2017
          Replying to @ZTarantov @RichFelker @hanno

          keep set of hashes of checked SQL strings, to not parse same string again, the parsing only happens once per custom SQL string per process.

          0 replies 0 retweets 0 likes
        10. End of conversation

      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

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