SQLite的/火鸟：有没有人支持多个并发写访问？ [英] SQlite/Firebird: Does any of them support multiple concurrent write access?

问题描述

问：我目前存储在XML文件中ASP.net应用程序数据。

Question: I currently store ASP.net application data in XML files.

现在的问题是，我有异步操作，这意味着我跑进一个XML文件...

Now the problem is I have asynchronous operations, which means I ran into the problem of simultanous write access on a XML file...

现在，我考虑转移到嵌入式数据库来解决这个问题。
我目前正在考虑SQLite和嵌入式火鸟。

Now, I'm considering moving to an embedded database to solve the issue. I'm currently considering SQlite and embeddable Firebird.

我不知道但是如果SQLite的火鸟或者可以处理多个并发写访问。

我当然不想再有同样的问题。

任何人都知道？

SQLite的肯定是更好地了解，但哪一个更好 - SQLite的火鸟还是？我倾向于说火鸟，但我真的不知道。

I'm not sure however if SQlite or Firebird can handle multiple concurrent write access.
And I certainly don't want the same problem again.
Anybody knows ?
SQlite certainly is better known, but which one is better - SQlite or Firebird ? I tend to say Firebird, but I don't really know.

没有MS-Access或MS-SQL-EX preSS recommodations请，我是一个理智的人。

No MS-Access or MS-SQL-express recommodations please, I'm a sane person.

推荐答案

我无线本地环路选择火鸟的原因很多，为此太

I wll choose Firebird for many reasons and for this too

虽然是事务性的，SQLite的
  不支持并发
  交易，因此，如果您的嵌入式
  应用程序需要两个或更多的
  连接，它们必须序列化。
  嵌入式Firebird数据库是
  简单升级到完全共享
  数据库 - 只是改变共享
  库。

Although it is transactional, SQLite does not support concurrent transactions, so if your embedded application needs two or more connections, they must be serialized. An embedded Firebird database is simple to upgrade to a fully shared database - just change the shared library.

可能是你还可以检查这

这篇关于SQLite的/火鸟：有没有人支持多个并发写访问？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！