admin avatar

Personal blog database selection, mysql vs sqlite?

🕟 by admin

Always looking for lightweight when setting up a personal blog

So it is very entangled whether the database should choose MySQL or sqlite

Checked out information on MySQL and sqlite

Roughly compare the differences between the two

Talk about your unscientific views

Personal blog does not really need to use MySQL, sqlite can be a good choice

Personal blogs do not have a large amount of data written at the same time. After writing the article, you can use cache or CDN acceleration to reduce the large number of sqlite read

The sqlite database is also easy to back up, only one .db file

The amount of data comparison between the two has not been tested

But MySQL data has been used, about 10W article database capacity is about 5G. . .

The response speed of the website is obviously slower. Of course, the open source program used will not be optimized by itself ~~~~

Considering the above, considering personal blogs is convenient and practical, the pursuit of lightweight sqlite is a good choice

💘 相关文章

📝 有偿服务

• 服务器合租380/年
• 服务器配置:2.4G,6核12线程
• nvme raid 1硬盘
• 不提供服务器自主面板
• 适合稳定的个人博客
• 提供备份服务,备份空间自备
• 只提供ipv6地址,搭配cloudflare使用
• 提供想要安装的程序和域名
• 博客必须是和谐健康的
• 博客不能是视频和图片站
• 提供以下付费服务
• 建站,FTP,备份,Linux,Wordpress等建站问题咨询管理
• 加微信:344452500(不闲聊,直接说事)


Based on Golang + fastHTTP + sdb | go1.16.8 Processed in 0ms