Since there is interest in having all the data available on users in relation with the merit system to do all sort of analysis and investigations, i'm releasing in here a full version of the database used for
Tool to run online SQL queries over Full Merit Data(which will continue to use a limited subset of user information in order to have a light solution and avoid the database to grow too much)
The data will be updated possibly every one or two weeks, since it's 29k users at the moment and bound to grow.
You can download the latest version of the full database (SQLite database), with few scripts that will help you to extract the data here:
https://drive.google.com/open?id=1l0QQJl2NcAVwbXz49sSK6X5D1xmXxHlwHere is a brief description of the necessary step to use the database:Download the Precompiled Binaries for your favourite platform here (we just need the sqlite3):
https://www.sqlite.org/download.html"A bundle of command-line tools for managing SQLite database files, including the command-line shell program, the sqldiff program, and the sqlite3_analyzer program."
If you want to know more in detail how to use Sqlite3 directly:
https://www.sqlite.org/cli.htmlExample for usage under Windows platform, from command line:
Put the database, scripts and the sqlite3.exe in the same folder and you have everything you need to start:
Query.bat file:
sqlite3 btctalk_full.db < CommandsQuery.txt
CommandsQuery.txt:
.mode csv
.separator "\t"
.output ResultQuery.csv
SELECT * FROM UserData WHERE Activity > 1000;
.output stdout
.quit
Now from command line call Query.bat and after a bit of crunching you will get the data in the ResultQuery.csv tab separated.
If you just need to update your existing data by adding the trust you can simply substitute the query in CommandsQuery.txt with:
SELECT Username,Trust FROM UserData;
Each user data row specify when the data was read the last time through the column LastUpdatedData
If you need help or some clarification let me know.