SQLite
Linx enables you to connect to an existing database and perform various data operations. The SQLite Plugin provides direct connectivity to a SQLite database without requiring an ODBC driver or separate runtime installation — the native SQLite library ships with the plugin.
SQLite is a file-based database engine. Unlike client-server databases, it reads and writes directly to a file on disk (or to an in-memory database), making it ideal for embedded applications, local data storage, and lightweight workflows that do not require a dedicated database server.
To run a simple SQL query, add the ExecuteSQL function to your solution and use the SQL Editor.
Functions available for use with SQLite databases:
BeginTransaction: Start a transaction to execute multiple database operations within the same transaction.
BulkImport: Efficiently copy large volumes of rows into a table.
ExecuteSQL: Execute an SQL query and return relevant data. The query can include any SQL commands supported by the database driver.
Links
Last updated