Reading over this again, I realized that I did a piss poor job of explaining what I was getting at
Jason, you’re 100% right -- we still need mod_rewrite, or some Apache directive to send every request to a single resource no matter what. From there, we do an internal lookup if that resource exists in the DB and send back a 200 or a 404 status and render the proper page (or an error). It’s not horribly different from he way do it now, except that it’ll be a little smoother with an internal dispatcher rather than everything being redirected to index.php (which is how we manage it now).
Hopefully that makes more sense