SQL Functions

Eidos extends SQLite with several built-in functions to facilitate personal data management and local intelligence. Most of these functions are available in both web and desktop versions.

Eidos Specific Extensions

Please note that these are non-standard SQLite functions provided specifically by the Eidos environment. While your database file remains a standard SQLite format and can be opened in any tool, these custom functions will only execute successfully when running within Eidos.

File System

Functions to interact with your local files and project structure.

lsdir(path [, recursive])

A table-valued function (virtual table) that lists files and subdirectories. This mimics the behavior of the standard SQLite fileio extension.

• Parameters:
  • path: The directory to list. Supports ~ (home) and @/ (mounts).
  • recursive: (Optional) 1 for recursive search, 0 for top-level only (default).
• Returned Columns: name, path, kind, pathname, size, mtime.
• Example:

  -- List all PDFs in your Documents folder recursively
  SELECT * FROM lsdir('~/Documents', 1) WHERE name LIKE '%.pdf';