Data Connectivity

From Lianjapedia
Jump to: navigation, search

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 using Virtual Tables.

About Data Binding

Form, Canvas and Grid sections are typically bound to a table in a database. The table specified can be a native Lianja table or a “Virtual Table”.

Each formitem (Field or Gadget) can be bound to a table.column in the “Data source” attribute.

Typically the database, table and “Data source” are set automatically when you drag a table or column onto the page.

As you navigate between data the “Data source” is automatically updated in the UI.

As you edit data the “Data source” is automatically updated in the database. There is no coding required to accomplish display and editing of fields or gadgets.

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.