GNU Health/The Demo database
Introduction to the Demo Database
GNU Health default installation comes with no data. It's interesting, for academic and training purposes to have some demo data that exemplifies concepts and improves the learning curve.
The demo database is an ongoing project and it will be adapting to the each new GNU Health version. The clinical history will also grow with time.
For consistency sake, it's important to have the main characters information constant (family members name, birth dates and place, health centers, family doctors etc.). The information and characters are fictitious and we should try to make it valid for different cultures.
The Zenon-Betz Family
The story goes around the Betz family, and the main character, Ana Betz, a primary school teacher.
- Health Center: GNU Solidario Hospital in Las Palmas, Spain
- Family Doctor: Cameron Cordara
- ID: 765870
- Speciality: Family Medicine
- Institution: GNU Solidario Hospital
- Family: Zenon-Betz family
- John Zenon (SSN: 40556644)
- Ana Betz (SSN: 55567890) born October 4th, 1985, the main character
- Matt (SSN: 97234436), born March 15th 2010, their son
- Sex: Female
- Marital Status: Married
- Profession: School teacher
- Education Level: University
- Domiciliary Unit
- Housing Conditions: Comfortable and good sanitary conditions
- Socio-Economic Status: Middle class
- Allergies: β-lactam hypersensitivity
- Diseases: Type 1 Diabetes diagnosed on November 10th 1993
- Medication: Insulin since November 10th 1993
- Genetic Information
- Family history
- Maternal Grandfather: Marfan's Syndrome (Q87.4)
- Father: Essential (primary) hypertension (I10)
- Disease Genes
- BRCA1: breast cancer 1, early onset
- Family history
- Obstetric Information: G1P1A0
- Newborn: Matt, epidural, vaginal birth
- Addictions: No recreational drugs
- Sexuality: Heterosexual, monogamous, practices safe sex
- Safety: Motorcycle rider, uses helmet
- Family information (Family functionality level, members, operational sectors...)
- Imaging (X-rays, CTs, MRIs...)
- Genetic info / risks
- Lab orders and results
- Clinical history of the family
Online Demo Database
We have a community server available in the Internet so you can connect and try the latest GNU Health. This is probably the simplest way to check out GNU Health for the first time.
To use the GNU Health Demo Database, please proceed as follows:
1. Download and install the Tryton client application, according to your operating system:
- Please note that the version of the Tryton client must match the version of the Tryton server. Otherwise you will not be able to connect to the community server ("Network Error: Connection refused!"). So if you have already installed the Tryton client, please verify the version number before continuing. Currently, the community server runs on Tryton 4.2
2. Set the correct tabs position as described in "Setting the Tryton client Tabs position for GNU Health"
3. Connect to the GNU Health Demo Database using the following information:
Note : The community server database resets itself everyday at 00:30 UTC , so we have clean demo data. That means that you can also play and experiment with it without fear of "breaking" the DB :) .
For developers : There is a developer database ("air32") that runs on the latest development version. To connect to the developer community server, use port 9555, with the same credentials. Needless to say, the developer version is highly unstable, and is just for testing new functionality.
Local Demo Database
This method should give the most up-to-date demo database with the fewer issues in the future.
With your gnuhealth user, change to your home directory (ie, /home/gnuhealth)
$ cd $HOME
First, as gnuhealth user, we download the newest demo database and attachment dir.
wget http://health.gnu.org/downloads/postgres_dumps/gnuhealth-3.0.1-demo-data.tar.gz $ tar -xzvf gnuhealth-3.0.1-demo-data.tar.gz
Second, we create an empty database to import the demo database into
$ createdb --encoding=unicode --database=health30
$ createdb --encoding=unicode health30
Third, we import the database
$ psql gnuhealth_demo < health301.sql
$ psql health30 < health301.sql
Finally, we make sure that the "path" entry on the gnuhealth server configuration file is pointing to the right directory
You should see a line under the [database] section like this
path = /home/gnuhealth/attach
That is the value by default, so if you have not changed it, it should be OK.
Now enter the database through Tryton client (as non-gnuhealth user)
- Database: health30
- Username: admin
- Password: gnusolidario
There is a user "admin_es" that uses the Spanish language.
- Optionally 1>/tmp/log 2>/tmp/err may be added at the end of the line. For large databases and not so large computers, it could accelerate the load, while providing some clues just in case.