There's a limit on how many databases you can attach to the same connection (SQL... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		simonw on April 9, 2024 \| parent \| context \| favorite \| on: Distributed SQLite: Paradigm shift or hype? There's a limit on how many databases you can attach to the same connection (SQLITE_LIMIT_ATTACHED), it defaults to 10.

samatman on April 9, 2024 [–]

Worth noting that this limit can be raised up to 125 (as I'm sure Simon is aware).

I would say that if one needs to query across more SQLite files than that, it's definitely time for a different data policy.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact