ovsqlite

Julien ÉLIE julien at trigofacile.com
Thu Dec 24 10:48:21 UTC 2020


Hi Bo,

>> I see that the removal of a newsgroup is deferred until the next expiration, which is a good thing (preventing an error in a control message or manually with ctlinnd).
> 
> Actually, it's because removing thousands of rows from the article table
> could take some time and shouldn't be allowed to block regular operations.
> 
> Adding a new group does NOT undelete a previous one with the same name.
> I checked carefully what ovdb does in this situation and implemented
> the closest equivalent.

Indeed.  I have just tested two successive removals and re-creations:

sqlite> select * from groupinfo where groupid>618;
619|1|3|3|0|1|trigofacile.test6|y
620|3|3|1|0|2|trigofacile.test6|y
621|1|0|0|0|0|trigofacile.test6|y



> Manual undeletion would be a lot easier with ovsqlite than with ovdb,
> since you get a free SQL command line tool with each SQLite installation.

Which is a point to add to the advantages of ovsqlite!
I am really fond of that SQL command line tool to explore the database!

Reinstating a newsgroup removed by error is very simple with that.

We'll now need ovspool for article storage :-)

-- 
Julien ÉLIE

« Utiliser vi n'est pas un péché, c'est une punition. Car souvenez-vous
   que vi-vi-vi est l'éditeur de la Bête. » (Stallman, Church of Emacs)


More information about the inn-workers mailing list