What Databases are compatible with App Studio

I read that nsbasic connects to sqllite as its database. Does it
also connect to PostgreSQL

SQLite runs within the browser, so it is available locally wherever you are running AppStudio.

PostgreSQL does not run on mobile devices. To connect to it, you’ll need to use AJAX:
http://wiki.nsbasic.com/Ajax_made_Simple#Using_AJAX_to_get_info_from_a_database_on_your_server.

If you are making a web app to run in any browser consider using local storage or a third party javascript add-in. IE, Edge and Firefox do not support SQLlite. No problem tho, if you compile with phonegap.