SQLite 可以支持多用户吗? [英] Can SQLite support multiple users?

问题描述

我正在尝试开发一个基于 Windows 的应用程序，多个用户同时访问同一个数据库.SQLite 可以一次支持多次访问吗?SQLite 在这方面稳定吗?是什么让 SQLite 比 MS SQL CE 更好或更差?

I am trying to develop a Windows based application with multiple users accessing the same database at the same time. Can SQLite support multiple accesses at one time? Is SQLite stable in this regard? What makes SQLite better or worse than MS SQL CE?

谢谢.

推荐答案

是的，SQLite 可以同时支持多个用户.然而，它在写入时会锁定整个数据库，因此如果您有大量并发写入，它不是您想要的数据库(通常数据库锁定的时间是几毫秒 - 因此对于大多数用途来说这无关紧要).但是它经过了很好的测试并且非常稳定(并且被广泛使用)，因此您可以信任它.

Yes SQLite can support multiple users at once. It does however lock the whole database when writing, so if you have lots of concurrent writes it is not the database you want (usually the time the database is locked is a few milliseconds - so for most uses this does not matter). But it is very well tested and very stable (and widely used) so you can trust it.

您可以阅读这个简短的文档以了解何时使用 SQLite 而不是:http://www.sqlite.org/whentouse.html

You may read this short document for information when to use SQLite and not: http://www.sqlite.org/whentouse.html

这篇关于SQLite 可以支持多用户吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！