Or "Puppies for dummies" 
We are planning to get a puppy in about six months' time and I am starting to get excited about it. I haven't had dogs before, ever, (DH has) and it's all a bit new to me. In fact if anything I am a little bit anxious about dogs because I don't really understand them at all, but DH is confident and I do agree with his idea that having one from a puppy will be fine because I can get to know it while it's still cute and harmless.
I don't know anything at all about dog behaviour so have been looking up things on positive training as I keep seeing it mentioned on here, watching videos on youtube etc, I had started to feel a bit more confident, although they do all seem to assume a level of familiarity with dogs which I don't have. Then suddenly came across the casual mention that puppies don't sleep through the night!
Please forgive me for being so clueless - I am used to cats, who are usually completely litter trained by the time you get them, so it hadn't really occurred to me at all. I tried googling some stuff but then got a bit bamboozled about it all and don't want to accidentally end up getting drawn into something which is cruel or not recommended any more.
We are planning to crate train, do you think it's best to have the crate in our bedroom or in a living room? DH is planning to put it in the living room, is that right or does it not really matter?
Puppy will be three months old when it (she) comes to live with us. I know we will still have work to do with toilet training, but how much at night? How long can we expect her to sleep for (I don't mind getting up, I feel I should add, I just don't know what is normal or what to expect and I don't want to get frustrated because it takes longer than I thought.) and how long does it go on for? Is there anything in the "Puppy sleep training" stuff you find on the web (mainly about routine and keeping night time toilet trips very low key and boring) or is it total nonsense/cruel?
DH mentioned that when crate training obviously you get the dog used to being in the crate in the house with no pressure when you're there but when you first start to leave the room the puppy might cry a bit and that it's OK and we shouldn't rush back in. I understand the reasoning behind this - is it the same at night? I think I could stand it for a few minutes knowing that they are learning we are going to come back and nothing bad will happen but I'm not sure at night time. Come to think of it, the dog won't be completely crate trained in one day! So how does the whole first night/first few nights work?
So I have six months to really get my head around how much work it's going to be - more than I thought, I think. Can you tell me honestly what the worst bits are, so I can be prepared for it? I am slightly worried that I've jumped in a bit with the nice fluffy cute part of it and that I'm going to end up thinking why on earth did I agree to this?? Or perhaps it's best to just go for it without the horror stories and take the bad with the good and it's a bit of a rite of passage sort of thing. Gah! I don't know!! Am I overthinking? Is it best to just do it? Tell me your best tips/what you wish you had known!