IM-Chat应用程序的最佳数据库选择 [英] Best database choose for a IM-Chat application

问题描述

每个人，关于数据库我都是一个新手，我知道非常基本的命令(插入删除等)，但是我想要的是一个具有高int/id限制的数据库(很可能有很多这样的数据库，永远不会达到一个溢出")，它可以容纳较大的字符串(超过10k个字符将是个好主意)，该字符串还支持大量的特殊"字符(中文，日文，韩文等)图像，这些图像可能是二进制数据?和日期时间.目前，我使用的SDF数据库具有一些我需要的非常基本的东西，但是我不能拥有超过4000个字符的字符串，并且只能容纳99.999.999个条目/id，并且它没有日期时间或可悲的图像输入:(

我一直在寻找C#中的MDF数据库，但它们似乎也像SDF一样有4000的字符串限制，否则似乎很适合我的需求，但是我想在这里听听是否有其他替代方法可能对我有用.如果我能避免的话，我宁愿选择一个非独立的数据库，例如我相信mysql是?另外，如果有可能可以链接到我如何在C#应用程序内部连接到数据库，那么如果可以对数据库进行加密和解密也很好.

总结一下我应该使用哪个数据库进行IM聊天，它既可以包含大量条目(很可能永远无法/将无法访问)，也可以包含大型字符串(首选10000个字符以上)，并且具有来自全世界"的最特殊字符，图片和日期时间参数?我也很想如果我能得到一些简单的代码，就可以在我的服务器应用程序中运行，而不是在其自己的cosole/数据库程序中运行，并且我可以加密/解密自己选择的选定表格.

希望很快能看到一些有用的评论，感谢您的阅读和帮助:)

-Jackie

Hi every one i am kinda new when it comes to databases i know the very basic commands (insert delete etc.) but what i want is a database that have a high int/id limit (most likely so many that it "never" can reach a "overflow") that can hold large strings (over 10k chars would be great) that also supports a large amount of "special" chars (Chinese, Japanese, Korean and so on) images some how maybe as binary data? and datetime. at the moment am i using a SDF database that have some of the very basics stuff to my needs, but i cant have strings longer than 4000 chars and can only hold 99.999.999 entries/id''s and it does not have a datetime or image entry sadly :(

i''ve been looking abit into MDF databases in C# but they seems to have a string limit at 4000 also as SDF otherwise it seems to suit my needs but i wanna hear in here if there is some other alternatives that could be usefull for me. also if i can avoid it i would prefer a non-stand alone database such as i belive mysql is?. also if it is possible some link to how i can connect to the database inside my C# app would be nice and if the database can be encrypted and decrypted it would be nice too.

so to summarize; what database should i use for a IM-chat, that can both contains large amount of entries that most likely never can/will be reached, large strings (over 10000 char is prefer) and have the most special chars from "all the world", images, and datetime parameters? also i would love if i could get some simple code, it is possible to run inside my server app and not in its own cosole/database program, and i can encrypt/decrypt selected tabels of my own choose.

hope to see some helpful comment soon thanks for reading and helping :)

- Jackie

推荐答案

你问了很多问题，

首先，我也有我的IM应用程序.我选择了 MySQL 作为数据库. MySQL 的原因太多.

我会更喜欢 MySQL ，因为它对于满足您的所有需求将很有用.甚至 MS-SQL 也不错，但是我对您要问的所有功能都不太了解.

当您处理大型数据库时，还需要对像应用程序这样的IM使用集群.

希望对您有帮助，

谢谢
-amit.

Hi,

you ask so many questions,

First of all i also do have my IM application. i have chosen MySQL as database. there are so many reasons for MySQL.

i will prefer you MySQL because it will be useful for achieving all your need. even MS-SQL is also good but i do not have much idea about all the features you are asking about.

when you are dealing with large database, you also need to use clustering for IM like application.

hope this will help you,

thanks
-amit.

这是为什么使用MySQL的证明

希望这会帮助您在 MySQL 和 MSSQL
之间进行选择
谢谢
-amit.

Hi,

here is the proof why MySQL?

hope this will help you more for choice between MySQL and MSSQL

thanks
-amit.

检查一下.

http://www.inc.com/guides/2010/10/how-to-select-the-best-database-software.html [

Check this out.

http://www.inc.com/guides/2010/10/how-to-select-the-best-database-software.html[^]

Regards,
Eduard

这篇关于IM-Chat应用程序的最佳数据库选择的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！