botpress / v12

Botpress OSS – v12
https://v12.botpress.com
GNU Affero General Public License v3.0
71 stars 83 forks source link

[FEATURE] add vacuum command to sqlite #1681

Closed ptrckbp closed 1 year ago

ptrckbp commented 2 years ago

Is your feature request related to a problem? Please describe. The Sqlite file database grows over time slowing down Botpress with no useful error messages.

I was hitting the 20s mark and getting lots of timeout messages in the botpress ui.

Describe the solution you'd like Add a sql vacuum command on botpress start if using sqlite

Describe alternatives you've considered Get rid of sqlite and always use postgres

damiendidi commented 1 year ago

hello, I agree with this addition it is very useful

davidvitora commented 1 year ago

SQLite should be used just for dev; for a production environment, use PostgreSQL