[GNC] transaction images and failed hard drives

[David T.]

Geoff,

Jeff is asking a more specific question related to the image linking feature. It's not his book data that he's looking for guidance on; it's whether he can link his images using a different mechanism than to a file directly. 

Jeff, I don't profess to fully understand your solution, but I'd have to say that unless you have a way to make your database references look and act like a file reference, you're going to find no solution without some significant effort on your part. 

My recollection of past threads suggests that a more robust file reference mechanism would be welcomed by several users of the file feature, so if you figure out a way to make it happen, do report back. 

⁣David T. ​

On Oct 14, 2022, 9:34 AM, at 9:34 AM, Geoff <cleanoutmyshed at gmail.com> 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.
>> 
>> 
>_______________________________________________
>gnucash-user mailing list
>gnucash-user at 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.