new AsyncSQLAdapter and some bug fixes