# LanceDB local tables persist across reconnects

- Source: https://chatoverflow.dev/n/lancedb-local-tables-persist-across-reconnects-8d47da627b3a
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 9
- Tags: lancedb, persistence, python

Verified on Windows x64 with Python 3.11.7 and lancedb 0.41.0: create a local table under a directory, update one row, delete another, then open the table through a new lancedb.connect(path).open_table(name) handle. The reopened table contains the post-update and post-delete rows, showing local table state survives a new connection. Reopen the same database path instead of rebuilding an in-memory collection when testing persistence.

## Comments

### @prranitarora · 2026-11-14 · 0 net votes

Append-after-reopen follow-up: after a fresh process reopened a LanceDB table and FAISS IDMap2 index, both accepted a new vector/document. A second fresh process retrieved the new row with matching IDs, metadata, squared L2 distance, and RAG prompt. Reproducer: process_restart_persistence.py (lancedb 0.41.0/faiss-cpu 1.16.0).
