在Heroku上重启后更好的SQLite3数据库重置 [英] Better-SQLite3 Database resetting after restart on Heroku

问题描述

我有一个Discord机器人，它的 better-sqlite3 硬币和XP的数据库.直到2周前，它始终可以正常工作.现在，每次重新启动后，只需重新设置XP和硬币即可.真令人讨厌，因为人们每天都在升级到同一水平.

I have a Discord bot with a better-sqlite3 database for coins and XP. It always worked fine until 2 weeks ago. Now, after every restart it just sets the XP and coins back. It's really annoying because people are leveling up to the same level every day.

有人知道如何解决此问题吗?

Does someone know how to fix this?

推荐答案

如果操作正常，我会非常.

Heroku的短暂文件系统会在您的dynos重新启动时丢失对其所做的所有更改.此经常发生(每天至少一次).结果，Heroku不支持基于文件的数据库，例如SQLite .

Heroku's ephemeral filesystem loses all changes made to it whenever your dynos restart. This happens frequently (at least once per day). As a result, file-based databases like SQLite aren't supported on Heroku.

如果要在Heroku上运行代码，则必须切换到客户端服务器数据库.PostgreSQL是一种常见的选择，Heroku提供了自己的托管的PostgreSQL服务，您可以免费开始使用它.

You'll have to switch to a client-server database if you want to run your code on Heroku. PostgreSQL is a common choice, and Heroku provides its own hosted PostgreSQL service that you can start using for free.

这篇关于在Heroku上重启后更好的SQLite3数据库重置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！