docs/release-notes.sql

              SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
              SELECT 'breadcrumb' as component;
WITH RECURSIVE breadcrumbs AS (
    SELECT
        COALESCE(abbreviated_caption, caption) AS title,
        COALESCE(url, path) AS link,
        parent_path, 0 AS level,
        namespace
    FROM sqlpage_aide_navigation
    WHERE namespace = 'prime' AND path='docs/release-notes.sql'
    UNION ALL
    SELECT
        COALESCE(nav.abbreviated_caption, nav.caption) AS title,
        COALESCE(nav.url, nav.path) AS link,
        nav.parent_path, b.level + 1, nav.namespace
    FROM sqlpage_aide_navigation nav
    INNER JOIN breadcrumbs b ON nav.namespace = b.namespace AND nav.path = b.parent_path
)
SELECT title ,      
sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/'||link as link        
FROM breadcrumbs ORDER BY level DESC;
              -- not including page title from sqlpage_aide_navigation
              

              SELECT 'title' AS component, 'Release Notes for surveilr Versions' as contents;

                    SELECT 'foldable' as component;
                    SELECT 'v1.7.25' as title, '# `surveilr` v1.7.13 Release Notes

This release aims to improve the `surveilr osquery-ms` server; no new features or bug fixes were added.' as description_md;
                

                    SELECT 'foldable' as component;
                    SELECT 'v1.7.16' as title, '# `surveilr` v1.7.16 Release Notes

## Bug Fixes
1. Enhanced the CSV transform functionality to correctly include partyID for each ingested CSV table when provided.

2. Resolved an issue where ingesting multiple CSV files with the same name from different folders resulted in data loss. Now, all files are consolidated into a single table while preserving distinct data sources with the partyID field.' as description_md;
                

                    SELECT 'foldable' as component;
                    SELECT 'v1.7.13' as title, '# `surveilr` v1.7.13 Release Notes

This release aims to improve the `surveilr osquery-ms` server; no new features or bug fixes were added.' as description_md;
                

                    SELECT 'foldable' as component;
                    SELECT 'v1.7.12' as title, '# `surveilr` v1.7.12 Release Notes

## 🚀 What''s New

### 1. `surveilr osquery-ms` Server
The server has been fully setup, configured with boundaries and the corresponding WebUI, fully configurable with `code_notebooks`.' as description_md;
                

                    SELECT 'foldable' as component;
                    SELECT 'v1.7.11' as title, '# `surveilr` v1.7.11 Release Notes

## 🚀 What''s New

### 1. Upgraded SQLPage
SQLPage has been updated to version 0.33.1, aligning with the latest releases.

## Bug Fixes
### 1. `surveilr admin merge`
- Added recent and new tables to the merge structure ensuring all tables in each RSSD are present in the final merged RSSD.' as description_md;
                

                    SELECT 'foldable' as component;
                    SELECT 'v1.7.10' as title, '# `surveilr` v1.7.10 Release Notes

## 🚀 What''s New

### 1. Enhancing `surveilr`''s osQuery Management Server
- Added support for boundaries to enable grouping of nodes for better viewing
' as description_md;
                

                    SELECT 'foldable' as component;
                    SELECT 'v1.7.9' as title, '# `surveilr` v1.7.9 Release Notes

## 🚀 What''s New

### 1. Enhancing `surveilr`''s osQuery Management Server
- Introduced a new flag `--keep-status-logs` to indicate whether the server should store status logs received from osQuery in the RSSD.' as description_md;
                

                    SELECT 'foldable' as component;
                    SELECT 'v1.7.8' as title, '# `surveilr` v1.7.8 Release Notes

This release focuses on enhancing the `surveilr osquery-ms` UI by adding new tables and optimizing data management. No bugs were fixed or new features introduced. Please review the Web UI for updates.
' as description_md;
                

                    SELECT 'foldable' as component;
                    SELECT 'v1.7.7' as title, '# `surveilr` v1.7.7 Release Notes

This release aims to improve the `surveilr osquery-ms` server; no new features or bug fixes were added.' as description_md;
                

                    SELECT 'foldable' as component;
                    SELECT 'v1.7.6' as title, '# `surveilr` v1.7.6 Release Notes

---

## 🚀 Bug Fixes

### 1. `surveilr` Bootstrap SQL
This release fixes the "no such table: device" error introduced in the previous version by propagating any erroors during the SQL initialization of the RSSD with `surveilr`.' as description_md;
                

                    SELECT 'foldable' as component;
                    SELECT 'v1.7.5' as title, '# `surveilr` v1.7.5 Release Notes

