sqlite-regex 0.2.3

A SQLite extension for working with regular expressions
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33

<!--- Generated with the deno_generate_package.sh script, don't edit by hand! -->

# `x/sqlite_regex` Deno Module

[![Tags](https://img.shields.io/github/release/asg017/sqlite-regex)](https://github.com/asg017/sqlite-regex/releases)
[![Doc](https://doc.deno.land/badge.svg)](https://doc.deno.land/https/deno.land/x/sqlite-regex@0.2.3/mod.ts)

The [`sqlite-regex`](https://github.com/asg017/sqlite-regex) SQLite extension is available to Deno developers with the [`x/sqlite_regex`](https://deno.land/x/sqlite_regex) Deno module. It works with [`x/sqlite3`](https://deno.land/x/sqlite3), the fastest and native Deno SQLite3 module.

```js
import { Database } from "https://deno.land/x/sqlite3@0.8.0/mod.ts";
import * as sqlite_regex from "https://deno.land/x/sqlite_regex@v0.2.3/mod.ts";

const db = new Database(":memory:");

  db.enableLoadExtension = true;
  db.loadExtension(sqlite_regex.getLoadablePath());

  const [version] = db
    .prepare("select regex_version()")
    .value<[string]>()!;

  console.log(version);

```

Like `x/sqlite3`, `x/sqlite_regex` requires network and filesystem permissions to download and cache the pre-compiled SQLite extension for your machine. Though `x/sqlite3` already requires `--allow-ffi` and `--unstable`, so you might as well use `--allow-all`/`-A`.

```bash
deno run -A --unstable <file>
```

`x/sqlite_regex` does not work with [`x/sqlite`](https://deno.land/x/sqlite@v3.7.0), which is a WASM-based Deno SQLite module that does not support loading extensions.