You can certainly do that if you don't care about the data in your database.
The reason why the command did not work is because you did not log in as user 'weewx'. You were logged in as user 'pi'. See the instructions I sent in the last email. On Thu, Mar 12, 2026 at 11:38 AM ANDREI ROZWADOWSKI < [email protected]> wrote: > I've installed sqlite3 > After that, I executed several commands and got the following result: > > > > > > > > > > > *pi@raspberrypi:~ $ sqlite3 /var/lib/weewx/weewx.sdbsqlite> SELECT > datetime(dateTime,'unixepoch','localtime') FROM archive WHERE > date(dateTime,'unixepoch','localtime') > "2026-04-01";SQLite version 3.46.1 > 2024-08-13 09:16:08Enter ".help" for usage hints.sqlite> SELECT > datetime(dateTime,'unixepoch','localtime') FROM archive WHERE > date(dateTime,'unixepoch','localtime') > "2026-04-01";2052-10-17 > 16:52:002053-02-18 08:32:002128-04-25 09:27:00sqlite> DELETE FROM archive > WHERE date(dateTime,'unixepoch','localtime') > "2026-04-01";Runtime error: > attempt to write a readonly database (8)* > > Tell me, please, maybe it will be easier.: 1. Stop weewx. 2. Delete the > weewx .sdb file 3. Restart weewx ?? > > -- > 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/bb1d9b91-5889-4900-abbd-5d7ff4ba17een%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/bb1d9b91-5889-4900-abbd-5d7ff4ba17een%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/CAPq0zEDENWWni7PCCgTJ_Dwuk1eJ9zA0X0pci5_1DuaJwyPoaA%40mail.gmail.com.
