Ask HN: How do you manage your “family data warehouse”?
Some common categories:
(1) Financial: account statements (pdf, paper, etc), transaction CSV/ofx/etc, insurance policies, financial institution correspondence (confirmations, T&Cs, etc), tax forms, deeds/titles, loans, debts, contemporaneous records, paystubs, employment letters, receipts, etc
(2) Health: test results, diagnoses, medications used, doctor info/correspondence, vaccinations, hospital interactions, statements, bills, etc
(3) Product and services info: products purchased, maintenance info, warranties, replacement parts, recall notices, class action events, professional used (CPAs, lawyers, contractors, plumbers, etc), etc
(4) Personal legal and other documents: wills, trusts, health directives, pre-nups, legal settlements, personal contracts, rental agreements, government IDs, immigration/naturalization docs, law enforcement interactions, etc
(5) Memories and other info of sentimental or other value: pictures, videos, cards, recordings, music, diaries, clippings, personal notes, etc
For many of these one might ask the usual questions:
A. do I have a reason/obligation to retain it? for example, tax authorities often require certain classes of record keeping. sometimes commercial entities make false claims in retrospect that you can only rebut with evidence (even major banks!). some documents can end up only being used by heirs at end-of-life (ex: basis information for assets like a home, which can require proof of improvements over the years, depreciation claimed if the home was ever rented, etc)
B. is there a downside to retaining it? clutter, hard/costly to move, identity/other theft risk, physical decay over time (ex: obsolete storage formats (VHS, mini-DV, blueray)), etc
C. will I (or the appropriate person) be able to find it when I need it? physical paper vs electronic mgmt, indexing, filing, passwords, legacy services for transferring access.
D. can I actually retain it? backups, water damage, fire, theft, physical safe management, etc some online services don't provide any/easy export of data, many have inconsistent retention policies (ex utility companies)
Some of the categories above have specialized software and services dedicated to them (ex: photos services, quickbooks, etc) while some are more ad hoc (goog drive, dropbox, local HDD); even specialized services often fall short on key matters (quickbooks doesn't track statements afaik); many specialized systems have various platform limitations (no turbotax on linux, say); many vendors try to play various lock-in tricks; some vendors go out of business or discontinue products over the years; some institutions are very paper oriented so one perhaps scans or tries to limit paper delivery; some services place data in the cloud creating security exposure; etc etc
140 comments
[ 2.9 ms ] story [ 294 ms ] threadEverything is stored locally, unencrypted, and backed up on a local removable HDD, and on BackBlaze. BackBlaze has saved my bacon more than once.
As for physical objects, they're all temporarily mine, until I pass on. They're either tools, consumables, or tied to personal memories. Everything else can go.
The one significant thing to pass on to others is all the data in D:\source\yyyy\yyyymmdd*, which is all of my photos, including family events, short videos, etc. As best I can, all the faces have be tagged with XMP metadata. (Nobody wants to keep an old box of photos without knowing how those people are related)
I need to discuss with my spouse and child what they want from there.Obligation wise it's good to keep all documents for whatever the longest record keeping period is in your region.
Important that you scan your identity documents and keep copies too. That has been incredibly useful when I'm abroad because a lot of people will retain passports etc if you go in a hospital or something so you can just show them the electronic copy and tell them you left it in the hotel.
Photos (hundreds of GBs) are also in Subversion hosted on same server. Photos are managed/viewed either via Digikam (on both Mac, Linux, Windows) as well as through a generated HTML/js gallery served on the same server.
Home server is backed up via restic to
* local harddrives that are rotated weekly and moved offsite. * to a rented physical Debian server in a different country * to a cloud storage provider
Server storage is fully encrypted using LUKS. Backups are encrypted via restic/ssh.
Various sensitive documents are separately encrypted inside the svn repos via 'age' or similar tools.
This setup has been working for almost two decades. I have yet to lose any data.
Edit: For documents, we have a personal repo for each family member. Typically, we use a folder structure based on https://johnnydecimal.com/
We also have a repo specifically for receiped in which receipts are just stored as /<year>/<yyyy-mm-dd>-<name>.pdf (or .jpg if it is a scan/photo).
Legal documents like wills, etc. are stored in a safe as well as a physical copy stored at a relative + digital versions stored in the svn repo.
I am aware that nowadays, SVN is not the modern choice compared to Git. When I designed this system, Git was not available. But I actually find that SVN's centralized architecture fits really well for this purpose.
For photos, I really like having them in SVN as I never lose any image even if I modify it. Sure, it takes up a little extra storage. But storage is cheap. Also, SVN here acts as an extra local backup.
Backups via restic end up on backblaze. Haven’t gotten around to set up the local backup. This is a good reminder to do so. :)
The photos end up in iCloud and Adobe with a backup in backblaze. Not so happy yet with this solution. But most alternatives I tried weren’t as comfortable.
Edit: The paperless ngx server is a low power machine that runs in my local network.
I'm also mirroring the family Google photos locally and backing it all up to rsync.net.
Regarding retention - everything gets kept, I don't care about retention rules. Things are tagged so a payslip from 2001 is still there if I ever need it, but I won't see it otherwise. It would cost more to think about it that the few hundred MB that it costs in storage space.
Looking at, https://duckduckgo.com/?q=site%3Arsync.net%2Fproducts&t=ipho...
You have rclone, sftp, rsync, restic, borg, synology and other.
My understanding is there’s no bandwidth pricing.
(I’m sure they’ll show up and clarify it. Amazing they always seem to do so)
We would be very happy to have you.
Important stuff has a photo taken, and it's likely backed up in my photo archives (Syncthing → Pi Storage → NAS backup).
My girlfriend still uses google and whatsapp, and I tend to send her important media in our chats, so we'd both have to be kicked out of our gmail and whatsapp accounts to truly lose everything there.
One of the tools I found useful is Microsoft Lens mobile app: it's almost as quick as taking a picture of a doc, but it makes it easy to create a pdf of all the docs and bundle up multiple pages.
Over the years, I have lost access of important google accounts. In one occasion, I had a very old google voice number which I used from time to time. At an unexpected time, Google sent me an email asking me to validate that I still needed it within 30 days. At the time, I was traveling and unable to check email for complicated reasons. I ended up losing the Google voice number, which was the 2FA for a number of accounts, which then became irrevocably lost since the number was re-assigned.
I used to keep photos and videos on an external hard disk with a jwz-style backup mechanism and Lightroom 3 for organizing it (kept the light room database file on the hard disk itself)
Now just gave up and use iCloud Photos. Not as good as Lightroom but can't find anything better that's also easy.
Secure details go into 1Password with a printout of emergency keys in a wardrobe under lock.
I used to use Evernote but moved away from it soon after they started introducing chat and a bunch of crap no one cared about.
I keep copies of often-referenced items from Dropbox in Apple Notes but the master copy is a file in Dropbox.
I'm using the Shortcuts app on the phone to take a receipt from an online payment and file it away in the /receipts folder in Dropbox.
I used to have an IFTTT integration to take all the photos I posted on Facebook and keep a copy of them in a Dropbox folder as well. It probably still works but I don't really post stuff anywhere any more.
https://www.izimi.be/en/
On top of that, every official document, from birth certifica, loans, drivers license, health insurance, and everything else is stored in government databases and can usually be accessed from there, provided your national single sign-on solution, MitID, works.
I’m jealous over countries that have such well designed systems in place to make things easy for their citizens
I haven’t had to deal with that bureaucratic processes, but if I extrapolate the awful experiences I had with something as simple as a new ID, I can fully understand why people hate this kind of organization.
I decided not to become a German citizen. I want no liabilities to this country.
Sad considering the desperate need for people working in a variety of specialized professions, but a completely understandable reaction. Unfortunately, I don't see a realistic future where this is any better.
Looking at the situation here it’s really damming that Germany not only has essentially no digital processes implemented, the people in charge seem to are even lacking something as fundamental as a coherent vision how it should work at some point. That the current coalition also decided to essentially cut funds for digitalization projects isn’t making the issue any better
So is a filing cabinet or safe, ideas that have worked well for 1000s of years. If you really need a digital backup, throw the documents on a $10 flash drive, maybe have two copies of that.
I guess I'm cynical because governments and institutions get hacked all the time.
I store everything in the cloud, because it is unbeatably convenient except for the very things mentioned: health, financial and legal. I'm not 100% strict either, because if a document has been sent or received electronically or can be assumed to be stored in the cloud anyways I really can't do much. I still assume that every online storage will be breached one day and keep some documents deliberately offline.
To give you some chills, check out "Who's been pwned" [1] and this is only the tip of the iceberg that has surfaced and that fulfills HIBP's inclusion criteria.
[1] https://haveibeenpwned.com/PwnedWebsites
Huh? I think I made the second or third comment in this thread outlining my solution which is offline-first:
https://news.ycombinator.com/item?id=37520972
As for products, i have aimed to buy services that are easily transferrable, i.e. we use iCloud family sharing, meaning every user has their own storage, but they piggy back on my paid subscription. If/when i stop paying, they can chose to continue paying by themselves, and things will just "magically" keep working, but otherwise it's a tricky game.
As for memories, i store everything in the cloud. Most is encrypted by Cryptomator. I have a small server at home synchronizing data home in real time, and the server backs up data hourly to a local target, and a couple of times per day to another cloud.
I have thought long and hard about decentralizing this to let each users laptop do this, but with a family photo album of 3.5TB that would mean i lose deduplication.
It would also put much more demand on the client hardware, as it would need to be able to hold the entire photo library to back it up. I have LONG REQUESTED a way to backup iCloud data without the need to keep it all local, i.e. download upon use for backup, and delete again, but sadly that's not how it works. If your data is "cloud only", your backup will only backup file pointers, and not the actual photos.
Once every year i make Blu-Ray M-disc archives of the previous years photos, and to some lesser extent also documents. I make identical copies and store them in geographically separate locations. I use no encryption or compression on these archive discs. I also have a set of identical external USB drives that i update with the entire archive yearly and then rotate between locations.
I am fully aware that optical media may not be around for much longer, but that's a problem for future me. For now it is the best and most affordable "long term, no maintenance" storage technology available to consumers. Until an official "end of life" is reported, i will keep using it. Once it's EOL i can easily migrate my archive to "something more better", even if that ends up being just ordering photo copies.
For digital stuff it’s mostly the same idea. If it’s email (which is almost always the case), I archive and forget about it. If it’s something else, I’ll throw it in my virtual “messy drawer” which is just a folder in Google Drive.
You are getting quite a few clever ideas in this thread, but I suspect the vast majority of people out there in the real world do more or less the same as I do (of course, I’m biased).
My “philosophy” (overstatement) is that 99.99% of the time I’ll never need it. If I ever do, it might be a little painful to dig around, but that doesn’t justify having a whole system in place. I would rather keep my mess.
Today, I routinely download and save PDF/OFX/QFX for every financial and insurance statement, as they become available. The few important paper documents I receive, go into a "to-scan" pile, which I try to clear out every few months.
(I really need to set up a scanning appliance/station that takes only seconds to use. I only need a to-scan pile because it currently takes about 15 minutes to set up for scanning and put things away after.)
Since Apple started providing better end to end encryption for Notes and iCloud, my wife and I just use that. We also have a ton of storage on OneDrive, so periodically I ZIP up important stuff, encrypt it and put on OneDrive.
Fujitsu ScanSnap is a highly recommended product. I have one on my desk that I bought over ten years ago -- it's slightly larger than a box of facial tissues (kleenex), all I have to do to scan is open the two "flaps", insert document, press a button, then assign a file name and folder (easy once a history list is established). Scans color or B&W, single side or duplex.
There's always a bit too much that is attached to emails, I try to remember to save stuff out.
A Synology NAS in the attic which backs up the above.
No encryption.
An £50 "fireproof" box for passports, citizenship certs, things where the original is important.
I assembled a ridiculous old server to do tape backups but couldn't make a very practical system - I wish I could attach an LTO drive to something smaller!
That's "ScanSnap", not Snapscan. :-) I posted about how handy these are before I saw your comment.
>There's always a bit too much that is attached to emails, I try to remember to save stuff out.
Same here. In fact, I always either save or delete attachments, I never leave them in my Thunderbird mail store.
I rsync my picture and document library from my MBP to the NAS. The MBP also has a Backblaze backup. 2-4 times a year I sync my pics, docs, and backups to a 6TB drive that’s offline.
This works better than I can possibly tell you.
I have an Epson WorkForce ES-580W that I bought when my mother passed away to bulk scan documents and it scans everything, double-sided if required, multi-page PDFs if required, at very high speed and uploads everything to OneDrive, at which point I drag and drop everything into Paperless.
I could, thinking about it, have the scanner email stuff to Paperless. Might investigate that today.
Paperless will OCR it and make it all searchable. This setup is amazing, I love living in the future.
Without that, I had paper piling up waiting to be scanned.
Beside that is a nice idea, but too focused on scanned stuff, today many docs are not scanned nor pdfs.
For home server usage, I just use it as a frontend to docker-compose files that gives me a pretty UI I can access from a web browser, instead of needing to SSH in to the home server.
The fireproof bag also has my account/password list (printed out once a year), birth certificates, titles, and passports.
If you are the tech person in your family, think about what happens if you die. Will your family be able to figure out and maintain your system? Mine is far from perfect, but most of my family can figure out Google Drive.
We use SyncThing because it is free, doesn't require user accounts, and works across Mac, Windows, Linux, iOS (Möbius) and Android.
We have a bunch of high level folders (eg. Health, School, etc). Inside that folder every document is named starting with a date, eg: "2023-09-11 Invoice Dentist Kid1.pdf".
So far I've always found every document.
if you're willing to share:
1. what scanner do you use?
2. what do you do for documents that might be in two places? ex: car insurance, health insurance - in the insurance folder or the health folder? ex: medications that both spouses take, in his folder or her folder or in a "both" folder?
2) We have very few categories, so it's usually clear where something goes. If not, I just pick a random folder, usually I search with Spotlight (full text search) anyway.
So, in the end, I just keep them in the Documents directory. Some, most commonly used are also in my email. That's it.
Here's an interesting aspect of these: I did lose my college papers a while ago, and when I asked my college if they can produce a copy, they told me that they keep their records for just seven years. So, they had nothing. The high-school I went to doesn't exist anymore. So, if I had to recover my high-school-related papers, I'd have none. But, if I really had to, I could recover my birth certificate, as those don't seem to have an expiration date.
Anyways. In terms of storing digital copies, very little of that is relevant. Even ten years ago most authorities wouldn't be able to accept digital copies. Even today, the municipality of the city I live in won't take digital copies. There's no process through which I could have a digital copy they would recognize.
So, I need to keep hard copies. And the digital copies? -- well, they are perishable. I keep them for convenience, because every now and then I run into some situation where they are accepted. But losing them won't be a big deal as I can always make more of those. So, I don't need any exceptionally reliable storage requirement for the digital documents. It's more like a cache, which can be eventually retired.
Important digital files are all on our family computer which is backed up to a cloud service which will mail me a disk to do a restore if needed. This includes all our photos and videos from since we've had digital cameras. If both my wife and I both die, no one will have any clue how to deal with this and that's OK.
Photos we really like are printed and in photo albums organized by date. We'll lose these in a house fire and that's a risk we're willing to accept. The ability to easily pull a physical album and see pictures from a past time grouped together and curated is something we really like.
if you're willing to share: do you worry about their security or do you feel that they're at least as secure as what you could do yourself or other services might do?
Most recent years all letters are however photographed on a phone and put into relevant shared photoalbums, then shredded. Albums by year and category e.g. "School docs", "Kids School work", "kids art", bills, statements, manuals and instructions, receipts, etc. Still have a big chore to go through all the old folders to scan and shred so we can really be paperless.
A few times I have had to dig out old bank statements or proof of address on a recent bill. However they all just wanted a photo of it, so storing it digitally was fine.
iPhones have very nice scanning tools built in, but it’s buried in the Notes app. Create a new note, click the camera icon, then “scan documents” and it will create a very nice, usually well cropped and OCRd scan that’s saved as a PDF you can then export elsewhere. Wish it was a standalone app because it works so well, and this is from someone who helps digitize and preserve paper documents for a living.
I agree it's great to be able to do this natively on iphone without third-party apps.
one problem I've found with notes is that they don't appear to have any kind of export mechanism - i.e., you're tied to apple and that app. Is that right?
In the "Files" app, tap the (...) icon in the top right corner and select "Scan Documents".
A) Mint for most financials. iCloud for storage of documents.
B) Apple Health for keeping track of my records. For ad-hoc stuff I use iCloud to store the documents.
C) Product and service info I use iCloud for. Logins and credentials to them are stored in my family's 1Password vault.
D) All legal documents stored on iCloud.
E) For photos and videos I use iCloud Shared Albums. It's unlimited free online storage of photos. Otherwise it's a mix of iCloud storage and the Notes app on Apple devices.
Obviously you can tell I'm deep in the iCloud ecosystem but personally I feel it's worth it. The synchronization and ease of use for my family is well worth it. For what it's worth I'm on the 200GB plan.
for example, my photos could get deleted on my iphone accidentally and that change would sync with all my other devices and that data would be lost forever.
what happens if all your files get deleted from your computer and then they're deleted from your trash can in the same instance?