---


### 🆕 **New Features**
- **osQuery Management Server Integration**:  
  - `surveilr` now acts as a management layer for osQuery, enabling secure and efficient monitoring of infrastructure.
  - Supports remote configuration, logging, and query execution for osQuery nodes.

- **Behavior & Notebooks Support**:  
  - Introduced **Notebooks**, which store predefined queries in the `code_notebook_cell` table.
  - **Behaviors** allow defining and managing query execution for different node groups.

- **Secure Node Enrollment**:  
  - Nodes authenticate using an **enrollment secret key** (`SURVEILR_OSQUERY_MS_ENROLL_SECRET`).
  - Secure communication via **TLS certificates** (`cert.pem`, `key.pem`).

- **Automated Query Execution**:  
  - Default queries from **"osQuery Management Server (Prime)"** execute automatically.
  - Custom notebooks and queries can be added dynamically via SQL.

- **Centralized Logging & Config Fetching**:  
  - Osquery logs and configurations are fetched via TLS endpoints (`/logger`, `/config`).
  - All communication is secured using **server-side TLS certificates**.

- **Web UI for Query Results Visualization**:  
  - `surveilr web-ui` provides an intuitive dashboard to inspect query results across enrolled nodes.
  - Simply start with `surveilr web-ui -p 3050 --host <server-ip>`.' as description_md;
                

                    SELECT 'foldable' as component;
                    SELECT 'v1.7.1' as title, '# `surveilr` v1.7.1 Release Notes

---

## 🚀 What''s New

### 1. Enhancing `surveilr`''s osQuery Management Server
- Introduced a new flag--behavior` or `-b` to specify behavior name to queries to run automatically enrolled nodes.
- a new SQLite function called `surveilr_osquery_ms_create_behaviour` to facilitate the creation of behaviors, making process smooth and easy.

### Example
When starting the `surveilr osquery-ms` server without passing a behavior, a default behavior with the following query configuration is created:
```json
{
  "surveilr-cli": {
    ...
    "osquery_ms": {
      "tls_proc": {
 "query": "select * from processes",
        "interval": 60
      }
    }
  }
}

To use a behavior with the surveilr osQuery management server first create a behavior using the new function:

surveilr shell --cmd "select surveil_osquery_ms_create_behaviour(''-behaviour'', ''{\"tls_proc\": {\"query\": \"select * from processes\", \"interval\": 60}, \"routes\": {\"query\": \"SELECT * FROM routes WHERE destination = ''''::1''''\", \"interval\": 60}}'');"

Then, pass that behavior to the server by:

