DbFace warehouse feature provides a way to do cross database reporting applications, even your database located at different hosts.

Warehouse Database Settings#

DbFace stores all warehouse data in local SQLite3 database (the file will be created in dbface user directory). You can also configure it to existing remote MySQL database to gain better performance.

Click the gear icon button at the top right corner of Warehouse page, Change Warehouse settings

At the popup dialog, change the hosting to Remote MySQL Change Warehouse to MySQL

Warehouse API#