One of the things I rarely see mentioned when discussing career prospects of startups vs large corporations is how different their hiring filters are.
If you are self-taught, lacking credentials, and don't live in a major market, it can be difficult to get in the door at a FAANG. Whereas start-ups can be much more likely to take a chance on someone with a non-conventional background.
So for some of us, large corporations aren't even an option until after we've taken that startup job and the startup has done well enough that people have heard of it.
I suppose it depends on the method used for backup and restore. If you replace the entire graph.db directory with one from a backup, ids are kept intact.
I was relying on this just yesterday. We use graphenedb for our production database and I needed to load a production backup locally for testing. It was really useful that I could query a node by id both locally and on prod and get the same result.
I feel like the pattern of "solve this puzzle, get an interview" has fallen out of fashion in the past few years.
In 2012 I got an interview at facebook by solving a puzzle that involved adding weights to a recursive arrangement of levers on top of levers. I remember both having a lot of fun with the puzzle and knowing that I would have never landed the interview any other way because I was coming from a non-traditional background and still relatively junior.
I think Google's foobar came out a few years later. I had some fun with them and got through the first rounds, but by that point I already had a job and never got around to finishing it.
I also remember doing some fun puzzles on codeeval, hoping their business model of linking people to companies would gain some steam, but the companies they signed up never seemed to be very interesting.
Unfortunately, all of the programming jobs here are either in publishing (low pay) or government contracting (bureaucratic headaches).
And while the cost of living is less than NYC and SF, it ain't exactly cheap either.
Amazon's decision to come to Crystal City makes sense to me because there are a bunch of young college grads and no competition from the other FAANG companies.
If you're a young, ambitious, programmer trying to decide where to start your career though, I'd suggest going to SF/SV, NYC, Seattle, or Boston because those places provide more options.
For all the helpful advice offered both here and on Reddit about how to do this, I wish there had been more time asking if this was something the OP should be doing in the first place.
I completely understand the frustration if this is indeed the above set of films and it's been over eleven years since the digitization agreement and files have not yet been made freely available to the public.
That said, planning to use a researcher's pass to "set these treasures free" and blaming Amazon for not having generated more revenue from these films makes it sound like the OP thinks he knows better than the staff of the National Archives how to best care for these assets and that he knows better than the folks at Amazon how to turn a profit. To me, it sounds more than a little arrogant.
A big reason the National Archives enters into agreements like this with companies is that digitization, especially on their scale, is expensive. If it weren't for agreements like this, Amazon would only want to digitize the films for which they knew they could turn a profit and the vast majority of the collection would sit un-digitized and be at risk of loss. The tradeoff is between the immediacy of access vs the number of assets digitized and the team at NARA made the decision that it was better for the American people to have more assets digitized.
I'm worried that the next time NARA is in talks with someone about a digitization agreement (for example, if there's a large number of early jazz audio recordings on 1/4" reels and Spotify is interesting in paying the cost of digitization in exchange for 2-3 years of exclusivity) that the company will point to this example and say "didn't you just let a researcher publish the entire collection Amazon digitized? How can you assure us the same thing won't happen with these recordings?" The result will be the National Archives clamping down on researcher access. I think that would be a net loss for everyone.
If you are self-taught, lacking credentials, and don't live in a major market, it can be difficult to get in the door at a FAANG. Whereas start-ups can be much more likely to take a chance on someone with a non-conventional background.
So for some of us, large corporations aren't even an option until after we've taken that startup job and the startup has done well enough that people have heard of it.