surveilr osquery-ms --cert ./cert.pem --key ./key.pem --enroll-secret "<secret>" -b "initial-behaviour"
```' as description_md;
                

                    SELECT 'foldable' as component;
                    SELECT 'v1.7.0' as title, '# `surveilr` v1.7.0 Release Notes

---

## 🚀 What''s New

### **1. `surveilr` OSQuery Management Server**
Introducing Osquery Management Server using `surveilr`, enabling secure and centralized monitoring of your infrastructure. The setup ensures secure node enrollment through TLS authentication and secret keys, allowing only authorized devices to connect. Users can easily configure and manage node behaviors dynamically via `surveilr`’s behavior tables.

### **2. OpenDAL Dropbox Integration**
The `surveilr_udi_dal_dropbox` SQLite function, is a powerful new virtual table module that enables seamless interaction with Dropbox files directly within your SQL queries. This module allows users to access and query comprehensive file metadata, including name, path, size, last modified timestamp, content, and more, within specified directories.' as description_md;
                

                    SELECT 'foldable' as component;
                    SELECT 'v1.6.0' as title, '# `surveilr` v1.6.0 Release Notes

---

## 🚀 What''s New

### **1. SQLPage**
- Updated SQLPage to the latest version, ensuring compatibility and access to the newest features and bug fixes.' as description_md;
                

                    SELECT 'foldable' as component;
                    SELECT 'v1.5.11' as title, '# `surveilr` v1.5.11 Release Notes

---

### Overview
This release includes updates to dependencies, bug fixes, and performance improvements to enhance stability and functionality.' as description_md;
                

                    SELECT 'foldable' as component;
                    SELECT 'v1.5.10' as title, '# `surveilr` v1.5.9 Release Notes

---

## 🚀 Bug Fixes

### **1. WebUI Page for About**
- A dedicated About page has been added in the WebUI to visualize the response of `surveilr doctor`:
  - **Dependencies Table**:
    - The display of versions and their generation process has been fixed.
  - **Diagnostic Views**:
    - A new section has been added to display the contents and details of all views prefixed with `surveilr_doctor*`, facilitating the of details and logs for diagnostics.' as description_md;
                

                    SELECT 'foldable' as component;
                    SELECT 'v1.5.8' as title, '# `surveilr` v1.5.8 Release Notes 🎉

---

### **1. WebUI Page for About**
- Added a dedicated About page in the WebUI visiualizing the response of `surveilr doctor`:
  - **Dependencies Table**:
    - Displays the versions of `sqlpage`, `rusqlite`, and `pgwire` in a table.
  - **Extensions List**:
    - Lists all synamic and static extensions .
  - **Capturable executables**:
    - Lists all capturable executables that were found in the `PATH`.
  - **Env variables**
    - Captures all environment variables starting with `SURVEILR_` and `SQLPAGE_`.' as description_md;
                

                    SELECT 'foldable' as component;
                    SELECT 'v1.5.6' as title, '# `surveilr` v1.5.6 Release Notes 🎉

---

## 🚀 What''s New
### **1. Enhanced Diagnostics Command**
- **`surveilr doctor` Command Improvements**:
  - **Dependencies Check**:
    - Verifies versions of critical dependencies: `Deno`, `Rustc`, and `SQLite`.
    - Ensures dependencies meet minimum version requirements for seamless functionality.
  - **Capturable Executables Detection**:
    - Searches for executables in the `PATH` matching `surveilr-doctor*.*`.
    - Executes these executables, assuming their output is in JSON format, and integrates their results into the diagnostics report.
  - **Database Views Analysis**:
    - Queries all views starting with the prefix `surveilr_doctor_` in the specified RSSD.
    - Displays their contents in tabular format for comprehensive insights.

---

### **2. JSON Mode**
- Added a `--json` flag to the `surveilr doctor` command.
  - Outputs the entire diagnostics report, including versions, extensions, and database views, in structured JSON format.

---

### **3. WebUI Page for Diagnostics**
- Added a dedicated page in the WebUI for the `surveilr doctor` diagnostics:
  - **Versions Table**:
    - Displays the versions of `Deno`, `Rustc`, and `SQLite` in a table.
  - **Extensions List**:
    - Lists all detected extensions.
  - **Database Views Content**:
    - Automatically identifies and displays the contents of views starting with `surveilr_doctor_` in individual tables.' as description_md;
                

                    SELECT 'foldable' as component;
                    SELECT 'v1.5.5' as title, '# `surveilr` v1.5.5 Release Notes 🎉

---

## 🚀 What''s New

### Virtual Table: `surveilr_function_docs`

**Description**  
The `surveilr_function_docs` virtual table offers a structured method to query metadata about `surveilr` SQLite functions registered in the system.

**Columns**  
- `name` (`TEXT`): The function''s name.
- `description` (`TEXT`): A concise description of the function''s purpose.
- `parameters` (`JSON`): A JSON object detailing the function''s parameters, including:
  - `name`: The name of the parameter.
  - `data_type`: The parameter''s expected data type.
  - `description`: An explanation of the parameter''s role.
- `return_type` (`TEXT`): The function''s return type.
- `introduced_in_version` (`TEXT`): The version in which the function was first introduced.

**Use Cases**  
- Utilized in the Web UI for generating documentation on the functions.

---

### Virtual Table: `surveilr_udi_dal_fs`

**Description**  
The `surveilr_udi_dal_fs` virtual table acts as an abstraction layer for interacting with the file system. It enables users to list and examine file metadata in a structured, SQL-friendly manner. This table can list files and their metadata recursively from a specified path.

**Columns**  
- `name` (`TEXT`): The file''s name.
- `path` (`TEXT`): The complete file path.
- `last_modified` (`TEXT`): The file''s last modified timestamp, when available.
- `content` (`BLOB`): The content of the file (optional).
- `size` (`INTEGER`): The size of the file in bytes.
- `content_type` (`TEXT`): The MIME type of the file or an inferred content type (e.g., based on the extension).
- `digest` (`TEXT`): The MD5 digest of the file, if available.
- `arg_path` (`TEXT`, hidden): The base path for querying files, specified in the `filter` method.

**Key Features**  
- Lists files recursively from a specified directory.
- Facilitates metadata extraction, such as file size, last modified timestamp, and MDhash).

---

### Virtual Table: `surveilr_udi_dal_s3`

**Description**  
The `surveilr_udi_dal_s3` virtual table is an abstraction layer that interacts with the S3 bucket in a given region. It allows listing and inspecting file metadata in a structured, SQL-accessible way.

**Columns**  
- `name` (`TEXT`): The name of the file.
- `path` (`TEXT`): The full path to the file.
- `last_modified` (`TEXT`): The last modified timestamp of the file, if available.
- `content` (`BLOB`): The file''s content (optional).
- `size` (`INTEGER`): The file size in bytes.
- `content_type` (`TEXT`): The file''s MIME type or inferred content type (e.g., based on the extension).
- `digest` (`TEXT`): The file''s MD5 digest, if available.
- `arg_path` (`TEXT`, hidden): The base path to query files from, specified in the `filter` method.

**Key Features**  
- Supports metadata extraction (e.g., file size, last modified timestamp, MD5 hash).

---

## Example Queries

### Querying Function Documentation
```sql
SELECT * FROM surveilr_function_docs WHERE introduced_in_version = ''1.0.0'';
```' as description_md;
                

                    SELECT 'foldable' as component;
                    SELECT 'v1.5.3' as title, '# `surveilr` v1.5.3 Release Notes 🎉

---

## 🚀 What''s New

### 1. **Open Project Data Extension**
`surveilr` now includes additional data from Open Project PLM ingestion. Details such as a work package''s versions and relations are now encapsulated in JSON format in a new `elaboration` column within the `ur_ingest_session_plm_acct_project_issue` table. The JSON structure is as follows, with the possibility for extension:
```json
elaboration: {"issue_id": 78829, "relations": [...], "version": {...}}

