VistaDB有什么优点
多年来我看到过有关 VistaDB 的参考资料以及 SQLite、Firebird、MS SQL 等工具。 等人。 我从来没有理由考虑它。
与使用其他技术相比，支付 VistaDB 的优势是什么？ 我想到的事情：
1. 紧凑框架支持。 SQLite+MSSQL支持CF。
2. 需要迁移到“更强大”系统的路径。 火鸟+MSSQL。
3. 需要触发器等更高级的功能。 火鸟+MSSQL
I have seen the references to VistaDB over the years and with tools like SQLite, Firebird, MS SQL et. al. I have never had a reason to consider it.
What are the benefits of paying for VistaDB vs using another technology? Things I have thought of:
1. Compact Framework Support. SQLite+MSSQL support the CF.
2. Need migration path to a 'more robust' system. Firebird+MSSQL.
3. Need more advanced features such as triggers. Firebird+MSSQL
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
我以前没见过 VistaDB，它看起来确实很酷。
更新：收到来自 VistaDB 某人的评论 - 他们的更新模型仅用于获取新版本。 即使您的许可证过期，您的旧许可证也不会停止工作，这一点很高兴知道。
恕我直言，将原始帖子保留在这里，有关软件许可证过期的警告仍然值得考虑，尽管 VistaDB 本身很好。
它看起来确实比 SQLite“更有功能”，但我没有看到任何东西可以证明其成本是合理的。 该网站似乎表明您可以花费 279 美元购买一个许可证，但这意味着这只是 1 年的订阅。 明年您是否还需要再支付 279 美元才能阻止您的网站崩溃？
如果是这样，请记住考虑“成本”，当您在凌晨 3 点（墨菲定律，总是凌晨 3 点）接到惊慌失措的客户打来的电话时，会带来多少不便，因为他们的 VistaDB 许可证已过期:-(
我已经对于某些即将到期的软件，这种体验绝对不好，您可以向客户发送电子邮件和消息，然后让他们的整个屏幕闪烁红色，说“您需要在下周之前获得新的许可证”，但他们仍然不会这样做，凌晨 3 点，当它到期时，你仍然会感到疼痛。
I hadn't seen VistaDB before, it does look pretty cool.
Update: Received a comment from someone from VistaDB - their update model is only for getting new versions. Your old ones won't stop working if your license expires, which is good to know.
Keeping the original post here as IMHO the warning about expiring software licenses is still worth thinking about, even though VistaDB itself is fine.
It definitely seems 'more featureful' than SQLite, but I don't see anything there to justify the cost. The site seems to indicate that you can buy one license for $279, but it implies this is just a 1 year subscription. Would you have to then pay another $279 next year to stop your site falling over?
If so, remember to factor into the 'cost' how much inconvenience it's going to be when you get a call at 3am (murphy's law, it's always 3am) from your panicking customers because their VistaDB license has expired :-(
I've had this experience personally with some expiring software, and it's never good. You can send your customers emails and messages and flash their entire screen blinking red saying "YOU NEED TO GET A NEW LICENSE BEFORE NEXT WEEK" and they'll still never do it, and you'll still get the pain at 3am when it does expire.
对我来说，VistaDB 最有趣的功能是它可以在中等信任环境中运行。 这使得它成为创建中小型 .NET 网站的完美解决方案，可以通过复制和粘贴（x-copy 部署）将其部署在服务器上。
几乎所有 Windows 共享托管提供商（例如 GoDaddy）都不会让您在完全信任模式下运行网站。 例如，如果您希望使用 SQLite，也不会为您将任何第三方二进制文件安装到 GAC 中，例如 System.Data.SQLite.dll。
For me this most interesting feature of VistaDB is that it can be run in Medium Trust environment. Which makes it perfect solution for creating small to medium .NET websites which can be deployed on server by copying and pasting (x-copy deployment).
And almost all windows shared hosting providers (like GoDaddy) won't let you run your websites in Full Trust mode. And also won't install for you any 3rd party binaries into GAC like System.Data.SQLite.dll if you wish to use SQLite for example.
嗯，最重要的是它是纯粹的托管代码 - 就其价值而言； 它不仅适用于运行 .NET 的典型 Windows 计算机，而且适用于任何运行 Compact Framework 的地方，甚至适用于 <强>单声道。 以下是他们主页上一些值得注意的要点：
值得注意的是，Rob Howard 的公司 telligent 使用它作为默认数据库他们的新 CMS 软件“Graffiti”。
我到处都用过它，但还没有建立任何对抗它的东西。
Well, the main thing is that it is pure managed code - for what that is worth; it works not only on your typical Windows machines running .NET, but works wherever you run the Compact Framework and even works on Mono. Here are some noteworthy bullet points from their homepage:
One thing worth noting is that Rob Howard's company, telligent, uses it as the default database for their new CMS software, "Graffiti."
I have played with it here and there but have yet to build anything against it.
VistaDB 客户端运行时是免费的。 正如您所说，运行时永远不会“凌晨 3 点到期”。 只有开发人员工具才能以这种方式获得许可。 每个开发人员需要 1 个许可证，很简单。 我们甚至提供了非常便宜的 Lite 版本，没有 Visual Studio 工具。
其他一些好处
100% 托管代码 - 引擎中没有互操作或其他非托管调用。 这对一些人来说是件大事，而另一些人则不在乎。
不需要注册表访问 - 大多数其他 in proc 数据库都需要注册表访问来查找父控件或权限。 VistaDB 只做您告诉它做的事情，甚至会在中等信任度下运行。
用于运行时和数据库的XCopy部署（单个文件）。 您可以复制应用程序、运行时和数据库并运行。 无需在计算机上安装或配置任何内容，无需特殊权限（我们可以在中等信任或更高级别下运行）。
隔离存储 - 您可以将整个数据库放入隔离存储中并直接从那里运行。 这使得构建安全的单击一次应用程序变得非常容易，这些应用程序以适合企业环境的域友好方式编写数据库。 无需将用户数据存储在共享驱动器上或担心权限映射。
CLR 触发器/CLR 过程 - 您可以编写 CLR 代码并将它们用作触发器或存储过程。 我们最近刚刚引入了一些更改，使维护可以在 VistaDB 和 SQL Server 2005/2008 中运行的单个 CLR 程序集变得更加容易。
T-SQL 过程 - VistaDB T-SQL 过程与 SQL Server 2005/2008 兼容。 任何在我们的引擎中运行的过程都将在 SQL Server 中运行。 这并不意味着在那里运行的任何东西都会移植到我们身上。 我们是 SQL Server 功能的子集。 但我们也是在没有 SQL Server 的情况下运行 T-SQL Procs 的唯一方法（SQL CE 做不到）。
我个人认为最大的功能之一是能够稍后升级到 SQL Server。 所有 VistaDB 类型、语法以及 CLR 过程、T-SQL 过程等都将在 SQL Server 上运行。 （不过，您不能将 SQL Server 中的所有内容都移植到 VistaDB，它只是一个子集）
32/64 位部署 - VistaDB 是单个程序集部署，无需更改即可运行 32 位和 64 位。 SQL CE 根据操作系统需要两个不同的运行时，并且根本无法在 IIS 下运行。
Access没有64位运行时，最新的32位运行时只能通过MSI部署。 32 位版本的 Windows 有运行时，64 位版本没有。关系完整性 - VistaDB 实际上还强制执行您的约束和外键。 可以进行具体的级联更新、删除操作。 评论我们就像 SQLITE 的人在这方面是错误的。 他们解析约束，但不强制执行它们。
编辑：他们现在在 SQLite 中支持 FK。 但它们默认情况下不会被编译，并且不使用与 SQL Server 相同的语法。
中等信任 - 在中等信任 Web 服务器上运行的能力是许多人不会关心的另一个功能，但它很重要。 许多第三方控件甚至无法在中等信任中运行。 由于我们致力于 100% 托管代码和最少的权限要求，我们可以在 Medium Trust 中运行完整的引擎。
- 完全披露- 我是 VistaDB 的所有者，所以我可能有偏见。 :)
The VistaDB client runtime is free. The runtime will never "expire at 3am" as you put it. Only the developer tools are licensed in that manner. You need 1 license per developer, simple. We even offer a really inexpensive Lite version with no Visual Studio tools.
Some other benefits
100% managed code - there are no interop or other unmanaged calls in the engine. This is a big deal to some, and others couldn't care less.
No registry access required - Most other in proc databases require registry access to look for parent controls, or permissions. VistaDB only does what you tell it to do, and will even run in Medium Trust.
XCopy deployment for runtime and your database (single file). You can xcopy you application, the runtime, and your database and run. Nothing to install or configure on the machine, no special privileges needed (we can run in Medium Trust or higher).
Isolated storage - You can put your entire database into Isolated Storage and run it from there directly. This makes it very easy to build secure click once applications that write databases in a domain friendly way for corporate environments. There is no need to store the user data on a shared drive or worry about permission mapping.
CLR Triggers / CLR Procs - You can write CLR Code and use them as Triggers or Stored Procs. We have just recently introduced changes to make it even easier to maintain a single CLR Assembly that can run in both VistaDB and SQL Server 2005/2008.
T-SQL Procs - VistaDB T-SQL Procs are compatible with SQL Server 2005/2008. Any procedure that works in our engine will run in SQL Server. That does not mean anything that runs there will port to us. We are a subset of the functionality in SQL Server. But we are also the only way to run T-SQL Procs without SQL Server (SQL CE can't do it).
I personally think one of the biggest features is the ability to upsize to SQL Server later. All of the VistaDB types, syntax, and CLR Procs, T-SQL procs, etc all will run on SQL Server. (You can't take everything from SQL Server down to VistaDB though, it is a subset)
32/64 bit Deployment - VistaDB is a single assembly deployment that runs both 32 and 64 bit without changes. SQL CE requires two different runtimes depending upon the OS, and cannot run under IIS at all.
Access has no 64 bit runtime, and the most recent 32 bit runtime can only be deployed through MSI. The 32 bit version of Windows has the runtime, the 64 bit version does not.Relational Integrity - VistaDB also actually enforces your constraints and Foreign Keys. You can specific cascade update, and delete operations. The person who commented we are like SQLITE is wrong in this regard. They parse constraints, but do not enforce them.
EDIT: They do have support for FK's now in SQLite. But they are not compiled in by default, and do not use the same syntax as SQL Server.
Medium Trust - The ability to run on a medium trust web server is another feature that many will not care about, but it is a big deal. Many third party controls can't even run in Medium Trust. We can run the complete engine within Medium Trust because of our commitment to 100% managed code and least permission required.
- Full disclosure - I am the owner of VistaDB so I may be biased. :)