HN user

chrisconroy

38 karma

Software Engineer at Square Atlanta, GA

Posts0
Comments14
View on HN
No posts found.
SQL Keys in Depth 9 years ago

Gotcha. Thanks for the clarification!

Yes, even if you're using normal insert statements, it's good to limit the size of any one transaction to the extent you can for a host of reasons!

SQL Keys in Depth 9 years ago

auto_increment doesn't lock the table. When you use an auto_increment column, MySQL will grab the next int as it creates the insert write-ahead log message. Two concurrent transactions with T1 beginning first and T2 beginning second but actually committing out of order can thus have out of order ids. e.g. T2(id=10) T1(id=9)

Also, note that this means auto_increment IDs are not continuous (read: a reader looking after T2 commits but before T1 will see a gap, and if T1 fails that gap is permanent!)

We adopted it in the SpeedTracer chrome plugin a while back. We were very happy with the results then. Though, for the stuff I've been working with lately most JSON APIs are defined by protos, and we just bridge with JsonFormat/ProtoTypeAdapter

Atlanta, GA | Square | https://squareup.com/careers

Our Atlanta, GA engineering office is in Atlantic Station, and we're hiring for iOS, Android, go, java, and ruby developers. We have a great team here with a lot of Xooglers, and we work on everything from the Square Register app to the highest SLA systems inside of Square.

We've started hosting monthly tech talk meetups. Even if you aren't looking for a job, please come by if you're in the area and want to nerd out with us: http://www.meetup.com/Square-Atlanta-Tech-Talks/

You must have dealt with a completely different company and product. The public github is a lot better than the enterprise version at least in terms of stability. Still, both lack a lot of basic issue tracker and code review features.

Github enterprise was a disaster with just a couple hundred users.

Under the load of just a few hundred users it died almost every day. Their support team couldn't figure it out. We had to reboot the servers constantly.

We begged them to add an option to reject force push to master. They refused. We ended up monkey patching their obscured source to add the feature, but it broke on upgrades and was hard to maintain. This is something probably every single customer of theirs wants, and it should take one engineer less than a day to implement.

They only just added side by side diff support. IMHO this is a basic, core feature for any kind of code review workflow. I'm holding my breath for proper syntax highlighting while in diff view.

We've since moved on to Atlassian Stash. While it isn't perfect, it's a dream compared to Github enterprise and a lot less $$$ to boot.

Square - Atlanta, GA - https://squareup.com/ - Full-time and internships

Square Atlanta is also looking to hire engineers. Please, only local applicants or those serious about relocating to Atlanta. Our office is located in Midtown in Atlantic Station.

We are currently hiring for two engineering teams in Atlanta:

The Production Experience team is responsible for making our production environment beautiful. This involves production monitoring, automation, deployment tools, and the like to keep our apps reliable and our product engineers productive.

The Shared Systems team builds common service infrastructure for applications at Square. We care deeply about the performance and reliability of our infrastructure, and we strive to improve the velocity of other teams. We own common components like our Java service container and our RPC stack. Additionally, we own common services like user authentication and application traffic routing.

If you're interested, get in touch with your resume: cconroy@squareup.com

Square - http://www.squareup.com - Atlanta, GA (Fulltime and Internships)

Though Square's headquarters are in San Francisco, we also have a small but growing engineering office in Atlanta, GA. Our office is in Midtown (Atlantic Station), and we have a great team working on projects with a very big impact.

We're currently looking to hire for two teams:

  - Production Experience (ruby, monitoring, automation, making deployment better)

  - Payments / Infrastructure (java, high availability, low latency)
We're also hosting an open house for engineers in the Atlanta Area on Jul 25. Early registration recommended: https://guestlistapp.com/events/170175

Reach out to me (cconroy@squareup.com) directly if you are interested.