2. Functions for Extension Verification

Two new functions have been introduced to verify and ensure the presence of certain intended functions and extensions before their use:

The select surveilr_ensure_function(''func'', ''if not found msg'', ''func2'', ''if func2 not found msg'') function can be used to declaratively specify the required function(s), and will produce an error with guidance on how to obtain the function if it is not found.
The select surveilr_ensure_extension(''extn.so'', ''../bin/extn2.so'') function allows for the declarative indication of necessary extensions, and will dynamically load them if they are not already available.' as description_md;
```
              SELECT 'foldable' as component;
              SELECT 'v1.5.2' as title, '# `surveilr` v1.5.2 Release Notes 🎉
```

🚀 What''s New

1. `surveilr` SQLite Extensions

surveilr extensions are now statically linked, resolving all extensions and function usage issues. The following extensions are included by default in surveilr, with additional ones planned for future releases:

sqlean
sqlite-url
sqlite-hashes

sqlite-lines' as description_md;

              SELECT 'foldable' as component;
              SELECT 'v1.4.3' as title, '# `surveilr` v1.4.2 Release Notes 🎉

🚀 What''s New

1. Utilizing Custom Extensions with `surveilr`

In the previous release, we introduced the feature of automatically loading extensions from the default sqlpkg location. However, this posed a security risk, and we have since disabled that feature. To use extensions installed by sqlpkg, simply pass --sqlpkg, and the default location will be utilized. If you wish to change the directory from which extensions are loaded, use --sqlpkg /path/to/extensions, or specify the directory with the new SURVEILR_SQLPKG environment variable.' as description_md;

                SELECT 'foldable' as component;
                SELECT 'v1.4.2' as title, '# `surveilr` v1.4.2 Release Notes 🎉

🚀 What''s New

1. Utilizing Custom Extensions with `surveilr`

Loading extensions is now straightforward with the --sqlite-dyn-extn flag. As long as your extensions are installed via sqlpkg, surveilr will automatically detect the default location of sqlpkg and all installed extensions. Simply install the extension using sqlpkg. To specify a custom path for sqlpkg, use the --sql-pkg-home argument with a directory containing the extensions, regardless of depth, and surveilr will locate them. Additionally, the SURVEILR_SQLITE_DYN_EXTNS environment variable has been introduced to designate an extension path instead of using --sqlite-dyn-extn. Note: Using --sqlite-dyn-extn won''t prevent surveilr from loading extensions from sqlpkg''s default directory. To disable loading from sqlpkg, use the --no-sqlpkg flag.

Here''s a detailed example of using surveilr shell and surveilr orchestrate with dynamic extensions. Using sqlpkg defaults

