How can I get dynamic routes

One idea which I have at the moment is: using code as below in /Config/Routes.php file:

PHP Code:

$db = \Config\Database::connect();
$paths = $db->table('paths')->get()->getResult();

foreach ($paths as $path)
{
    $routes->get($path->path, ucfirst($path->controller).'Controller::show/'.$path->path);
} 


I know that isn't a perfect solution but only one at the moment. Maybe someone has a better idea for this. I could also generate a file with generated all available paths and include in Routes.php (for better performance than reading all-time)