As to the original product link, I'm guessing that pumping a cylinder up to 3000psi with a hand pump -- even a very small cylinder -- is going to be a LOT of work! Like, maybe two hours of pumping in order to get two minutes of breathing time? I don't know. I spent some time searching and could not find a single review, by an independent reviewer, that mentioned how long it took to pump the thing up. Of course, the sellers all say that it is easy to pump up, and doesn't take long, but I have my doubts.
As to hookah, you are still breathing compressed air underwater. That means that you can still kill yourself -- yes, I mean really dead -- if you don't know what you are doing. So getting some dive training before using a hookah system is the prudent thing to do.