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.
  • 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
sgrif's profile
Miss Dada 🏳️‍⚧️
Miss Dada 🏳️‍⚧️
Miss Dada  🏳️‍⚧️
@sgrif

Tweets

Miss Dada  🏳️‍⚧️

@sgrif

Co lead of the http://crates.io  team. Creator of @dieselframework. Former host of @_bikeshed and @_yakshave. Former Rails comitter. Enby. they/them

Albuquerque, NM
patreon.com/seantheprogram…
Joined November 2008

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.

    1. Miss Dada  🏳️‍⚧️‏ @sgrif Feb 19
      • Report Tweet
      • Report NetzDG Violation

      Back on my "essays as commit messages" shithttps://github.com/rust-lang/crates.io/pull/2203 …

      3 replies 0 retweets 18 likes
      Show this thread
    2. kornel@mastodon.social‏ @kornelski Feb 19
      • Report Tweet
      • Report NetzDG Violation
      Replying to @sgrif

      For http://lib.rs  I had to give up on using a database for downloads. Now I use an in-memory equivalent of HashMap<version_id, Gzip<[u32; 366]>> for processing the download counts.

      1 reply 0 retweets 0 likes
    3. Miss Dada  🏳️‍⚧️‏ @sgrif Feb 19
      • Report Tweet
      • Report NetzDG Violation
      Replying to @kornelski

      We're scaled across multiple servers, so no in memory

      2 replies 0 retweets 0 likes
    4. Miss Dada  🏳️‍⚧️‏ @sgrif Feb 19
      • Report Tweet
      • Report NetzDG Violation
      Replying to @sgrif @kornelski

      What do download counts even mean for http://lib.rs ? I didn't think you served crates directly?

      2 replies 0 retweets 0 likes
    5. Justin Geibel  🏳️‍🌈‏ @jtgeibel Feb 19
      • Report Tweet
      • Report NetzDG Violation
      Replying to @sgrif @kornelski

      Based on the 366, I'm guessing it's an in memory cache of 1 year of (upstream) daily download counts. As you said, since we have multiple servers updating the counts we can't cache much in process (plus Heroku can terminate us before we can write data out).

      1 reply 0 retweets 0 likes
    6. kornel@mastodon.social‏ @kornelski Feb 20
      • Report Tweet
      • Report NetzDG Violation
      Replying to @jtgeibel @sgrif

      That's tough. But maybe you could use a more compact format in the db? Daily (version_id, date) adds ~200K identical dates every day. It could be (version_id, week_number) with a downloads[7] column, for example.

      1 reply 0 retweets 0 likes
    7. Miss Dada  🏳️‍⚧️‏ @sgrif Feb 20
      • Report Tweet
      • Report NetzDG Violation
      Replying to @kornelski @jtgeibel

      If we had a problem we were trying to solve, sure. But all our time sensitive queries are on version id and date, the current structure is perfect for that

      1 reply 0 retweets 0 likes
    8. kornel@mastodon.social‏ @kornelski Feb 20
      • Report Tweet
      • Report NetzDG Violation
      Replying to @sgrif @jtgeibel

      I've meant that as a way to reduce data size, given that the sheer volume of the data is causing you pains. Normalized table has 4-byte counters with ~50 bytes of overhead each. Merging them to be one row per version per week (or longer) should considerably reduce table size.

      1 reply 0 retweets 0 likes
      Miss Dada  🏳️‍⚧️‏ @sgrif Feb 20
      • Report Tweet
      • Report NetzDG Violation
      Replying to @kornelski @jtgeibel

      The volume of data isn't, so much as how it's being accessed/laid out. Compressing rows would only delay the problem, and would likely slow down access patterns that are actually important to be fast. Only painful place right now is background jobs

      8:23 AM - 20 Feb 2020
      1 reply 0 retweets 0 likes
        1. Miss Dada  🏳️‍⚧️‏ @sgrif Feb 20
          • Report Tweet
          • Report NetzDG Violation
          Replying to @sgrif @kornelski @jtgeibel

          The tuple overhead here wouldn't really be reduced. Every write produces a new tuple no matter what. The number of writes are the same. Duplicate date also isn't really reduced here since the overhead of an array element is the same as a date.

          0 replies 0 retweets 1 like
          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