I'm not sure your approach is the best one, but to answer your questions: 1. Yes, WeeWX opens the database and leaves it open. 2. Contention is managed by the SQLite database. See this documentation <https://sqlite.org/lockingv3.html>. 3. Unless an extension is acting otherwise, WeeWX does not write with every LOOP packet. Only when archive records arrive.
On Mon, Sep 11, 2023 at 8:10 AM DR <wxe...@gmail.com> wrote: > I'm just thinking about another project, and wonder how WeeWx uses the > default database. > > > When it is running does it open and leave open the database all the time? > > If so, is the database able to have another program add records to the > database while WeeWx has it open? > > The reason I ask, is that I would like to have another program running > which reads snow depth from a Campbell Scientific table, then add that > value to the standard database at say 15 minute intervals with a field > defined and added to the schema. > > In some days past, I know some databases would prevent more than one > attempt to access it, even if not in the traditional deadly embrace > situation. > > If WeeWx is busy stuffing new values in every 2 seconds during loop > functions, can I also access it simultaneously as long as I don't try to > touch the fields that WeeWx is writing to? > > > Or is it necessary to shut down, briefly, access, then have the snow > depth program open it, write the value, close it and then let WeeWx go > merrily on it's way? > > I hope this question is within the scope of this user discussion. Dale > > > -- > 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 weewx-user+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/918b02a3-72d7-f7f7-2e77-a3a374489a85%40gmail.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 weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zEAjUcruwXiaeAkFhUY3mJEaFUbT%2Bh_SB8CL28xTyMFH%2BA%40mail.gmail.com.
