易于分发的数据库 [英] Easily distributable database
问题描述
我正在编写一个数据驱动的应用程序，它刚刚完成，但是我没有决定如何存储数据。
我'我正在寻找某种形式的数据库。要求：
易于分发，希望只是一些硬盘文件。
查询相对较快。
我认为在这种情况下，速度是最终的易用性
用户。虽然速度总是很重要，这就是为什么我不会使用
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.com
" JB" < ja ******* @ gmail.com写信息
新闻：11 ********************** @ 22g2000hsm.googlegro ups.com ...
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.com
"JB" <ja*******@gmail.comwrote in message
news:11**********************@22g2000hsm.googlegro ups.com...
我正在编写一个数据驱动的应用程序，它刚刚完成但是我已经完成了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 ******* @ gmail.comwrote：
On Mon, 23 Jul 2007 13:10:08 -0700, JB <ja*******@gmail.comwrote:
>我正在写一个数据驱动应用程序，它刚刚完成，但我还没有决定如何存储数据。
我正在寻找某种形式的数据库。要求：
易于分发，希望只是一些硬盘文件。
查询相对较快。
我认为在这种情况下，速度是次要的易用性到底
用户。虽然速度总是很重要，这就是为什么我不会使用
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 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.
嗨
SQL Server将是恕我直言的最佳选择。这听起来非常适合您的b $ b b要求，并且使用高级版本（也是免费的），您可以获得全文搜索和其他SQL Sqerver功能。数据库的大小可以达到4GB左右。
它可以使用ClickOnce技术进行部署，因此你不应该没有问题
问题与您的应用分发。您可能需要阅读此内容
http://msdn2.microsoft.com/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
http://msdn2.microsoft.com/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.caspershouse.comwrote：
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.caspershouse.comwrote:
JB，
就个人而言，我会选择SQL Server Express。你必须为它安装
的安装程序（我相信有一个MSI，你可以用你的应用程序分发
），鉴于其好处超过安装
问题。
-
- Nicholas Paldino [.NET / C＃MVP]
- m ... @ spam.guard.caspershouse.com
" JB" < jamesb ... @ gmail.com写信息
新闻：11 ********************** @ 22g2000hsm.googlegro ups.com ...
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.com
"JB" <jamesb...@gmail.comwrote in message
news:11**********************@22g2000hsm.googlegro ups.com...
我正在编写一个数据驱动的应用程序，它刚刚完成但是我还是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.
这篇关于易于分发的数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
