我正在编写一个数据驱动的应用程序，它刚刚完成，但是我没有决定如何存储数据。 我'我正在寻找某种形式的数据库。要求： 易于分发，希望只是一些硬盘文件。 查询相对较快。 我认为在这种情况下，速度是最终的易用性 用户。虽然速度总是很重要，这就是为什么我不会使用 xml :) 数据*不应该*大于1GB（它不应该更多比一个几百兆的b $ b，但我想要扩展空间。 我的选择： 1）访问：易于使用，作为独立文件分发。 但是我必须出去买一份办公室:( 2）SQLite，从不使用它，今天刚刚听说它，开始现在就读它关于它的，看起来它的工作方式类似于访问 （至少来自外面），不知道速度如何。 3）SQL Server Express：免费下载，免费重新发布，免费 嵌入根据微软的说法。 这似乎是一个非常好的选择，一个免费的SQLServer似乎就好了。 会非常灵活和快速。但我担心如何轻松地用编程分发？是否有任何潜在用户 必须下载sql server express app？或几个运行时 文件？或什么都没有？ 4）填空。还有其他任何建议吗？ 意见表示欢迎和赞赏。
I''m writing a data driven app, its all just about finished but i havent decided how to store the data. I''m looking at some form of database. Requirements: Easy to Distribute, hopefully just some hard disk files. Relatively quick to query. I think in this case, speed is secondary to ease of use for the end user. Although speed is always important, which is why i wont be using xml :) Data *shouldnt* get any bigger than 1GB (it shouldnt get more than a few hundred meg but i''d like room for expansion). My choices: 1) Access: Easy to use, distributes as stand alone files. But then i''d have to go out and buy a copy of office :( 2) SQLite, never used it, oonly just heard of it today, starting to read up about it now, seems like it will work similarly to access (from the outside at least), dont know how the speed is though. 3) SQL Server Express: "Free to download, free to redistribute, free to embed" according to microsoft. It seems like a really good option, a free SQLServer seems like it would be incredibly flexible and fast. But I am concerned about how easy it would be to distribute with a prog? Will any potential users have to download the sql server express app? or a couple of run-time files? or nothing? 4) Fill in the blanks. Any other suggestions? Opinions welcomed and appreciated.
推荐答案JB， 就个人而言，我会使用SQL Server Express。你必须为它安装 的安装程序（我相信有一个MSI，你可以用你的应用程序分发），鉴于其好处超过安装 问题。 - - Nicholas Paldino [.NET / C＃MVP] - mv*@spam.guard.caspershouse " JB" < ja ******* @ gmail写信息 新闻：11 ********************** @ 22g2000hsm.googlegro ups ... JB, Personally, I would go with SQL Server Express. You would have to run the install program for it (I believe there is an MSI that you can distribute with your app), which, given the benefits outweigh the install issue. -- - Nicholas Paldino [.NET/C# MVP] - mv*@spam.guard.caspershouse "JB" <ja*******@gmailwrote in message news:11**********************@22g2000hsm.googlegro ups... 我正在编写一个数据驱动的应用程序，它刚刚完成但是我已经完成了b 还没有决定如何存储数据。 我正在寻找某种形式的数据库。要求： 易于分发，希望只是一些硬盘文件。 查询相对较快。 我认为在这种情况下，速度是最终的易用性 用户。虽然速度总是很重要，这就是为什么我不会使用 xml :) 数据*不应该*大于1GB（它不应该更多比一个几百兆的b $ b，但我想要扩展空间。 我的选择： 1）访问：易于使用，作为独立文件分发。 但是我必须出去买一份办公室:( 2）SQLite，从不使用它，今天刚刚听说它，开始现在就读它关于它的，看起来它的工作方式类似于访问 （至少来自外面），不知道速度如何。 3）SQL Server Express：免费下载，免费重新发布，免费 嵌入根据微软的说法。 这似乎是一个非常好的选择，一个免费的SQLServer似乎就好了。 会非常灵活和快速。但我担心如何轻松地用编程分发？是否有任何潜在用户 必须下载sql server express app？或几个运行时 文件？或什么都没有？ 4）填空。还有其他建议吗？ 意见表示欢迎和赞赏。 I''m writing a data driven app, its all just about finished but i havent decided how to store the data. I''m looking at some form of database. Requirements: Easy to Distribute, hopefully just some hard disk files. Relatively quick to query. I think in this case, speed is secondary to ease of use for the end user. Although speed is always important, which is why i wont be using xml :) Data *shouldnt* get any bigger than 1GB (it shouldnt get more than a few hundred meg but i''d like room for expansion). My choices: 1) Access: Easy to use, distributes as stand alone files. But then i''d have to go out and buy a copy of office :( 2) SQLite, never used it, oonly just heard of it today, starting to read up about it now, seems like it will work similarly to access (from the outside at least), dont know how the speed is though. 3) SQL Server Express: "Free to download, free to redistribute, free to embed" according to microsoft. It seems like a really good option, a free SQLServer seems like it would be incredibly flexible and fast. But I am concerned about how easy it would be to distribute with a prog? Will any potential users have to download the sql server express app? or a couple of run-time files? or nothing? 4) Fill in the blanks. Any other suggestions? Opinions welcomed and appreciated.
2007年7月23日星期一13:10:08 -0700，JB< ja ******* @ gmailwrote： On Mon, 23 Jul 2007 13:10:08 -0700, JB <ja*******@gmailwrote: >我正在写一个数据驱动应用程序，它刚刚完成，但我还没有决定如何存储数据。 我正在寻找某种形式的数据库。要求：易于分发，希望只是一些硬盘文件。查询相对较快。我认为在这种情况下，速度是次要的易用性到底用户。虽然速度总是很重要，这就是为什么我不会使用 xml :) 数据*不应该大于1GB（它不应该超过几百）但是我想要扩展空间。 我的选择： 1）访问：易于使用，作为独立文件分发。然后我'' d必须出去买一份办公室副本:( 2）SQLite，从未使用它，今天只是听说过它，现在就开始阅读它，好像它会起作用访问（至少从外面），不知道速度如何。 3）SQL Server Express：免费下载，免费重新分发，免费嵌入根据微软的说法。这似乎是一个非常好的选择，免费的SQLServer似乎会非常灵活和快速。但我担心如何轻松地用编程分发？任何潜在用户都必须下载sql server express app吗？或几个运行时文件？或什么都没有？ 4）填空。还有其他建议吗？ 意见表示欢迎和赞赏。 >I''m writing a data driven app, its all just about finished but ihavent decided how to store the data.I''m looking at some form of database. Requirements:Easy to Distribute, hopefully just some hard disk files.Relatively quick to query.I think in this case, speed is secondary to ease of use for the enduser. Although speed is always important, which is why i wont be usingxml :)Data *shouldnt* get any bigger than 1GB (it shouldnt get more than afew hundred meg but i''d like room for expansion).My choices:1) Access: Easy to use, distributes as stand alone files.But then i''d have to go out and buy a copy of office :(2) SQLite, never used it, oonly just heard of it today, starting toread up about it now, seems like it will work similarly to access(from the outside at least), dont know how the speed is though.3) SQL Server Express: "Free to download, free to redistribute, freeto embed" according to microsoft.It seems like a really good option, a free SQLServer seems like itwould be incredibly flexible and fast. But I am concerned about howeasy it would be to distribute with a prog? Will any potential usershave to download the sql server express app? or a couple of run-timefiles? or nothing?4) Fill in the blanks. Any other suggestions?Opinions welcomed and appreciated.
嗨 SQL Server将是恕我直言的最佳选择。这听起来非常适合您的b $ b b要求，并且使用高级版本（也是免费的），您可以获得全文搜索和其他SQL Sqerver功能。数据库的大小可以达到4GB左右。 它可以使用ClickOnce技术进行部署，因此你不应该没有问题问题与您的应用分发。您可能需要阅读此内容 msdn2.microsoft/en-us/library/Bb264562.aspx HTH 干杯 Steve
Hi SQL Server would be the best choice IMHO. It sounds perfect for your requirments and with the advanced version (also free) you can have full text searching and other SQL Sqerver features. Databases can be up to 4gb in size. It can be deployed using ClickOnce technology so you should have no problems distributing it with your app. You might want to read this msdn2.microsoft/en-us/library/Bb264562.aspx HTH Cheers Steve
干杯， SQL Express确实看起来很棒，但我还是有一些 问题。 安装程序有多大？ SQL Server快递MS网站 大约40MB，最终用户是否需要完整的东西？ 我的应用程序目前编译为3MB左右，它可能 结束时上下移动。 我讨厌安装一个40mb sql server的< 5mb程序。 相反，我可以只包含一个500kb的空白访问.mdb文件。 如果安装程序只是一个或两个兆，那么它将是理想的 7月23日21:19，Nicholas Paldino [.NET / C＃MVP] spam.guard.caspershousewrote： Cheers, SQL Express does look pretty amazing, but i have still have some issues. How big would the installer be? SQL Server express off the MS website is around 40MB, would the full thing be required for an end user? My app at the moment compiles to around 3MB, it may go up or down when its finished. I''d hate to have a <5mb program with a 40mb sql server install. Where instead i could just include a 500kb blank access .mdb file. If the installer were only a meg or two then it would be the ideal solution. On 23 Jul, 21:19, "Nicholas Paldino [.NET/C# MVP]" <m...@spam.guard.caspershousewrote: JB， 就个人而言，我会选择SQL Server Express。你必须为它安装 的安装程序（我相信有一个MSI，你可以用你的应用程序分发），鉴于其好处超过安装 问题。 - - Nicholas Paldino [.NET / C＃MVP] - m ... @ spam.guard.caspershouse " JB" < jamesb ... @ gmail写信息 新闻：11 ********************** @ 22g2000hsm.googlegro ups ... JB, Personally, I would go with SQL Server Express. You would have to run the install program for it (I believe there is an MSI that you can distribute with your app), which, given the benefits outweigh the install issue. -- - Nicholas Paldino [.NET/C# MVP] - m...@spam.guard.caspershouse "JB" <jamesb...@gmailwrote in message news:11**********************@22g2000hsm.googlegro ups... 我正在编写一个数据驱动的应用程序，它刚刚完成但是我还是b $ b还没有决定如何存储数据。 I''m writing a data driven app, its all just about finished but i havent decided how to store the data.
我在看某种形式的数据库。要求： 易于分发，希望只是一些硬盘文件。 查询相对较快。 我认为在这种情况下，速度是最终的易用性 用户。虽然速度总是很重要，这就是为什么我不会使用 xml :) I''m looking at some form of database. Requirements: Easy to Distribute, hopefully just some hard disk files. Relatively quick to query. I think in this case, speed is secondary to ease of use for the end user. Although speed is always important, which is why i wont be using xml :)
数据*不应该*得到任何大于1GB（它不应该超过几百兆的b $ b，但我想要扩展空间）。 Data *shouldnt* get any bigger than 1GB (it shouldnt get more than a few hundred meg but i''d like room for expansion).
我的选择： 1）访问：易于使用，作为独立文件分发。 但是我必须出去买一份办公室副本:( 2）SQLite，从未使用过它，今天只听说过它，开始 现在就读一下，好像它的工作方式类似于访问 （至少来自外面），不知道速度如何。 3）SQL Server Express：免费下载，免费重新发布，免费 嵌入根据微软的说法。 这似乎是一个非常好的选择，一个免费的SQLServer似乎就好了。 会非常灵活和快速。但我担心如何轻松地用编程分发？是否有任何潜在用户 必须下载sql server express app？或几个运行时 文件？或什么都没有？ 4）填空。还有其他建议吗？ My choices: 1) Access: Easy to use, distributes as stand alone files. But then i''d have to go out and buy a copy of office :( 2) SQLite, never used it, oonly just heard of it today, starting to read up about it now, seems like it will work similarly to access (from the outside at least), dont know how the speed is though. 3) SQL Server Express: "Free to download, free to redistribute, free to embed" according to microsoft. It seems like a really good option, a free SQLServer seems like it would be incredibly flexible and fast. But I am concerned about how easy it would be to distribute with a prog? Will any potential users have to download the sql server express app? or a couple of run-time files? or nothing? 4) Fill in the blanks. Any other suggestions?
意见表示欢迎和赞赏。 Opinions welcomed and appreciated.
更多推荐
易于分发的数据库
发布评论