HNHacker News
TopNewBestAskShowJobs

mscccc

238 karma · joined June 1, 2018

submissionscomments
mscccc··on Cloudflare and PlanetScale launch integration
I'm one of the engineers on the project, it was great working with the Cloudflare team. Here to answer any questions if you have them.
mscccc··on School lunch breaks in France can be two hours (2012)
Hey, I'm just trying to help here. I don't think anyone wants to be feeling comatose after a meal. Reduce the sugar and you'll feel good!
mscccc··on School lunch breaks in France can be two hours (2012)
> Postprandial somnolence, commonly known as “food coma”, is a normal state of drowsiness or lethargy following a meal. It occurs when you consume foods with a high glycaemic index (GI) - https://www.healthhub.sg/live-healthy/your-medical-questions...

"Food coma" is from carbs/sugar. :)

Edit: to satisfy my friendly HN editors. :)

mscccc··on How does Sidekiq really work?
We chose Rails + Sidekiq for building PlanetScale's REST API + background workers. Project started 3 years ago. We are still very happy with the decision and wouldn't change it.

> Why?

To build fast. Our team knew Ruby well. Many of us worked at GitHub and trusted we could solve the problems ahead of us with it.

> Do you have trouble hiring?

No issues at all.

mscccc··on Pegasus Mail
I love how the homepage loads in 24ms. Now this is the ideal website.
mscccc··on D1: Improvements to performance and scalability
I've been using workers on & off since it launched. Just tried it again recently and the local dev experience with wrangler is excellent now.
mscccc··on Show HN: A 15 min daily stretch routine for desk workers
The author is Kelly Starrett, a legend in the physical therapy/movement world. I've read a lot of his work.

I don't think his message is that stretching "does nothing". It's more that, research has shown that combining stretching with strength (using the range of motion) is the way to create lasting change.

mscccc··on Building GitHub with Ruby on Rails
Yes that’s correct.

I was saying it came after, meaning GitHub could not have used it since it didn’t exist. :)

mscccc··on How does database sharding work?
Hey, I work for PlanetScale.

Definitely not normal. It’s hard to know why you’re seeing slow queries without more information.

The most common causes are either: missing indexes or network latency between the app and database (are they in the same region?).

We don’t have cold starts, but it is possible for queries to get faster once data is moved into memory. 3-4s is very slow though, I suspect it’s doing a full table scan and an index will solve it.

If you check Insights you can get more info, would also help to run an explain on the query (https://planetscale.com/courses/mysql-for-developers/queries...) to see what’s happening.

Also, if you email support, they’ll help debug it for you. Hope that helps!

mscccc··on Building GitHub with Ruby on Rails
Even with my kindest interpretation, I cannot find how this comment adds anything to the conversation. It’s also incorrect. Hotwire was released after GitHub’s internal UI framework (which is quite impressive!) was created.

Attributing some UI bugs with their choice of framework is a massive oversimplification of the problem.

mscccc··on Google releases Bard to a limited number of users in the US and UK
To sign up with a different google account, you can use this: https://bard.google.com/u/1/ (increment number until you get the account you want)
mscccc··on Ask HN: Real-world anecdotes of MySQL at scale?
This is a good one from GitHub: https://github.blog/2021-09-27-partitioning-githubs-relation...
mscccc··on Why We’re Sticking with Ruby on Rails at Gitlab
GitHub uses minitest, but same situation.

I don't exactly agree that it's a design problem. I think there is a lot of value in testing at a high level (controller tests) and having them touch the full stack (down to the DB). Gives a lot of confidence that the code will work in production. Throwing money at it (running the tests in parallel) pretty much solves it.

I have seen FactoryBot use get out of control (creating 8x as many records as you'd expect). That's a really easy way to slow down a test suite :). One way I've found to fix that is by adding tests for the factories, and asserting they are only creating what you want them to.

On model tests, another thing GitHub did well was encourage using `.build` when possible to avoid writing the the DB.

mscccc··on Why We’re Sticking with Ruby on Rails at Gitlab
I worked on GitHub's Rails app. The main way this was solved was by running tests in parallel. It's now available in default Rails: https://edgeguides.rubyonrails.org/testing.html#parallel-tes...

In addition to that, the test suite performance was regularly monitored. And like any performance issue, we'd instrument and then fix issues as they came up.

mscccc··on Publish NPM Package with GitHub Actions
> With the exception of GITHUB_TOKEN, secrets are not passed to the runner when a workflow is triggered from a forked repository.

https://help.github.com/en/actions/automating-your-workflow-...

mscccc··on Ask HN: Who is hiring? (June 2018)
GitHub | Full Time | Software Engineer | REMOTE or San Francisco | https://github.com/marketplace

GitHub is changing the way the world creates software and we want you to help us craft the best way to build a software workflow: GitHub Marketplace. We’re looking for a talented Engineer to help make our Marketplace be the ideal place to find and sell the best tools development workflows.

You’ll work with our team of Ecosystem engineers, designers, and product managers to craft a cohesive experience for both our customers' integrators. The Ecosystem organization works together to ensure every part of our Platform is low friction and provides a high amount of value. Become part of the future of software development by joining our Marketplace team.

Details:

SF: https://boards.greenhouse.io/github/jobs/1152666

Remote US: https://boards.greenhouse.io/github/jobs/1152669

Remote Global: https://boards.greenhouse.io/github/jobs/1152619

Keywords: Ruby/Rails, JavaScript, GraphQL