System design : google spreadsheet

Apple 🍯moon
Jun 12 18 Comments

Can anyone guide me and share some resources for designing collaborative spreadsheets ?

TIA

comments

Want to comment? LOG IN or SIGN UP
TOP 18 Comments
  • Yahoo / Design getAway
    Why should we help you cheat?
    Jun 12 7
    • Apple 🍯moon
      OP
      What are u smoking? Learning is not cheating!!
      Jun 12
    • Yahoo / Design getAway
      If you cannot answer a simple design question like that, you should really not be applying to senior roles. Learn to serve time as a junior.
      Jun 12
    • Apple 🍯moon
      OP
      You rockstar ppl killed yahoo. Stay there please. Be respectful to others.
      Jun 12
    • Amazon amaholic
      Clearly Yahoo is a newbie... he got no idea how complex the collaborative doc design/implementation be.
      Jun 12
    • Microsoft defcon19
      That moment when a designer mistakes a system design concurrency question for a visual "design" question...
      Jun 12
    • Amazon wo3xqp0s1k
      Yeah like you never cheat with stackoverflow or googling the shit out.
      Jun 12
    • Yahoo / Design getAway
      Clearly
      Jun 12
  • Microsoft / Eng mantier
    The keyword is Operational Transformation
    Jun 12 4
    • Google 🎄fiddy
      No it's not....lol
      Jun 12
    • Microsoft / Eng mantier
      Why not? Genuine ques
      Jun 12
    • Google 🎄fiddy
      Simply put, OT is an algorithm for more nuanced conflict resolution and Google sheets does not need that much nuance. You can simply take the approach where you synchronize individual cells with a last write wins policy. Text editing is harder because the unit of synchronization is the entire document.
      Jun 12
    • Microsoft / Eng mantier
      Thanks. Something interesting to read more
      Jun 12
  • Google 🎄fiddy
    Think of it as a 2D array with concurrent read/write. Write policy can be last write wins with no real issues. Much simpler than Google Docs. Think about the APIs that represent mutations and how client will process them and know the ordering. You typically need a revision + revision of previous mutation to know if the incoming mutation is in order.
    Jun 12 1
    • Cadence / Product
      luna.

      Cadence Product

      BIO
      .
      luna.more
      This
      Jun 12
  • Apple letzchat
    After all the drama no answer to that guy 😀 That’s how hilarious real world is. So moon get help from your co workers or friends or forums on internet don’t expect on blind unless someone messaged you
    Jun 12 0
  • New Glutton
    It’s like any standard SD question plus concurrency handling among multiple readers/writers
    Jun 12 0

Join verified employees in our anonymous social network! Download the app!

close