npm install @mdxdb/sqlite

import { createDatabase } from '@mdxdb/sqlite'
 
const db = createDatabase({
  filename: './content.db',
})

interface SqliteConfig {
  /** Database file path, or ':memory:' for in-memory */
  filename: string
 
  /** Enable WAL mode (default: true) */
  wal?: boolean
 
  /** Enable full-text search (default: true) */
  fts?: boolean
}

-- Main documents table
CREATE TABLE documents (
  path TEXT PRIMARY KEY,
  type TEXT,
  data JSON,
  content TEXT,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
);
 
-- Full-text search index
CREATE VIRTUAL TABLE documents_fts USING fts5(
  path,
  title,
  content,
  content=documents
);

import { createDatabase } from '@mdxdb/sqlite'
 
const db = createDatabase({
  filename: './data/content.db',
})
 
// All standard operations work
await db.set('posts/hello', doc)
const post = await db.get('posts/hello')
const posts = await db.list('posts/')

const db = createDatabase({
  filename: ':memory:',
})
 
// Great for testing
await db.set('test/doc', doc)

const results = await db.search('typescript tutorial', {
  fields: ['title', 'content'],
  limit: 10,
})
 
for (const result of results.documents) {
  console.log(result.data.title)
}

import { createDatabase } from '@mdxdb/sqlite/d1'
 
export default {
  async fetch(request, env) {
    const db = createDatabase({
      d1: env.DB,
    })
 
    const doc = await db.get('posts/hello')
    return Response.json(doc)
  },
}

import { createDatabase } from '@mdxdb/sqlite/turso'
 
const db = createDatabase({
  url: process.env.TURSO_URL,
  authToken: process.env.TURSO_AUTH_TOKEN,
})