生产环境中的 python 和 SQLite

Question

当使用 python 时，SQLite 是否可以用作生产数据库来管理 10,000 个数据库文件(每个文件都在一个单独的文件中 -- 大小为 500[MB])？

只有一个线程将用于将数据写入数据库文件(无并发)。

是否有可以更好/更快/更可靠地工作的替代库？

Answer 1

也许你会看看this page标题为“sqlite 的适当用途”。引用:

The basic rule of thumb for when it is appropriate to use SQLite is this: Use SQLite in situations where simplicity of administration, implementation, and maintenance are more important than the countless complex features that enterprise database engines provide. As it turns out, situations where simplicity is the better choice are more common than many people realize.

Another way to look at SQLite is this: SQLite is not designed to replace Oracle. It is designed to replace fopen().