mysql - 鬼博客的sqlite vs mysql？

Question

关闭。这个问题是 opinion-based .它目前不接受答案。

---

想要改进这个问题吗？ 更新问题，以便 editing this post 提供事实和引用来回答它.

关闭 9 年前。

Improve this question

我目前正在我的服务器上设置 ghost。我将主持自己的博客，可能还会为我的 friend 们开设更多博客。

Ghost 默认使用 sqlite。 Sqlite 适用于小型应用程序和开发环境。

如果 ghost 运行良好，我计划将我的博客运行至少 1 到 2 年或更长时间。博客包含大量图像和文本。随着时间的推移，sqlite 数据库会随着越来越多的图像等而增长。

为了这个目的使用 sqlite 几年可以吗？ MySQL 会更强大，但设置起来也更复杂。

什么是 Ghost 博客的最佳选择？

Answer 1

请注意，数据库性能很大程度上取决于数据量(直到您用完本地磁盘空间)，而是取决于并发量。

SQLite documentation说:

SQLite usually will work great as the database engine for low to medium traffic websites (which is to say, 99.9% of all websites). The amount of web traffic that SQLite can handle depends, of course, on how heavily the website uses its database. Generally speaking, any site that gets fewer than 100K hits/day should work fine with SQLite. The 100K hits/day figure is a conservative estimate, not a hard upper bound. SQLite has been demonstrated to work with 10 times that amount of traffic.
[…]
But if your website is so busy that you are thinking of splitting the database component off onto a separate machine, then you should definitely consider using an enterprise-class client/server database engine instead of SQLite.