CinderToriella it lasts in the fridge just as long as a normal store bought sparkling drink. Soda stream have one litre and 500ml bottles available.

We have a cheapie, works perfectly fine.