人们在 ASP.NET / ASP.NET MVC 云环境中使用哪些数据库?

发布于 2024-09-27 00:41:28 字数 1539 浏览 8 评论 0原文

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(5

〃温暖了心ぐ 2024-10-04 00:41:28

db4o 不是免费的,而且他们的许可很混乱,或者至少在我上次与他们交谈时是这样。结果,我就远离了。

不要忘记 Ayende & 的 RavenDB。全体人员。许可费用约为 700 美元,但他们表示将考虑免除初创公司的首次许可费。我一直在尝试它,我不得不说,这是一个令人印象深刻的 NoSQL 解决方案。它与 CouchDB 类似,但非常面向 .net,并且在 Couch 上有一些优点(imo)。

最后,如果您加入 Microsoft 的 BizSpark,他们将为您提供一些在 Azure 上的免费通话时间。很确定其中包含一些对 sql 的热爱。

干杯,祝你好运,伙计。

db4o isn't free and their licensing is chaotic, or at least was when I spoke with them last. As a result, I'd stay away.

Don't forget about RavenDB by Ayende & crew. The licensing is about $700 but they say that they will consider waiving the first license fee for startups. I've been dabbling around with it and I've got to say, it's quite impressive NoSQL solution. It's similar to CouchDB but very .net oriented with some one ups on Couch (imo).

Finally, if you join BizSpark by Microsoft, they will give you some free airtime on Azure. Pretty sure some sql love is included with it.

Cheers and good luck mate.

三岁铭 2024-10-04 00:41:28

这里是 SQL Azure。您不需要计算时间来使用数据库,它仅在您在 Azure 上运行应用程序时才存在。

Sql Azure here. You don't need the computing time to use the database, it only exists if you're running an application on Azure.

止于盛夏 2024-10-04 00:41:28
  • MySql 与 EF:到目前为止,我遇到的唯一真正问题是 MySql 连接器中运行时间很长的查询的错误/问题跟踪器的访问揭示了一种可以通过修改 + 编译连接器源代码来使用的解决方法。 ..直到修复进入下一个补丁。
  • db4o:这是在最近的一个项目中/我加入时已经就位了。目前有 2 个问题:
    • 它没有太多支持有效聚合数据。据我了解,这在 NoSql 中很常见/您只需对其使用不同的设计(至少我们已经这样做了)。
    • 您需要充分了解数据库和操作所涉及的各种模式。即使在很小的负载下,试图跳得太远也很容易导致性能问题。这更多的是一个学习曲线问题,使用正确的位会表现得很好。

我不得不承认,钱斯的回答让我有些担心。当我使用 db4o 加入该项目时,它已经就位,所以当时我没有考虑许可证注意事项。也就是说,我一直都知道您可以在网站上使用 GPL 代码。与此答案类似: https://stackoverflow.com/questions/94346/can-i-legally-incorporate-gpl-lgpl-open-sourced-software-in-a-proprietary-clo/94468#94468,如果你不分发你可以使用它。根据 Chance 发布的最后评论,我想说那里可能存在某种沟通问题。

  • MySql with EF: so far only real issue I've faced was a bug with a very long running query in the MySql connector / a trip to the issue tracker revealed a workaround that one could use by modifying + compiling the source of the connector ... just until the fix went into the next patch.
  • db4o: this is in a recent project / already in place when I joined. 2 issues so far:
    • It doesn't have much support to efficiently aggregate data. As I understand this is usual in NoSql / you just use a different design for it (at least that's what we have done and have worked).
    • You need to understand well the various modes involved for the database and the operations. Trying to jump too far ahead easily gets you into performance issues at even small loads. It's more a learning curve issue, using the right bits performs very well.

I have to admit that Chance answer worried me for a moment. When I joined the project with db4o it was already in place, so I didn't look at license considerations at the time. This said, I've always understood that you can use GPL code on web sites. Similar to this answer: https://stackoverflow.com/questions/94346/can-i-legally-incorporate-gpl-lgpl-open-sourced-software-in-a-proprietary-clo/94468#94468, if you don't distribute you can use it. Based on the last comment posted by Chance, I'd say it's likely there was some sort of communication issue there.

や三分注定 2024-10-04 00:41:28

orcsweb.com 提供云服务器,每月 99 美元。考虑到我为虚拟服务器支付了 300 美元,这真是一笔不错的交易。

orcsweb.com 的与众不同之处在于他们的技术服务。他们以每月 124 美元的价格在服务器上提供完全托管的服务。

因此,每月 223 美元,我就可以得到这一切,而不必担心所有客户的服务器问题。

免费提供数据库:sql express 2005 或 2008。这听起来足以满足您的初始要求。我们在此运行完整的电子商务目录,这很好。如果网站不断增长,那么这对您来说是个好消息,您有能力支付 sql server 许可证的费用。

如果这听起来像是 orcsweb 的插件,那么确实如此,但我没有从中得到任何东西......我们从他们那里得到了很好的服务。我的工作是编写应用程序,而不是运行服务器。我们有大约 30 个客户,我们将所有客户托管在我们的 orcsweb 一个帐户上。每位客户的费用为 7 美元。不可能是坏事。

编辑:

重要!!:

请注意,上述价格适用于 Web 服务器。它托管任意数量的网站,并安装了 SQL Express。

我可能误解了这个问题,但答案仍然有效,因为 SQL Express 将在早期阶段运行您的应用程序。

orcsweb.com offer cloud servers for US$99 per month. Pretty good deal considering that I was paying US$300 to them for a virtual server.

The thing that sets orcsweb.com apart is their technical service. For US$124 per month, they provide a fully managed service on the server.

So for US$223 per month, I get it all and don't have to worry about the server for all my clients.

Database is thrown in for free: sql express 2005 or 2008. This sounds enough for your initial requirements. We run full blown eCommerce catalogues on this and it is fine. If the website grows, well then you that is good news and you can afford to pay for a sql server licence.

If this sounds like a plug for orcsweb, it is, but I don't get anything out of it... We have had great service from them. My job is to write apps, not run a server. We have about 30 clients and we host them all on our one account with orcsweb. That works out a US$7 per client. Can't be bad.

EDIT:

Important!!:

Please note that the above prices are for a Web Server. It host any number of websites and has a SQL Express installation thrown in.

I may have misunderstood the question, but the answer is still valid because the SQL Express will run your app in its early stages.

雨轻弹 2024-10-04 00:41:28

不确定您要处理多少数据,但 SQL Express sku 是一个选项吗?它们可以处理网络应用程序应该对数据执行的任何操作,同时具有合适的价格点和简单的升级路径。

如果做不到这一点,我会选择 nosql 选项,因为现在这似乎更有意义,而且它的设计考虑到了云。

Not sure how much data you are dealing with, but are the SQL Express skus an option? They can handle just about anything a web app should be doing with the data while being at the right price point and an easy upgrade path.

Failing that, I'd go with the nosql option as that seems to make quite a bit more sense these days and its designed with the cloud in mind.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文