Category:Virtual Tables

Virtual tables allow you to access external data via an ODBC connection (or an OLEDB connection on Windows), 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.

• Virtual tables are an all-in-one combination of a connection, SQL commands and a CursorAdapter object, so the connection and the logic to perform a query is self-contained inside the virtual table definition. This gives a clear separation between the UI presentation layer and the underlying data source.
• Virtual tables are fully updatable with transparent inserts, updates and deletes and they are both SQL and NoSQL compatible.
• All virtual table connections using the same connection string or DSN are pooled to maximize performance.
• Virtual tables allow you to join disparate data sources. For example, you can use virtual tables accessing Microsoft SQL Server alongside native Lianja tables, alongside other virtual tables accessing MySQL and build relationships between the data.