How to use SQlite database to generate date to date images ?

93 views
Skip to first unread message

Jean-Luc kligler

unread,
Jan 7, 2023, 10:35:47 AM1/7/23
to weewx-user
Hello all !
I'use a small station using weewx with an sdr key
 . It has the standard skin that gives me pictures for last day, week, month and year .

I'm searching for a solution to generate images from "old" months or " date to date "
ex : today i'd like to generate a picture with temperature from 2021/07/01 to 2021/07/31 .

Do you know an external software, a weewx-plugin or maybe another weewx-skin that can extract the datas in the sqlite database and generate the picture ?
Hope you have an idea !

have a nice WE !
Message has been deleted

storm...@gmail.com

unread,
Jan 7, 2023, 11:19:19 AM1/7/23
to weewx-user

Chuck Rhode

unread,
Jan 7, 2023, 11:32:30 AM1/7/23
to weewx...@googlegroups.com
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sat, 7 Jan 2023 07:35:47 -0800 (PST)
Jean-Luc kligler <jlk...@gmail.com> wrote:

> I'm searching for a solution to generate images from "old" months or
> "date to date."

> Do you know an external software, a weewx-plugin or maybe another
> weewx-skin that can extract the datas in the sqlite database and
> generate the picture?

It's overkill and a lot to install, but I believe the Phenology
Extension has the capability.

- - https://lacusveris.com/Phenology/research.shtml#4.6.1

I've used it on day plots but not month plots. It may — perhaps —
work for you. Good luck!

- --
.. Be Seeing You,
.. Chuck Rhode, Sheboygan, WI, USA
.. Weather: http://LacusVeris.com/WX
.. 26° — Wind NNW 6 mph — Sky overcast.

-----BEGIN PGP SIGNATURE-----

iF0EARECAB0WIQT+MY/5I/LMPSswTbVg2/xipKOWUgUCY7mejAAKCRBg2/xipKOW
Uve6AJ9rp9n2660svV5gsis3txV44rTO9QCfd4TqA5DFcg/qWrJ2sNOI/ShU9/w=
=zxCZ
-----END PGP SIGNATURE-----

Jeff A. D.

unread,
Jan 8, 2023, 1:07:30 AM1/8/23
to weewx-user
I believe

  sudo wee_reports --date=2021-08-01 --time=00:00

will generate reports and graphs for the preceding day/week/month/year, including the month of July you're looking for.

I've tried to use SQLite Browser and such and couldn't get them to work the way I wanted to produce graphs and such.

Jean-Luc kligler

unread,
Jan 8, 2023, 6:25:13 AM1/8/23
to weewx-user
Hello, thank you for your help .
@Jeff A. D.  i've just tested your solution and it's perfect for me, it does the job !  Thank for your help !
Thank you all !
Reply all
Reply to author
Forward
0 new messages