Ask HN: Anyone interested in an offline version of Stack Overflow?

16 points by theolivenbaum ↗ HN
Hi, Rafael here from https://curiosity.ai.

I was just talking to someone today that works in a restrictive IT environment (no internet), and the person mentioned how annoying it is to not have access to Stack Overflow. There is an open source project on GitHub (https://github.com/tools4j/stacked-off) that seems to provide an offline server using the public dumps, but this person found it a bit cumbersome to work with.

As we build a desktop search app, we could add an offline Stack Overflow integration. I was curious (!) if anyone would be interested before taking the effort to build it.

WDYT?

10 comments

[ 166 ms ] story [ 3705 ms ] thread
One solution is to have an offline virtual machine that is configured not to speak to the public Internet, and do your coding in that. If you need to lookup something online, the host machine can do that and it can be copy and pasted from the host to the offline VM (Virtualbox allows you to do this).
If the restrictions were for security, this wouldn't work - the host could access the VM.
I'm thinking we could use Postgresql as backend, import all xml files as tables and then build a simple frontend with whatever language people are comfortable about.

Then you only need to do a monthly or quarterly update.

> in a restrictive IT environment (no internet)

I think the question is why?

Is it a real security risk or simply cargo culting?

I've mentioned before that this already exists. The NSA maintains mirrors of Stack Overflow and Wikipedia that get synchronized from the Internet to classified airgapped networks once every 24 hours. I have no idea what the software is they've used to do it, but you could arguably file a FOIA request or something since the code they're using has no reason to be classified. They've open-sourced simple tools and libraries like this in the past.