Data Connectivity
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.