I am working on an open source project which can use a number of DBMS' as backend. So far we supports SQL Server 2005 and SQL Server 2008 but we would also like to support some additional databases including some file based DBs.
我正在开发一个可以使用大量DBMS作为后端的开源项目。到目前为止,我们支持SQL Server 2005和SQL Server 2008,但我们还希望支持一些其他数据库,包括一些基于文件的数据库。
Note: The file based databases must work on a 64-bit platform, so MS Access is not an option as there is no 64-bit provider AFAIK.
注意:基于文件的数据库必须在64位平台上运行,因此MS Access不是一个选项,因为没有64位提供程序AFAIK。
Which DBMS should a database centric open source project support in your opinion?
您认为哪个DBMS应该以数据库为中心的开源项目支持?
6 个解决方案
#2
Provide ODBC support, then the end-user can choose from just about any database going.
提供ODBC支持,然后最终用户可以选择几乎任何数据库。
#3
Firebird, either in its embedded variant or as a (small footprint) server.
Firebird,无论是嵌入式变体还是(小占用空间)服务器。
#4
MySQL, it's a widely used free/open source RDBMS.
MySQL,它是一种广泛使用的免费/开源RDBMS。
Not a file based DBMS, but you didn't say it had to be, only that you wanted a few of those too.
不是基于文件的DBMS,但你没有说它必须是,只是你也想要一些。
#5
Support these: sqlite,mysql,postgresql
支持这些:sqlite,mysql,postgresql
You don't mention what language you're developing in. Some, like Java, have standard database APIs, so supporting multiple SQL servers is easy, provided you can use the common denominator of the SQL language in your application.
您没有提到您正在开发的语言。有些语言(如Java)具有标准数据库API,因此只需在应用程序中使用SQL语言的公分母即可轻松支持多个SQL服务器。
#6
I agree that firebird can be better than SQL Lite and M$SQL Express , or even is better than mysql , scales better with the number of CPUS and is more mature (triggers , and transactions are implemented for many many light years ago)
我同意firebird可以比SQL Lite和M $ SQL Express更好,甚至比mysql更好,随着CPUS的数量更好地扩展并且更成熟(触发器,并且交易是在许多光年前实现的)
#1
SQLite, definitely.
#2
Provide ODBC support, then the end-user can choose from just about any database going.
提供ODBC支持,然后最终用户可以选择几乎任何数据库。
#3
Firebird, either in its embedded variant or as a (small footprint) server.
Firebird,无论是嵌入式变体还是(小占用空间)服务器。
#4
MySQL, it's a widely used free/open source RDBMS.
MySQL,它是一种广泛使用的免费/开源RDBMS。
Not a file based DBMS, but you didn't say it had to be, only that you wanted a few of those too.
不是基于文件的DBMS,但你没有说它必须是,只是你也想要一些。
#5
Support these: sqlite,mysql,postgresql
支持这些:sqlite,mysql,postgresql
You don't mention what language you're developing in. Some, like Java, have standard database APIs, so supporting multiple SQL servers is easy, provided you can use the common denominator of the SQL language in your application.
您没有提到您正在开发的语言。有些语言(如Java)具有标准数据库API,因此只需在应用程序中使用SQL语言的公分母即可轻松支持多个SQL服务器。
#6
I agree that firebird can be better than SQL Lite and M$SQL Express , or even is better than mysql , scales better with the number of CPUS and is more mature (triggers , and transactions are implemented for many many light years ago)
我同意firebird可以比SQL Lite和M $ SQL Express更好,甚至比mysql更好,随着CPUS的数量更好地扩展并且更成熟(触发器,并且交易是在许多光年前实现的)