The Pinkary database just went from ~800MB to ~90MB.
How?
VACUUM;🤯
•
Back
🤯
🤯
The database had a lot of free pages due to a large number of row deletes over time. The Laravel Pulse package was the main cause of these deletes (recording entries and then deleting them after a period), but cache, jobs, etc also contributed to the free space that could be truncated off the file.
•
Interesting indeed, do you mean that you've been working with laravel pulse using sqlite database?
•
Yes. Pinkary is currently using Laravel Pulse, saving entries to the production database (which is sqlite).
•
According to the docs, sqlite is not supported. I tried it myself in a hobby project. I got some errors open the Pulse dashboard. How did you manage that?
•
In response to @buddhacode
\Laravel\Pulse\Support\PulseMigration::shouldRun();
Ah. I think that's a mixup with the docs. It appears the accepted drivers are
['mariadb', 'mysql', 'pgsql', 'sqlite']\Laravel\Pulse\Support\PulseMigration::shouldRun();
•
Nice to hear. I did a little code diving. The error I get, is from a thrid party card. So I guess it's not a Pulse problem in general. The 3rd party card uses a raw query with a sql function not available in sqlite.