Re: ToDo item: switch logfile to database

[Marcin SP6MI]

Why do you want access to database over network? Any benefits from such 
solution?

Still it's always  easier to migrate in te future to PostreSQL or MySQL from 
SQLite. So from my pov small steps ahead, not big jumps :)

Wondering why syncing tables/databases over network are worst than db access 
over network.


Br
Marcin SP6MI




Wysłano z bezpiecznej poczty e-mail Proton Mail.

czwartek, 28 grudnia 2023 20:06, Christoph Berg <cb@df7cb.de> napisał(a):


> Re: Thomas Beierlein
> 
> > Two points here:
> > 
> > - Journaling is easy, but to be honest TLF provides quite some
> > robustness in that sense too. I have not heard any complies about
> > lost data in all the years.
> 
> 
> Some time last year, I was auditing (well, reading) the tlf source to
> check that. There are sync() and fsync() calls in there, so it's
> probably mostly safe, but since calls that write to disk are spread
> over the code, data safety looks quite ad-hoc. If power goes out while
> the log is just being written, I'd bet there will be problems.
> 
> Switching to sqlite would get us crash safety for free since that's a
> library specifically written for that.
> 
> https://www.sqlite.org/howtocorrupt.html
> 
> But sqlite is not a networking database. If you want that, use
> PostgreSQL.
> 
> 73,
> Christoph DF7CB