Download the sqlpkg CLI.
Download the text extension, which offers various text manipulation functions: sqlpkg install nalgeon/sqlean

Run the following command:

surveilr shell --cmd "select text_substring(''hello world'', 7, 5) AS result" # surveilr loads all extensions from the .sqlpkg default directory

Including an additional extension with sqlpkg Combine --sqlite-dyn-extn with surveilr''s ability to load extensions from sqlpkg

Add the path extension to sqlpkg''s installed extensions: sqlpkg install asg017/path

Execute:

surveilr shell --cmd "SELECT
      text_substring(''hello world'', 7, 5) AS substring_result,
      math_sqrt(9) AS sqrt_result,
      path_parts.type,
      path_parts.part 
  FROM 
      (SELECT * FROM path_parts(''/usr/bin/sqlite3'')) AS path_parts;
  " --sqlite-dyn-extn .extensions/math.so

Specify a Custom Directory to Load Extensions From A --sqlpkg-home flag has been introduced to specify a custom path for extensions. They do not need to be installed by sqlpkg to be used. surveilr will navigate the specified folder and load all compatible extensions for the operating system—.so for Linux, .dll for Windows, and .dylib for macOS. (If you installed with sqlpkg, you don''t need to know the file type).

surveilr shell --cmd "SELECT text_substring(''hello world'', 7, 5) AS substring_result, math_sqrt(9) AS sqrt_result" --sqlpkg-home ./src/resource_serde/src/functions/extensions/

2. Upgraded SQLPage

SQLPage has been updated to version 0.31.0, aligning with the latest releases.' as description_md;

                SELECT 'foldable' as component;
                SELECT 'v1.4.1' as title, '# `surveilr` v1.4.1 Release Notes 🎉

🚀 Bug Fixes

1. `surveilr` SQLite Extensions

To temporarily mitigate the issue with surveilr intermittently working due to the dynamic loading of extensions, surveilr no longer supports dynamic loading by default. It is now supported only upon request by using the --sqlite-dyn-extn flag. This flag is a multiple option that specifies the path to an extension to be loaded into surveilr. To obtain the dynamic versions (.dll, .so, or .dylib), you can use sqlpkg to install the necessary extension.

For instance, to utilize the text functions:

Install the extension with sqlpkg: sqlpkg install nalgeon/text

Then execute it:

surveilr shell --cmd "select text_substring(''hello world'', 7, 5);" --sqlite-dyn-extn ./text.so
```' as description_md;
              

                  SELECT 'foldable' as component;
                  SELECT 'v1.3.1' as title, '# `surveilr` v1.3.1 Release Notes 🎉

🚀 Bug Fixes

1. `surveilr` SQLite Extensions

This release fixes the glibc compatibility error that occured with surveilr while registering function extensions.' as description_md;

                SELECT 'foldable' as component;
                SELECT 'v1.3.0' as title, '# `surveilr` Release Announcement: Now Fully Compatible Across All Distros 🎉

We are thrilled to announce that surveilr is now fully compatible with all major Linux distributions, resolving the longstanding issue related to OpenSSL compatibility! 🚀

What''s New?

Universal Compatibility: surveilr now works seamlessly on Ubuntu, Debian, Kali Linux, and other Linux distributions, across various versions and architectures. Whether you''re using Ubuntu 18.04, Debian 10, or the latest Kali Linux, surveilr is ready to perform without any hiccups.
Resolved OpenSSL Bug: We’ve fixed the recurring OpenSSL-related issue that caused headaches for users on older and varied systems. With this update, you no longer need to worry about OpenSSL version mismatches or missing libraries. ' as description_md;
```
              SELECT 'foldable' as component;
              SELECT 'v1.2.0' as title, '# `surveilr` v1.2.0 Release Notes 🎉
