You can get the names of all the databases that you can connect to from the “pg_datbase” system table. Just apply the sql as below.
select pg.datname AS db_name, pg_size_pretty(pg_database_size(pg.datname)) as db_size
from pg_database pg
order by pg_database_size(pg.datname) desc;
If you intend the output to be consumed by a machine instead of a human, you can remove the pg_size_pretty() function.
This way the user may experience slowdown during the initial page load, but each next time she opens the application her experience will be instant!
Now we should install/update CLI for Cordova and Ionic, to have an opportunity to create new apps, add cordova plugins, etc.
user can browse through the filesystem and pick a file to play. The initial request was to play both Audio and Video files inline. But I was only able to get the Audio files to play inline where as the Video will be launched in the device default video player.