Can you add a green to the votes to random questions on the whole questions list which are accepted by owner and add a checkmark on the accepted answer of question?
On the questions page:
On 2nd accepted question from questions page:
The accepted answer bumps to the top of the answers list unless it is the question asker's own answer, by ...
You can get the schema for the data dump and SEDE in this Meta Stack Exchange post.
The architecture of the production database is not available to non-corporate customers (if it's available at all). But, you can grab one of the public domain Stack Exchange clones; their schema is no-doubt similar.
This is not an official API, but it is not too hard to simulate the login via OAuth2 and use the session to start executing a query, poll the job that executes it and retrieve the results in the end. I do most of my Stack Exchange development work in Java, but it should be easy to port to other languages even if you don't know Java. I'm using fairly standard ...
I've been searching for a Stack Exchange offline version, for research purposes at my University, then I found this.
I have been trying to figure out how to exactly run the software program on my Mac OS X Yosemite. I have downloaded the entire data dump and everything that it requires:
Python, version 2.7.12
Java, version 1.8....
Additionally, if you need to import a data-dump to PostGreSQL (or MS-SQL), this will help:
It's very efficient with memory consumption, it uses the original schema, it checks the data (serialization to type - exception if invalid), and it works on Linux/Mono, too.
You could also add Firebird ...