```

What''s New?

This update introduces two major additions that streamline file system integration and ingestion session management.

New Features

1. `surveilr_ingest_session_id` Scalar Function

The surveilr_ingest_session_id function is now available, offering robust management of ingestion sessions. This function ensures efficient session handling by:

Reusing existing session IDs for devices with active sessions.
Creating new ingestion sessions when none exist.
Associating sessions with metadata for improved traceability.

2. `surveilr_udi_dal_fs` Virtual Table Function

The surveilr_udi_dal_fs virtual table function provides seamless access to file system resources directly within your SQL queries. With this feature, you can:

Query file metadata, such as names, paths, sizes, and timestamps.
Retrieve file content and calculate digests for integrity checks.

Traverse directories recursively to handle large and nested file systems effortlessly. ' as description_md;

              SELECT 'foldable' as component;
              SELECT 'v1.1.0' as title, '# `surveilr` v1.1.0 Release Notes 🎉

🚀 New Features

1. Integrated Documentation in Web UI

This release introduces a comprehensive update to the RSSD Web UI, allowing users to access and view all surveilr-related SQLite functions, release notes, and internal documentation directly within the interface. This feature enhances user experience by providing integrated, easily navigable documentation without the need to leave the web environment, ensuring that all necessary information is readily available for efficient reference and usage.

2. `uniform_resource` Graph Infrastructure

The foundational framework for tracking uniform_resource content using graph representations has been laid out in this release. This infrastructure allows users to visualize uniform_resource data as connected graphs in addition to the traditional relational database structure. To facilitate this, three dedicated views—imap_graph, plm_graph, and filesystem_graph—have been created. These views provide a structured way to observe and interact with data from different ingestion sources:

imap_graph: Represents the graphical relationships for content ingested through IMAP processes, allowing for a visual mapping of email and folder structures.
plm_graph: Visualizes content from PLM (Product Lifecycle Management) ingestion, showcasing project and issue-based connections.
filesystem_graph: Illustrates file ingestion paths and hierarchies, enabling users to track and manage file-based data more intuitively.

This release marks an important step towards enhancing data tracking capabilities, providing a dual approach of relational and graphical views for better data insights and management. ' as description_md;

                SELECT 'foldable' as component;
                SELECT 'v1.0.0' as title, '# `surveilr` v1.0.0 Release Notes 🎉

We’re thrilled to announce the release of surveilr v1.0, a significant milestone in our journey to deliver powerful tools for continuous security, quality and compliance evidence workflows. This release introduces a streamlined migration system and a seamless, user-friendly experience for accessing the surveilr Web UI.

🚀 New Features

1. Database Migration System

This release introduces a comprehensive database migration feature that allows smooth and controlled updates to the RSSD structure. Our migration system includes:

Structured Notebooks and Cells: A structured system organizes SQL migration scripts into modular code notebooks, making migration scripts easy to track, audit, and execute as needed.
Idempotent vs. Non-Idempotent Handling: Ensures each migration runs in an optimal and secure manner by tracking cell execution history, allowing for re-execution where safe.
Automated State Tracking: All state changes are logged for complete auditing, showing timestamps, transition details, and the results of each migration step.
Transactional Execution: All migrations run within a single transaction block for seamless rollbacks and data consistency.
Dynamic Migration Scripts: Cells marked for migration are dynamically added to the migration script, reducing manual effort and risk of errors.

This system ensures safe, controlled migration of database changes, enhancing reliability and traceability for every update.

2. Enhanced Default Command and Web UI Launch

The surveilr executable now starts the Web UI as the default command when no specific CLI commands are passed. This feature aims to enhance accessibility and ease of use for new users and teams. Here’s what happens by default:

Automatic Web UI Startup: By default, running surveilr without additional commands launches the surveilr Web UI.
Auto-Browser Launch: Opens the default browser on the workstation, pointing to the Web UI’s URL and port, providing a user-friendly experience right from the first run.' as description_md;

docs/release-notes.sql

2. Functions for Extension Verification

🚀 What''s New

1. surveilr SQLite Extensions

🚀 What''s New

1. Utilizing Custom Extensions with surveilr

🚀 What''s New

1. Utilizing Custom Extensions with surveilr

2. Upgraded SQLPage

🚀 Bug Fixes

1. surveilr SQLite Extensions

🚀 Bug Fixes

1. surveilr SQLite Extensions

What''s New?

What''s New?

New Features

1. surveilr_ingest_session_id Scalar Function

2. surveilr_udi_dal_fs Virtual Table Function

🚀 New Features

1. Integrated Documentation in Web UI

2. uniform_resource Graph Infrastructure

🚀 New Features

1. Database Migration System

2. Enhanced Default Command and Web UI Launch

1. `surveilr` SQLite Extensions

1. Utilizing Custom Extensions with `surveilr`

1. Utilizing Custom Extensions with `surveilr`

1. `surveilr` SQLite Extensions

1. `surveilr` SQLite Extensions

1. `surveilr_ingest_session_id` Scalar Function

2. `surveilr_udi_dal_fs` Virtual Table Function

2. `uniform_resource` Graph Infrastructure