GNU Health/The Demo database

From Wikibooks, open books for an open world
Jump to navigation Jump to search

Introduction to the Demo Database[edit]

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[edit]

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

Demographics Information[edit]

  • Sex: Female
  • Marital Status: Married
  • Profession: School teacher
  • Education Level: University
  • Domiciliary Unit
    • Housing Conditions: Comfortable and good sanitary conditions

Patient Information[edit]

  • 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
  • Obstetric Information: G1P1A0
    • Newborn: Matt, epidural, vaginal birth
  • Lifestyle
    • Ex-smoker
    • Addictions: No recreational drugs
    • Sexuality: Heterosexual, monogamous, practices safe sex
    • Safety: Motorcycle rider, uses helmet

Other Information[edit]

  • 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[edit]

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 GNU Health client (GNU/Linux, FreeBSD or other *NIX)

This is the recommended package. It contains all the functionality and plugins, is fully supported and, most importantly, it runs in Free operating systems. For security and philosophical reasons, please run the GNU Health client in Free/Libre operating systems.

Latest GNU Health client

You can also use the GNU Health client package shipped from your distro, like openSUSE.

For MacOS and Windows, you can download the Tryton client.


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. 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[edit]

Manual Installation[edit]

This method should give the most up-to-date demo database.

As the gnuhealth user, change to the home directory

$ cd $HOME 

Download the newest demo database from the download directory

$ wget

Extract the archive.

$ gunzip -c gnuhealth-3.2rc1.sql.gz > healthdemo.sql

Create an empty database to hold the demo database.

$ createdb --encoding=unicode healthdemo

Import the demo database.

$ psql healthdemo < healthdemo.sql 


Finally, we make sure that the "path" entry on the gnuhealth server configuration file is pointing to the right directory

$ editconf

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: healthdemo
Username: admin
Password: gnusolidario

There is a user "admin_es" that uses the Spanish language.


  1. 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.

Different ways to test GNU Health · The Live-CD