You can use almost any kind of apple for compote, but try to stick to those that are best for baking. Try Granny Smith, Gala, Pink Lady, or Honey Crisp varieties.