---
title: "SQL.SQLite3"
description: "SQLite3 connection prototype."
canonical_url: "https://www.zeyos.com/zymba/ref/sql/sql-sqlite3"
markdown_url: "https://www.zeyos.com/ai/guide/zymba/ref/sql/sql-sqlite3.md"
section: "zymba-reference"
authority: "reference"
language: "en"
source_repository: "https://cloud.zeyos.com/__doc/zymbaref.json"
source_sha256: "05a361c6ddc32e74f4a6dc16fd06f218210ff1b7ce57f26ca1994bfffc407915"
---

# SQL.SQLite3

## SQL.SQLite3

```
object @SQL.SQLite3(@SQL.Connection) {
	MODE_READ;
	MODE_WRITE;
	MODE_CREATE;
	construct(string $path, int $mode, string $key) {}
	createAggregate(string $name, function $callback_step, function $callback_final): $this {}
	createCollation(string $name, function $callback): $this {}
	createFunction(string $name, function $callback): $this {}
}
```

**SQLite3 connection prototype.**

### Prototype

**[SQL.Connection](#)**

## Methods


### `$this.construct()`


```code
$this.construct(string $path, int $mode, string $key): void
```

##### Parameters

| Name | Type | Value | Default |
| --- | --- | --- | --- |
| path | `string`  |  | "" |
| mode | `int`  |  | MODE_READ | MODE_WRITE | MODE_CREATE |
| key | `string`  |  | "" |




### `$this.createAggregate()`


```code
$this.createAggregate(string $name, function $callback_step, function $callback_final): this
```

##### Parameters

| Name | Type | Value | Default |
| --- | --- | --- | --- |
| name | `string`  |  | "" |
| callback_step | `function`  |  | null |
| callback_final | `function`  |  | null |

##### Returns

| Type | Value |
| --- | ---  |
| `$this` |  |




### `$this.createCollation()`


```code
$this.createCollation(string $name, function $callback): this
```

##### Parameters

| Name | Type | Value | Default |
| --- | --- | --- | --- |
| name | `string`  |  | "" |
| callback | `function`  |  | null |

##### Returns

| Type | Value |
| --- | ---  |
| `$this` |  |




### `$this.createFunction()`


```code
$this.createFunction(string $name, function $callback): this
```

##### Parameters

| Name | Type | Value | Default |
| --- | --- | --- | --- |
| name | `string`  |  | "" |
| callback | `function`  |  | null |

##### Returns

| Type | Value |
| --- | ---  |
| `$this` |  |