Why PDO driver doesn't allow list tables and columns about database HOT 4 OPEN

Because PDO is not just MySQL: http://stackoverflow.com/questions/769683/show-tables-in-postgresql#769706

from database.

Hmm, ok. Fair enough, but the database configuration states if it is MySQL or not. Can't we actually implement different queries based on the database specified in the DSN?

from database.

@hkdobrev in principle I don't see why not, I think that could be useful. But it would need to be done in a clean, sensible way (potentially with some sort of sql abstraction class for each supported backend) and well-tested.

If you want to try it, then go ahead - I'd merge it as a new feature (for the 3.4 branch) if the implementation is OK. If not, then it's a nice idea but I can't promise anyone will have time or inclination to work on it.

Personally, I'd just add this at the application level if required, or use an existing more fully-featured DB abstraction package like Doctrine.

from database.

There was a discussion about this in the old forums:

http://forum.kohanaframework.org/discussion/11921/best-way-to-save-a-11-relationship-using-the-kohana-orm

from database.