Data Connectivity

Under construction

Lianja has its own high performance database engine built-in. Unless absolutely necessary we recommend you use that database engine.

It also provides full support for working with MSSQL, MySQL, PostgreSQL and other SQL databases.

Virtual Tables

Virtual tables allow you to access external data via an ODBC connection, yet they look like regular tables in a Lianja database. You can drag 'n' drop virtual tables in the Page Builder and reference them in the same way as standard tables and all the time the underlying connection, SQL statements and cursor adapter are being handled for you.

Full documentation on Virtual Tables can be found here.

ODBC Functions

Visual FoxPro compatible remote data connectivity functions are used to handle connections to ODBC sources.

Full documentation for these ODBC functions can be found here.

Web Integration

You can work directly with remote Web APIs and integrate this data into your Apps.

Full documentation on Web Integration can be found here.