Review how database connections work prior to 1.0

Currently each database gets three read connections and one write connection - that's four file handles even if it isn't being actively used.

We should investigate alternative patterns here, like connection pools or lazy connections, to help support many more connected databases.

This would enable neat tricks like datasette-agent having a scratch database for any conversation.