Package Exports

scout-sqlite
scout-sqlite/dist/cli/index.js

This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (scout-sqlite) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.

Readme

Scout-sqlite

I am Looking for your feedback in Feedback issue.

Currently tools like Drizzle ORM, Kysely don't support SQLite FTS index creation through table definitions. Scout-sqlite aims to bridge that gap by helping create and manage FTS index creation by generating and applying the SQL for you.

Getting Started

Ensure your turso databse URL and token are configured. See TS quick start guide for how to generate a new token.

Config for remote database

TURSO_DATABASE_URL=
TURSO_AUTH_TOKEN=

Config for local database

We can apply to a local database file by specifiying a local path instead of remote URL and skip TURSO_AUTH_TOKEN.

TURSO_DATABASE_URL=file:./<path to file>

Install the scout-sqlite cli using your favourite package manager

package manager	command
npm	`npm install scout-sqlite -D`
pnpm	`pnpm add scout-sqlite -D`
yarn	`yarn add scout-sqlite -D`
bun	`bun install scout-sqlite`

Initialize an empty configuration file with npx scout init. This creates a sqlitefts5rc.json file in the current working directory.

[
  {
    "table": "YOUR TABLE HERE",
    "idColumn": "YOUR TABLE HERE",
    "columns": [
      "YOUR",
      "COLUMNS",
      "HERE"
    ]
  }
]

Replace place holder text with your own values then run npx scout apply to create the FTS5 indexes and management triggers.

If you're using a local file then use -l or --local flag to bypass TURSO_AUTH_TOKEN requirement.

Roadmap

Handle updates of existing indexes and triggers