Hi Alec.
All of those prices are monthly, so yes it is $5/GB/month for the Realtime Database. That's stated
on this page but your email is good feedback that our pricing is not clear enough in table form. While it's true that RTDB is a relatively expensive place to store data (especially when compared to higher latency products), it's also possible you're over-estimating data storage needs.
In your example of chat data, 1GB is a huge amount! I'm not sure how much metadata is stored with a chat in Facebook's format, so that could be most of it. Let's do some napkin math (all relevant napkin math disclaimers apply). A page of a normal book is about ~300 words. Each word is ~5 letters and a space, so 6 bytes if it's ASCII. This means 1800 bytes per page. So in 1GB of text with no metadata, you could have ~560,000 novel-length pages of text! That's an enormous amount to type in a chat window.
As you said, it could be a good idea to move "cold" data to somewhere less expensive over time if your application is really huge. In that case you'd only keep data in RTDB that benefits from the low-latency sync capabilities of that product.
- Sam