MS Access 的良好免费替代品 [英] Good Free Alternative To MS Access

问题描述

考虑在 Microsoft 平台上开发轻量级桌面 DB 应用程序的需求.

Consider the need to develop a lightweight desktop DB application on the Microsoft platforms.

使用 MS Access 可以相当轻松地完成此操作，但我希望能够将其分发给其他人，而且我不想为运行时许可证付费.

It could be done fairly easily with MS Access but I'd like to be able to distribute it to others and I don't want to pay for a runtime license.

要求:

• 易于分发给他人
• 没有运行时许可问题

考虑因素和候选人:

• 基于 OpenOffice 套件.我担心的是它的稳定性.
• MySQL + 用 C++ 或 Python 或任何看起来相当笨拙的语言编写自定义数据库代码解决方案.

• Base from the OpenOffice suite. My concerns were around its stability.
• MySQL + writing custom DB code in C++ or Python or whatever seems like a rather heavy-handed solution.

问题:MS Access 的低成本或免费数据库替代品有哪些?

Question: What are the low cost or free database alternatives to MS Access?

另见: 开源报告引擎

@Schnapple

Bruceatk 有点符合我的想法；与其说是数据库引擎，不如说是我想要 Access 为聚会带来的其他好处.漂亮的表单设计器，漂亮的报告引擎等等.但是您确实提出了关于安装足迹的一个很好的观点.我已经考虑过这一点，但无论如何我还没有就我将要采取的方式做出任何坚定的决定.无论如何，它可能会是相当轻量级的东西，而且安装空间小肯定是一个加分项.

Bruceatk kind of hit on what I'm thinking of; it's not so much the DB engine as I want the other niceties that Access brings to the party. The nice form designer, the nice reporting engine etc. But you do raise a very good point about the installation footprint. I had considered that but I've not made any firm decisions about which way I'm going with this yet anyway. It'll probably be something fairly lightweight anyway and a small installation footprint would definitely be a plus.

@Remou，

不，我不知道 MS Access 2007 运行时是免费的；感谢您指出了这一点.上次我费心去调查它(我不记得是什么时候)我认为这是一个相当昂贵的运行时许可证，因为我认为他们正试图将其出售给公司 IT 部门.

No I was unaware that the MS Access 2007 runtime is free; thanks for pointing that out. The last time I'd bothered to investigate it (I don't remember when it was) I think it was a fairly expensive license for the runtime because I think they were trying to sell it to Corporate IT departments.

也感谢所有回复的人；我完全不知道你们指出的其他选项.

And thanks to everyone else who responded as well; I was completely unaware of those other options you all pointed out.

推荐答案

这里要记住的一件事是 MS Access 产品不仅仅是原始数据库引擎.它提供了一个完整的应用程序开发平台，包括表单和菜单设计器、客户端应用程序语言和环境 (VBA) 以及报表设计器.当你把所有这些东西放在一起时，MS Access 真的没有同行.

One thing to keep in mind here is the MS Access product is much more than just the raw database engine. It provides a full application development platform, including form and menu designer, client application language and environment (VBA), and report designer. When you take all those things together, MS Access really has no peer.

但是对于这个问题的范围，我们关心的是原始数据库引擎.考虑到这一点:

But for the scope of this question, we're concerned with the raw database engine. With that in mind:

SQLlite,
火鸟,
VistaDB(非免费)，
SQL Server Compact Edition(非 Express)
现在是 SQL Server LocalDB
都想到了.

SQLlite,
Firebird,
VistaDB (not free),
SQL Server Compact Edition (not Express)
and now SQL Server LocalDB
all come to mind.

另一个想法:虽然最初的问题确实询问了桌面数据库，但很可能有些人会在这里寻找与网站一起使用的数据库.重要的是要记住，这些都是进程中数据库，因此很少适合在网络上使用.如果您想构建一个网站，通常需要支持大量并发访问，您通常需要一个数据库服务器引擎，例如 MS SQL、Postgresql、MySQL、Oracle 或它们的兄弟.同时，那些服务器引擎很少适用于单用户桌面应用程序.

Another thought: while the original question does ask about desktop databases, its likely some people will land here looking for a database to use with a web site. It's important to remember that these are all in-process databases, and as such are rarely if ever appropriate for use on the web. If you want to build a web site, where it's common to need to support significant concurrent access, you generally want a database server engine, like MS SQL, Postgresql, MySQL, Oracle, or their brethren. At the same time, those server engines are rarely if ever appropriate for a single-user desktop application.

这篇关于MS Access 的良好免费替代品的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！