SQLite may likely become too limiting once the database grows in size. We should use the already available MariaDB server from ToolsDB. It has a 25 GB limit but this should be enough for now.
There may be an issue though as the Connection handling policy forbids keeping an idle open connection. If this proves to be an issue, we may have to migrate to Cloud VPS and host our own DB instance. (See T425489)
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Danya | T427979 [VERSION] 0.3.0 | |||
| Resolved | Danya | T425991 Investigate best solution between ToolsDB and self-hosted database |
Turns out 25 GB will only be enough for about ~5 months worth of data because each monthly snapshot takes up to ~5 GB. So it looks like the only option is to host our own database.
After discussions in T428090, we will use ToolsDB as the migration to Cloud VPS was deemed unnecessary. Closing this ticket.