Storing results in a local database

[PsychoSid]

Hello,

Anyone have any pointers if it's possible to store results locally in a database for easily retrieval ?

Our company policy is not to upload results to 3rd parties so cannot use the openbenchmarking solution.

Thanks

[Michael]

You could manually come up with something to parse the ~/.phoronix-test-suite/test-results/ yourself but we do offer licensing of Phoromatic and OpenBenchmarking.org for behind-the-firewall installations, etc.

[PsychoSid]

Thanks, and I do appreciate that. Sadly my budget is $0.00 so that limits my options somewhat.

[Michael]

Thanks, and I do appreciate that. Sadly my budget is $0.00 so that limits my options somewhat.

I'd recommend then checking out the pts_result_file.php and other objects then or just look at the pts-core/openbenchmarking.org/schemas/ etc then to understand the XML syntax. Should be fairly easy to do. You could almost hack it together easily. you can use merge-results and other commands locally for merging together the XML results, etc. If you need any pointers let me know.

[PsychoSid]

Will do. Thanks for the pointers appreciate it.

[Michael]

Will do. Thanks for the pointers appreciate it.

No problem, hope we're able to get something to work out for your needs. I can also be reached via michael at phoronix.com with any further questions, etc.

[PsychoSid]

Thanks I had an initial thought to output to JSON to throw into CouchDB or similar.

[Michael]

Thanks I had an initial thought to output to JSON to throw into CouchDB or similar.

Actually I might be able to add result-file-to-json sub-command... or you can easily modify such, just look at the result-file-to-csv output (found in pts-core/commands).

[PsychoSid]

Yeah that is what I was going to look into. PHP is not my strong suit so it may take a while....