我应该使用哪个数据库用于家庭项目使用？ [英] Which database should I use for home project use?

问题描述

我浏览了所有的相关问题，有两到三个不同的标题，没有看到任何东西，所以这里。

SQL Server和Oracle最近在过去的工作。我想在家里，大多与Java，可能是Ruby on Rails或Python。我运行Windows 7.我通常做Web应用程序，可能希望最终远程托管，除此之外，没有具体的要求前期。

在这种情况下，我不想进一步学习SQL的输入和输出;我可能会使用ORM抽象出来，所以它自动方言不可知。

我应该考虑哪些数据库？

1. 我安装了SQL Server Express，它似乎只能使用.NET，加上SQL Server Express安装似乎没有正确集成它随附的Visual Studio C＃Express版本。 （例如，我无法自动创建数据库。）


2. 我正在考虑Oracle XE，除非我曾想要使任何项目代码公开，找到托管Oracle在一个合理的价格似乎是一个绊脚石。


3. 如果我不需要太多并发，SQLite似乎是快速，快速的方式。


4. MySQL似乎是一种方便的东西，容易托管，可能是整体的赢家。

解决方案

SQLite是一个非常好的选择。它只是一个单一的文件，并且快。没有配置，事务是原子的，支持太字节大小的数据库。有Ada，C＃，Lisp，Fortran，Java，Lua，PHP，Perl，Python，Ruby，Tcl等语言绑定...

GUI管理选项：

1. Windows版的SQLite Admin


2. 适用于Linux，Mac和Windows的SQLite Browser 屏幕截图


3. 即使是 Firefox插件





它用于工业：



1. 这是Firefox内部用于书签和历史记录的基本数据库。它也可以由插件使用它们来存储内部数据。 链接


2. iPhone还在内部使用它来存储数据，并且可以由应用程序自己用于自己的数据存储。这里是一系列的教程，在自己的应用程序中使用它。 链接


3. Adob​​e使用它作为Lightroom的文件格式。苹果使用它为邮件和孔径。 Skype在Mac和Windows的客户端中使用它。最后，它似乎是Symbian，诺基亚手机操作系统的一个组成部分。 用户页






I've looked through all the "related questions" with two or three different titles and didn't see anything, so here goes.

I've used SQL Server and Oracle in the recent past at work. I want to futz around at home, mostly with Java, perhaps with Ruby on Rails or Python. I'm running Windows 7. I usually make web applications, might like to host this remotely eventually, and beyond that, have no specific requirements upfront.

In this case, I'm not interested in learning the ins and outs of SQL further; I'll probably use ORM to abstract this out, so that it's automatically dialect agnostic. I'm also going to work with a few nonrelational data stores, but I have specific ones in mind there.

What databases should I consider?

1. I installed SQL Server Express, and it seems fairly limited to just working with .NET, plus the SQL Server Express install doesn't even seem to be integrated properly with the Visual Studio C# Express edition that it came with. (I can't create a database automatically, for example.)
2. I'm considering Oracle XE, except if I ever wanted to make any project code of mine publicly available, finding hosting for Oracle at a reasonable price seems a stumbling block.
3. SQLite seems the way to go for fast and quick, if I don't need much concurrency.
4. MySQL seems to be the way to go for something that's easily hosted, and may be the overall winner. Here's to hoping the GUI isn't still awful.

解决方案

SQLite is a very good option. It is just a single file, and fast. No configuration, transactions are atomic, supports terabyte-sized databases. There are language-bindings for Ada, C#, Lisp, Fortran, Java, Lua, PHP, Perl, Python, Ruby, Tcl, etc...

It has good GUI admin options:

1. SQLite Admin for Windows
2. SQLite Browser for Linux, Mac, and Windows screenshots
3. Even a Firefox plugin for viewing/editing data
4. Many more

It is used in industry:

1. It's the base database the Firefox uses internally for bookmarks and history. It can also be used by plugins for them to store internal data. link
2. The iPhone also uses it internally to store data, and can be used by apps themselves for their own data storage. Here is a series of tutorials on using it within your own apps. link
3. Adobe uses it as the file format for Lightroom. Apple uses it for Mail and Aperture. Skype uses it in their clients for Mac and Windows. Lastly, it seems to be an integral part of Symbian, Nokia's phone OS. users page

这篇关于我应该使用哪个数据库用于家庭项目使用？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！