Ah, that does make sense why you want to piggyback off of your existing
Maria DB installation.
Have a look at https://github.com/benbjohnson/litestream as a method to
continuously back up the DB to a remote server.
Personally, I rsync the entire weemx data directory to another server. I
may lose some data but probably not relevant. ;)
Cheers!
---
pablo
On August 24, 2025 16:21:59 tommy Teague <[email protected]> wrote:
Thank you all for the quick replies.
I use Maria for several home automation projects here at the house so
figured it was a no brainer. I use this Windows PC as a common file
location and DB server, OTA TV recording, etc. etc.
Could I store the sqlite file on a network drive to cut down on the rpi
sdcard writes? Or just live with the data loss risk and perform backups?
Regards,
Tommy
On Sunday, August 24, 2025 at 4:16:34 PM UTC-4 Tom Keffer wrote:
Indeed. See the wiki article on SQLite vs MySQL on just this subject.
On Sun, Aug 24, 2025 at 12:48 PM Pablo Sanchez <[email protected]> wrote:
Tommy,
As it is a new installation, it be worth trying SQLite.
As a database geek, I also run SQLite. There is no need to incur the
overhead of setting up and running MariaDB/MySQL for a single-user
environment. SQLite is light weight and self-contained. If you want to
query it, you can install a client and muck around.
Cheers!
---
pablo
On 2025-08-24 15:25, Tom Keffer wrote:
Another user reported a similar problem last year. The point of commonality
is MariaDB running on Windows.
This is not a configuration that I can recreate (nor is it supported). I
suspect the problem has something to do with the case-insensitive nature of
Windows, but I don't really know.
Unless you have some compelling reason to use MariaDB (or MySQL), I would
strongly suggest that you just use sqlite3.
-tk
On Sun, Aug 24, 2025 at 12:09 PM tommy Teague <[email protected]> wrote:
Howdy
Newbie here. Recently found and installed weewx to connect to Acurite 5n1
USB display
Everything is working except the reports have a couple issues.
weewx 5.1 running on rpi zero 2 w - Ubuntu Server 24.04.3 LTS fully updated
MariaDB 10.11.2 running on Windows 11
weewx.conf setup to connect to mysql using ID/PW: weewx/weewx
On the monthly report I'm seeing:
TEMPERATURE (F), RAIN (in), WIND SPEED (mph) HEAT COOL AVG MEAN DEG DEG
WIND DOM
DAY TEMP HIGH TIME LOW TIME DAYS DAYS RAIN SPEED HIGH TIME DIR
---------------------------------------------------------------------------------------
01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 87.6 96.0 15:30
75.2 00:00 $day.heatdeg.sum.format($Temp,$NONE,add_label=False)
$day.cooldeg.sum.format($Temp,$NONE,add_label=False) 0.00 3.3 9.9 12:49 0
21 82.9 100.3 16:40 71.8 06:50
$day.heatdeg.sum.format($Temp,$NONE,add_label=False)
$day.cooldeg.sum.format($Temp,$NONE,add_label=False) 0.00 1.5 11.4 19:45
292 22 79.4 93.6 14:50 72.1 05:30
$day.heatdeg.sum.format($Temp,$NONE,add_label=False)
$day.cooldeg.sum.format($Temp,$NONE,add_label=False) 0.00 1.1 10.4 16:35 14
23 77.4 89.9 12:05 73.9 13:20
$day.heatdeg.sum.format($Temp,$NONE,add_label=False)
$day.cooldeg.sum.format($Temp,$NONE,add_label=False) 1.70 1.0 9.9 17:03 90
24 76.3 89.8 14:30 70.3 07:05
$day.heatdeg.sum.format($Temp,$NONE,add_label=False)
$day.cooldeg.sum.format($Temp,$NONE,add_label=False) 0.03 2.2 8.3 11:42 354
On the yearly report I'm seeing:
MEAN MEAN DEG DEG >= <= <= <= YR MO MAX MIN MEAN DAYS DAYS HI DAY LOW DAY
90 32 32 0
------------------------------------------------------------------------------------------------
2025 01
2025 02
2025 03
2025 04
2025 05
2025 06
2025 07
2025 08 $month.outTemp.meanmax.format($Temp,$NONE,add_label=False)
$month.outTemp.meanmin.format($Temp,$NONE,add_label=False) 80.5
$month.heatdeg.sum.format($Temp,$NONE,add_label=False)
$month.cooldeg.sum.format($Temp,$NONE,add_label=False) 100.3 21 70.3 24
$month.outTemp.max_ge($Hot).format($Count,$NONE,add_label=False)
$month.outTemp.max_le($Cold).format($Count,$NONE,add_label=False)
$month.outTemp.min_le($Cold).format($Count,$NONE,add_label=False)
$month.outTemp.min_le($VeryCold).format($Count,$NONE,add_label=False)
2025 09
2025 10
2025 11
2025 12
------------------------------------------------------------------------------------------------
$year.outTemp.meanmax.format($Temp,$NONE,add_label=False)
$year.outTemp.meanmin.format($Temp,$NONE,add_label=False) 80.5
$year.heatdeg.sum.format($Temp,$NONE,add_label=False)
$year.cooldeg.sum.format($Temp,$NONE,add_label=False) 100.3 Aug 70.3 Aug
$year.outTemp.max_ge($Hot).format($Count,$NONE,add_label=False)
$year.outTemp.max_le($Cold).format($Count,$NONE,add_label=False)
$year.outTemp.min_le($Cold).format($Count,$NONE,add_label=False)
$year.outTemp.min_le($VeryCold).format($Count,$NONE,add_label=False)
Any fixes for these items?
Regards,
Tommy
--
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/71b7628d-6a56-4dfe-81cb-1937db075e12n%40googlegroups.com.
--
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/CAPq0zEB%2B%2BHHAtExoacTem8d-LF29E8yKdfXWncLwd9VQh7aeYA%40mail.gmail.com.
--
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/2e4152d6-2d5d-4a50-94b3-92072e27be17%40hillsandlakes.com.
--
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/3379112e-55d9-4043-ad31-2bd18ee46f1bn%40googlegroups.com.
--
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/198ddcb2da8.2848.44b74f35a7a433c111dbfaee4cca1c2d%40hillsandlakes.com.
