Startup Engineers and Our Mistakes with MongoDB(nemil.com)

  move: {
    shipper: string,
    consignee: string,
    stops: [{
      address: string,
      appt: datetime,
    }] 
  }

  driver: {
    name: string,
    id: string,
    moves: [{
      shipper: string,
      consignee: string,
      stops: [{
        address: string,
        appt: datetime,
    }]
  }

  terminal: {
    city: string,
    drivers: [{
      name: string,
      id: string,
      truck: [{
        plate: string,
        moves: [{
          shipper: string,
          consignee: string,
          stops: [{
            address: string,
            appt: datetime,
          }]
        }]
      }]
    }]
  }

  terminal: {
    city: string,
    vendor: [{ // many-to-many! duplicate vendor data?
      id: string,
      drivers: [{
        name: string,
        id: string,
        truck: [{ // many-to-many! duplicate truck data?
          plate: string,
          moves: [{
            shipper: string,
            consignee: string,
            stops: [{
              address: string,
              appt: datetime,
            }]
          }]
        }]
      }]
    }]
  }

  create custom type LatLon(...)
  create table Person(id as int, name as string, location as LatLon)
  create table Shop(id as int, name as string, location as LatLon)

  Find everyone 10k around Macy's:
  select p.* from Person p inner join Shop s where s.name="Macy's" and with_distance(p.location, s.location, 10km)