Description of the database

Message boards : Server programs : Description of the database
Message board moderation

To post messages, you must log in.

AuthorMessage
Dorian

Send message
Joined: 16 Apr 15
Posts: 3
United Kingdom
Message 61633 - Posted: 16 Apr 2015, 14:18:26 UTC

Hello, after several days of research, I still do not find full documentation on MySQL architecture BOINC.
I am currently in the process of creating a graphical user interface in order to view the mass of data stored.

I would like know if there is a detailed description of the different tables and columns, and their possible status code.

Thank you in advance, and if you need more information, I remain at your disposal.

Dorian
ID: 61633 · Report as offensive
Richard Haselgrove
Volunteer moderator
Volunteer tester
Help desk expert

Send message
Joined: 5 Oct 06
Posts: 2412
United Kingdom
Message 61635 - Posted: 16 Apr 2015, 14:42:15 UTC - in response to Message 61633.  

I don't know of any documentation, but the 'schema' files in http://boinc.berkeley.edu/gitweb/?p=boinc-v2.git;a=tree;f=db have the formal code needed to generate the tables and indexes.

Be aware that some fields have been recycled and are no longer used for the purposes their names suggest...
ID: 61635 · Report as offensive
Dorian

Send message
Joined: 16 Apr 15
Posts: 3
United Kingdom
Message 61762 - Posted: 21 Apr 2015, 9:58:21 UTC - in response to Message 61635.  

I don't know of any documentation, but the 'schema' files in http://boinc.berkeley.edu/gitweb/?p=boinc-v2.git;a=tree;f=db have the formal code needed to generate the tables and indexes.

Be aware that some fields have been recycled and are no longer used for the purposes their names suggest...


Thank you for your reply.
It looks like it lacks a bit of documentation on this subject, which could be very useful. (Description of columns, return codes...)
ID: 61762 · Report as offensive
Profile Ageless
Volunteer moderator
Project administrator
Volunteer tester
Help desk expert
Avatar

Send message
Joined: 29 Aug 05
Posts: 12091
Netherlands
Message 61763 - Posted: 21 Apr 2015, 10:09:18 UTC

http://boinc.berkeley.edu/trac/wiki/DataBase
Jord
Only partially available.
Please do not private message me for tech support. Use the forums for that. Tech PMs will be ignored.
ID: 61763 · Report as offensive
Profile Ageless
Volunteer moderator
Project administrator
Volunteer tester
Help desk expert
Avatar

Send message
Joined: 29 Aug 05
Posts: 12091
Netherlands
Message 61791 - Posted: 21 Apr 2015, 17:41:53 UTC
Last modified: 22 Apr 2015, 13:03:19 UTC

I asked David about this:

- The table definitions (SQL) are in boinc/db/schema.sql
http://boinc.berkeley.edu/gitweb/?p=boinc-v2.git;a=blob;f=db/schema.sql;h=cc4dbcb37b9f8df7484abf10aa0a5e7ff446efa4;hb=master

- The various fields are documented in the corresponding .h file,
boinc/db/boinc_db_types.h:
http://boinc.berkeley.edu/gitweb/?p=boinc-v2.git;a=blob;f=db/boinc_db_types.h;h=22ce07d2e1d1d746400b31705d42a413abf17ae2;hb=master
... and in lib/common_defs.h:
http://boinc.berkeley.edu/gitweb/?p=boinc-v2.git;a=blob;f=lib/common_defs.h;h=cd50472816d93ad307f410c449b31f8a1abe839c;hb=master
Jord
Only partially available.
Please do not private message me for tech support. Use the forums for that. Tech PMs will be ignored.
ID: 61791 · Report as offensive
Dorian

Send message
Joined: 16 Apr 15
Posts: 3
United Kingdom
Message 61812 - Posted: 22 Apr 2015, 12:57:41 UTC - in response to Message 61791.  

Thank you for your help!
These documents meet my needs.
If I have enough time to combine these documents, i will do it,it may help.
ID: 61812 · Report as offensive

Message boards : Server programs : Description of the database

Copyright © 2017 University of California. Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation.