On 10/14/22 1:33 AM, Geoff wrote:
I doubt if this has change since last you asked, these are your choices:
https://wiki.gnucash.org/wiki/FAQ#SQL_Database
SQLite claims to be very reliable:
https://www.sqlite.org/hirely.html
An easy solution to dodgy power is a cheap laptop - put a battery
between yourself and the grid.
Good luck
Geoff
=====
On 14/10/2022 5:24 pm, Jeff wrote:
I know that this question has been asked many times but I am asking
again. I just had 2 hard drive failures back to back, both of which
just happened to have images attached to GNC transactions. Bad luck
on my part, they also happened to be my backup drives. Murphy is
after all the patron saint of all physicists. Everything that can go
wrong will go wrong. I am currently adding 2 more backup drives plus
a third working drive (all 6 TB, right now, I expect all of them to
be filled with my next project in the next 2 weeks, although 6 gigs
will be devoted specifically to GNC).
Is there any way, even the slightest, to attach a transaction image
to a daemon instead of a specific file? That way I could use a
database system in the background to hold images instead of the file
system. That way images would still be available to GNC and
searchable for me (never know when a rebate might show up {grin}).
Platter failures are a lot less expensive to recover than circuit
boards (i need battery backup here but right now I cannot afford a
large enough system with voltage spike protection) and my electric
company is well known for feeding large voltage spikes here since I
have the best grounding system for miles and I am the last drop on
their power line. 60 volts on the neutral is a common experience.
It's a wonder that I still have at least one computer that works.
Sorry, the SQL interface does not work with my main set of books. 30+
years worth of transactions and the SQL conversion locks up. 6 years no
problem.
Dirty power or not, this system worked without a hitch on a 10kw
generator that was, pardon my language, noisier than hell, spikes, lows
were not uncommon.
Somewhere there is a glitch with GNC and the SQL backend. And I am the
butt of that problem.
--
--JEffrey Black M.B.A.
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.