# 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](/reference/plugins/database/shared-properties/sql-editor.md).

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

* [SQLite License](/reference/plugins/sqlite/license.md)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.linx.software/reference/plugins/sqlite.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.