I'm using MariaDB with about 9 years of data. Back in the days it was more recommended than sqlite.
I dont made tweaks of the systems. It runs quite well since a couple of month ago. My weewx installation is on a Debian 13 VM with 2 cores and 4 gb of ram. My MariaDB vm has 2 cores and also 4 gb of ram. Usually thats enough for that "small" systems. vince schrieb am Freitag, 2. Januar 2026 um 19:35:09 UTC+1: > Sqlite3 db here. I have 1.88 M records since Thanksgiving 2006. No issues. > > On Friday, January 2, 2026 at 7:04:50 AM UTC-8 Tom Keffer wrote: > >> My sqlite database has just short of 2 million rows --- about 20 years of >> data. It is still very performant. >> >> On Fri, Jan 2, 2026 at 12:32 AM [email protected] <[email protected]> >> wrote: >> >>> Hello, >>> does anyone using weewx with bigger (lot data) databases? I've about 9 >>> years of weatherdata in mine and now have some memory problems. >>> Just curious if someone have also such amount of data and can show me >>> their tweaks? >>> >>> With the weewx-wdc skin i have a lot of oom kills. >>> Thanks. >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "weewx-user" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To view this discussion visit >>> https://groups.google.com/d/msgid/weewx-user/4cd5d83a-15eb-4a82-bc6e-555f05acdc09n%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/weewx-user/4cd5d83a-15eb-4a82-bc6e-555f05acdc09n%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/weewx-user/96034d76-7844-48b5-9708-6f351bdcb357n%40googlegroups.com.
