I know that this has been discussed several times before and that "PDO (PHP Database Object) works with multiple databases", "PDO supports dynamically generated prepared statements" (meaning that it can bind parameters from an unknown amount of parameters, which MySQLi can do with a bit of trixing). But I've never found an answer on if PDO is the new and upcoming database access method which is gonna kick all other methods or not. Will it? Is it a new technology or has it existed for decades? Should I be migrating to PDO? Does all web hosting services support this? Is one more secure than the other? Is it hard to find support for PDO problems I face?
Please respond and don't just say google it because I have. I only find non definite answers and if I could get these questions answered I would feel much more confident in migrating (or not).