Sqlite

Metsä Advisor: Finnish Forest Intelligence on Three Open APIs The Problem Finland has about 344,000 private forest holders. Most own forest as a secondary asset, not a full-time profession. They all ask the same two questions periodically: what’s actually on my property, and what is it worth right now? The data exists. Three Finnish government agencies publish it under CC BY 4.0: Maanmittauslaitos — cadastral boundaries via OGC API Features Metsäkeskus — forest stand inventory via WFS Luke — regional stumpage prices via PxWeb The problem is the plumbing. Three protocols, three data shapes, schemas that assume you already know what you’re looking at. Metsä Advisor is an agent that does the assembly. ...

Pulse: Reddit Community Discovery Agent The Problem Every business wants to be where their customers are. On Reddit, that means finding the right subreddits, the right threads, and writing replies that don’t get downvoted into oblivion. Doing this manually takes hours — scanning dozens of communities, reading thread context, crafting replies that actually add value. Pulse does this automatically. What It Does Enter your website URL and email. The agent takes over: ...

Health Exporter: 17-Tool MCP Server for Apple Health The Problem Apple Health collects everything — workouts, heart rate, sleep, steps, nutrition, blood pressure, body measurements. Years of data, millions of records. But you can’t ask it questions. “What was my average resting heart rate last month?” requires exporting XML, writing scripts, parsing timestamps. Health Exporter puts all of it behind MCP tools that Claude can call directly. What It Does Export your Apple Health data once. Health Exporter parses the XML, loads it into SQLite, and exposes 17 MCP tools organized by health domain: ...

1. Overview Svenska Verb This app is a focused, offline‑capable Swedish verb learning tool. It combines a lean Node.js backend (synchronization + licensing + snapshot generation) with a Vite/TypeScript frontend built entirely from custom Web Components—no heavyweight SPA framework. Data flows through a snapshot/verification pipeline backed by SQLite for determinism and easy recovery. The goal: minimize moving parts while keeping future extensibility (custom verbs, SRS scheduling, multi‑language overlays) straightforward. 2. Architecture at a Glance Front-End (Vite + TS + Web Components) ├─ State & Caching: src/services/storage.ts ├─ Migration Logic: src/services/migration.ts ├─ Sync Client: src/services/sync.ts ├─ Licensing: src/services/license.ts └─ UI Components: src/components/*.ts │ ▼ Node.js Sync / API Server ├─ server.ts (HTTP endpoints) ├─ db.ts (SQLite access) ├─ snapshots.db (+ WAL/SHM) └─ Data Generation / Repair Scripts (scripts/*.js|ts) │ ▼ Source Datasets ├─ data/verbs.json └─ Generated examples / translations Core Principles: ...