You'll probably hit file descriptor limits so you'll need to up those. There's also some memory overhead per connection. I'd recommend limiting the number of concurrent connections on a server if you're running on a resource constrained box. In practice, you probably won't have all thousand databases querying at the same time and reopening SQLite connections is pretty fast.