Skip to content

cianfhoghlaim/cianchosaint / .agents/skills/lancedb

lancedb

Verified

references/lancedb-cloud.md

View on GitHub
# LanceDB Cloud

LanceDB Cloud is the managed, serverless LanceDB offering. It runs
in 4 regions and includes auto-compaction + auto-reindexing.

## Regions

- `us-east-1` (Virginia)
- `us-west-2` (Oregon)
- `eu-west-1` (Ireland) — **the Cianfhoghlaim region**, closest to Galway
- `ap-south-1` (Mumbai)

## Connection

```python
import lancedb
import os

db = lancedb.connect(
    "db://my-database",
    api_key=os.environ["LANCEDB_API_KEY"],
    region="eu-west-1",
)
```

Or via env vars:

```bash
# .env
LANCEDB_URI=db://my-database
LANCEDB_API_KEY=...
LANCEDB_REGION=eu-west-1
```

```python
db = lancedb.connect(
    os.environ["LANCEDB_URI"],
    api_key=os.environ["LANCEDB_API_KEY"],
    region=os.environ["LANCEDB_REGION"],
)
```

## Features

| Feature | Description |
|:--|:--|
| **Auto-compaction** | Runs every 5 minutes; no manual `compact()` needed |
| **Auto-reindexing** | Re-creates HNSW index on every 1k writes |
| **Multi-region** | Pick the region closest to your data |
| **Serverless** | No instance management; pay per query + storage |
| **Backups** | Daily snapshots, point-in-time recovery |
| **Encryption at rest** | AES-256 |
| **Private endpoints** | Available on Enterprise plan |

## Pricing model

- **Storage**: per GB per month (varies by region)
- **Queries**: per 1k vector queries
- **Writes**: per 1k rows inserted
- **Free tier**: 100 GB storage, 10M queries/month

For Cianfhoghlaim production, use LanceDB Cloud in `eu-west-1` for the
leabharlann + curriculum indexes.

## Local → Cloud migration

```python
# 1. Local LanceDB
local_db = lancedb.connect("./lancedb_data")
table = local_db.open_table("my_table")
print(f"{table.count_rows()} rows")

# 2. Cloud LanceDB
cloud_db = lancedb.connect("db://my-database", api_key=..., region="eu-west-1")
cloud_table = cloud_db.create_table("my_table", schema=table.schema, mode="overwrite")

# 3. Bulk copy
batch = []
for batch_start in range(0, table.count_rows(), 1000):
    df = table.to_pandas().iloc[batch_start:batch_start+1000]
    batch.append(df)
cloud_table.add(batch)
```

## Cloudflare R2 + LanceDB Cloud

For a self-hosted R2 backend (the Cianfhoghlaim production target), use the
rclone-sidecar Compose pattern (see
`references/hosting-lancedb-docker-compose.md` for the docker-compose
example). The pattern:

1. Run an rclone container mounted as a FUSE filesystem at `/data/lance`
2. Run the LanceDB-using service with `/data/lance` mounted
3. rclone syncs the local `/data/lance` to R2 every N minutes
slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack."Stars: 198kUpdated Claude CodeCodexVerifiedInstall
ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt.Stars: 194kUpdated Claude CodeCodexVerifiedInstall