Cameron
@cameron_p_m
Followers
215
Following
202
Media
11
Statuses
159
databases @Shopify co-organizer https://t.co/681VacywK5
Vancouver, British Columbia
Joined June 2010
They reject me from the lounge I was just scanned into with “sorry business class only”. Surely he’s not lying. But why does he not know the only information he has to know? He looks up my name “oh yea you were here, come on in”. He just accepts I have broken his system 🤷♂️.
0
0
0
Love a perfect inperfect system. Pilot says flight is delayed for because it failed critical maintenance, we get off. Notification comes in that official reason is “weather”, but it’s 25 and sunny. Maybe so they don’t have to pay? We need an airline version of @patio11.
1
0
1
It’s insane working with o3 and o3-pro and just never being blocked on anything. Not just coding but anything in life. Fucking insane.
0
0
2
The interview cheat discourse is funny to me. At Shopify interviewees can use LLMs. It’s a skill you need. What’s crazy is my LLM skills have gotten so much better over the last year that my quality bar for “uses LLMs well” is so much higher than a year ago.
1
0
3
At least 50 devs live here!.
Can't believe that @cameron_p_m and I announced yesterday at 5pm and it's already 50 out of 50 spots taken
0
0
3
1
4
17
Nothing more satisfying than it taking weeks to go up 5lbs in a lift. Incredible.
0
0
1
RT @eliias: A LLM is to classic ML what a CPU is to an FPGA. Yes, your classification model is way faster and cheaper to run, but nobody ca….
0
1
0
This guy is incredible.
Want 24k words about which bodegas are enemies of the state, how the performance of the American professional-managerial class leads to moral manias, and why banks write 4 million interoffice memos a year in the expectation they will never be read, see:.
0
0
2
When your sharded database does ~50M QPS and you are “others”.
How do huge orgs like Uber, Slack, Cash App, and others scale their databases?. Sharding!. I'm working on an interactive article for @PlanetScale covering what sharding is and considerations for designing a well-performing database cluster. Stay tuned.
3
1
68
I started doing some higher level interviews at work, and I kind of expected to hate them, but I love exploring the edges of peoples knowledge. They all react so differently to this. Discussing hard problems is also so fun.
0
0
1
DSQL is really cool. Maybe if you need the scaling and have to pay for a distributed database (which is much more expensive), you shouldn’t be doing most of these anti patterns 🤷♂️.
"Postgres compatible" . - No views/triggers/sequences. - No foreign key constraints. - No extensions. - No NOTIFY ("ERROR: Function pg_notify not supported"). - No nested transactions. - No JSONB. What, what IS it compatible with?
0
0
2
~20M peak last BFCM to ~45M peak. Incredible. And to think I just presented the 20M numbers 🤥.
🐬 Shopify's world-class database fleet, powered by MySQL 8, processed an incredible 45 million queries per second and more than 1.4 billion row operations per second at peak. That’s commerce at a truly planetary scale 🌐.
1
0
5
The first with @morgallant and @kirshatrov as speakers is shaping up well. Excited for tonight! . We got near 80 sign ups and our space wasn’t big enough, hopefully fix that up next time. Awesome to see the interest though 🏔️.
0
2
8
After 10am, you have to use medimap to find walkin clinics that still have slots due to the variance in random traffic. In afternoon, you probably wait until next morning.
1
0
0