Route using database information

[eluser]Colin Williams[/eluser]
If you trace through CI bootstrapping, you quickly realize that there's no way to access the DB in the Router class. Well, you can, but you inevitably end up with two database connections. The only way around it is to rewrite the bootstrapping process so that the database libraries are available right away (and this involves changing a lot of processes down the line, like, you would have to redo how the db class gets referenced to the CI object so your can do $this->db still).

It's not impossible, but you can't do it without significantly changing core, or living with two DB connections per request.

What I've done is have the config/routes.php file dynamically written to based on values in the database. This seems to work best without modifying CI extensively.