哪个嵌入式数据库具有最大SQL合规性，并发支持？ [英] Which embedded database has maximum SQL compliance, and concurrency support?

问题描述

目前我的应用程序使用Microsoft Access，但现在可能托管在Linux机器上。此外，当从多个计算机访问时，其中一个可以更新记录（当其被其他用户读取时）。

我还要求嵌入式数据库应该支持复杂

我尝试了 SQLite ，但许多现有的查询失败，或需要固定（像在一个简单的查询使用内部连接括号后FROM是不能接受的SQLite，并不得不删除）。不支持右连接。

我来了解 Apache Derby 和 H2 ，但首先希望您的宝贵意见。

编辑：

我忘了提及我的应用程式

在预设我使用Microsoft Access mdb，

更新

我做了Firebird的试验，它确实看起来非常好，零管理和SQL兼容。它是快速，我在任何典型的查询我没有问题，我可以尝试。我非常满意，希望它可以用于我提出这个问题的项目。

希望Advantage Server太好了，但不能得到时间审查它。

解决方案

我认为这是 Firebird 。

甚至 Cte's ！

Firebird支持Windows，Linux， Mac OS ...

Jaybird 驱动程序。

从Access到Firebird有一些很好的迁移工具：

• IBDatapump


• Microsoft访问Firebird数据库转换器（ MDB2FDB ） ）

My application at present uses Microsoft Access, but now may be hosted on Linux boxes. Additionally while being accessed from multiple computers, one of these may update the records (when its being read by other users).

I also require that the embedded database should support complex SQL queries - like inner SQL, Joins, etc.

I tried SQLite, but many of the existing queries fail, or need to be fixed (like in a simple query using inner join the brackets after FROM was not acceptable to SQLite, and had to be removed). Right join too is not supported.

I came to know about Apache Derby and H2, but would first prefer your valuable opinion.

Edit:

I forgot to mention that my application is entirely written in Java.

Edit:

At preset I use Microsoft Access mdb, shared on network drive, making DSN-less connection from remote computers.

Update

I did trials with Firebird, and it really does seem very good, zero admin, and SQL compliant. It is fast, and I had no problems in any of the typical queries I could try on it. I am very satisfied with it, and hopefully will use it for the project for which I raised this question.

Hopefully Advantage Server too will be good, but could not get time to review it. After reviewing/using Firebird do not feel any need to try anything else.

解决方案

I think it's Firebird.

Even Cte's are supported in Firebird 2.1 !

Firebird works on Windows, Linux, Mac OS...

Jaybird driver for Java.

There are some good migration tools from Access to Firebird:

• IBDatapump
• Microsoft Access to Firebird database converter (MDB2FDB)

这篇关于哪个嵌入式数据库具有最大SQL合规性，并发支持？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！