close
Wayback Machine
1 capture
10 May 2020
Apr MAY Jun
10
2019 2020 2021
success
fail
About this capture
TIMESTAMPS
loading
The Wayback Machine - https://web.archive.org/web/20200510012221/https://twitter.com/simonw/status/1257500689019703296
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
    BERJAYA Verified accountProtected Tweets @
Suggested users
  • BERJAYA Verified accountProtected Tweets @
  • BERJAYA 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
simonw's profile
BERJAYA
Simon Willison
Simon Willison
Simon Willison
Verified account
@simonw

Tweets

Simon WillisonVerified account

@simonw

Creator of Datasette, co-creator Django. Fellow at @JSKstanford. Collector of @nichemuseums. Usually hanging out with @natbat and @cleopaws. He/Him

San Francisco, CA
simonwillison.net
Joined November 2006

Tweets

  • © 2020 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
    BERJAYA Verified accountProtected Tweets @
Suggested users
  • BERJAYA Verified accountProtected Tweets @
  • BERJAYA 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.

    BERJAYA Simon Willison‏Verified account @simonw May 4

    I have a SQLite table full of UUIDs that appear to have been split into two integers, uuid_0 and uuid_1 Any guesses how I can convert those into a regular 123e4567-e89b-12d3-a456-4266141740000 style UUID? Data looks like this:pic.twitter.com/BIYXnlMi6T

    BERJAYA
    7:41 PM - 4 May 2020
    • 8 Likes
    • evrone.com Sibelius Seraphini Issac Kelly Testestear Dan Nguyen Angel Cruijff Leon Bambrick
    2 replies 0 retweets 8 likes
      1. New conversation
      2. BERJAYA Simon Willison‏Verified account @simonw May 4

        I'm reasonably confident that these map to a table in another database with UUIDs that look like this - mainly because the two tables have the same nuber of rows in them (40,424) - which is the number of photos I have in Apple Photospic.twitter.com/Y4p8cbnBxI

        BERJAYA
        2 replies 0 retweets 0 likes
        Show this thread
      3. BERJAYA Simon Willison‏Verified account @simonw May 4

        The challenge is how to map one set of IDs to the other

        2 replies 0 retweets 0 likes
        Show this thread
      4. BERJAYA Simon Willison‏Verified account @simonw May 4

        I posted detailed background in this issue thread:https://github.com/dogsheep/photos-to-sqlite/issues/16 …

        1 reply 0 retweets 3 likes
        Show this thread
      5. BERJAYA Simon Willison‏Verified account @simonw May 4

        Figured out how to convert two long integers like that into a UUID using Java - not sure if this is the right solution though, they don't seem to match. Also not sure how to do the same thing in Python! https://repl.it/repls/EuphoricSomberClasslibrary …pic.twitter.com/FlcyJDgPni

        BERJAYA
        3 replies 0 retweets 0 likes
        Show this thread
      6. BERJAYA Simon Willison‏Verified account @simonw May 4

        Simon Willison Retweeted pkqk

        I think @pkqk got it - this appears to be generating UUIDs that match rows in my other tablehttps://twitter.com/pkqk/status/1257512449575497729 …

        Simon Willison added,

        BERJAYA
        pkqk @pkqk
        Replying to @simonw
        is this any help? I'm just guessing as to how it could be constructed, might want to swap the endianness pic.twitter.com/4rebgbaZQ2
        1 reply 0 retweets 2 likes
        Show this thread
      7. BERJAYA Simon Willison‏Verified account @simonw May 4

        Hmm... something's not quite right about this query that's supposed to match machine learning labels up to photos...pic.twitter.com/bCNqAH6h6Z

        BERJAYA
        3 replies 0 retweets 5 likes
        Show this thread
      8. BERJAYA Simon Willison‏Verified account @simonw May 4

        Figured it out! I now have the Apple Photos machine learning classified labels in a form that I can build things on https://github.com/dogsheep/photos-to-sqlite/issues/16#issuecomment-623863902 …pic.twitter.com/eTHON9wtqW

        BERJAYA
        1 reply 1 retweet 14 likes
        Show this thread
      9. End of conversation
      1. BERJAYA Bartek Ogryczak‏ @var_tec May 4
        Replying to @simonw

        UUID4 is just an 128-bit integer, so I suppose uuid_1<<64+uuid_0 or other way around.

        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
      • Cookies
      • Ads info