Skip to main content

A web based application for storage and organization of data regarding experimental data.

Project description

ExperimentDB

The experimentDB is a web-based application for the storage, organization and communication of experimental data with a focus on molecular biology and biochemical data. This application also stores data regarding reagents, including antibodies, constructs and other biomolecules as well as tracks the distribution of reagents. There is also some preliminary interfaces to other web resources.

ExperimentDB Installation

Configuration

ExperimentDB requires both a database and a webserver to be set up. Ideally, the database should be hosted separately from the webserver and ExperimentDB installation, but this is not necessary, as both can be used from the same server. If you are using a remote server for the database, it is best to set up a user for this database that can only be accessed from the webserver. If you want to set up several installations (ie for different users or different laboratories), you need separate databases and ExperimentDB installations for each. You will also need to set up the webserver with different addresses for each installation.

Software Dependencies

  1. ExperimentDB source code. Download from one of the following:

  1. http://github.com/davebridges/ExperimentDB/downloads for the current release

  2. http://github.com/davebridges/ExperimentDB for the source code

  3. from pypi by entering:

    pip install experimentdb

Downloading and/or unzipping will create a directory named ExperimentDB. You can update to the newest revision at any time either using git or downloading and re-installing the newer version. Changing or updating software versions will not alter any saved data, but you will have to update the localsettings.py file (described below).

  1. Python. Requires Version 2.6, is not yet compatible with Python 3.0. Download from Python.

  2. Django. Download from Django. This will be automatically installed if you installed experimentdb with pip. This will be automatically installed if you installed experimentdb with pip.

  3. Database software. Typically MySQL is used, but PostgreSQL, Oracle or SQLite can also be used. You also need to install the python driver for this database (unless you are using SQLite, which is internal to Python 2.5+). For more information see Instructions.

  4. Biopython Packages. Download and install from Biopython. This will be automatically installed if you installed experimentdb with pip.

  5. South. Install using pip (pip install south). This will be automatically installed if you installed experimentdb with pip.

  6. Django Ajax Select. Install using pip (pip install django-ajax-selects). This will be automatically installed if you installed experimentdb with pip.

  7. Python Imaging Library. Install using pip (pip install pil). Available at PIL. This will be automatically installed if you installed experimentdb with pip.

Database Setup

  1. Create a new database. You need to record the user, password, host and database name. Refer to the database documentation for how to do this with a specific database engine. If you are using SQLite3, you only need to set the engine and the database name. It is recommended to use MySQL.

  2. Go to localsettings_empty.py and edit the settings:

    ENGINE: 'mysql', 'postgresql_psycopg2' or 'sqlite3 depending on the database software used.
    NAME: database name
    USER: database user.  Unless using sqlite3
    PASSWORD: database password.  Unless using sqlite3
    HOST: database host.
  3. Save this file as localsettings.py in the main ExperimentDB directory.

  4. Run the test client by going into the experimentdb directory and running the following. There should be no errors at this point:

    python manage.py test
  5. Generate the initial database tables by entering:

    python manage.py syncdb
  6. When asked generate an administrative superuser and set the email and password.

Web Server Setup

You need to set up a server to serve both the django installation and saved files. For the saved files. I recommend using apache for both. The preferred setup is to use Apache2 with mod_wsgi. The following is a httpd.conf example where the code is placed in /usr/src/django/experimentdb:

Alias /static /usr/src/django/experimentdb/media
Alias /media /usr/src/django/experimentdb/media

    <Directory /usr/src/django/experimentdb/media>
    Order allow,deny
    Allow from all
</Directory>

WSGIScriptAlias /experimentdb /usr/src/django/experimentdb/apache/django.wsgi

<Directory /usr/src/django/experimentdb/apache>
    Order deny,allow
    Allow from all
</Directory>

If you want to restrict access to these files, change the Allow from all directive to specific domains or ip addresses (for example Allow from 192.168.0.0/99 would allow from 192.168.0.0 to 192.168.0.99)

Final Configuration and User Setup

  1. Go to experimentdb/admin/auth/users/ and create users, selecting usernames, full names, password (or have the user set the password) and then choose group permissions.

Project details


Release history Release notifications | RSS feed

This version

0.2

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

experimentdb-0.2.tar.gz (2.4 MB view details)

Uploaded Source

Built Distribution

experimentdb-0.2.win32.msi (426.0 kB view details)

Uploaded Source

File details

Details for the file experimentdb-0.2.tar.gz.

File metadata

  • Download URL: experimentdb-0.2.tar.gz
  • Upload date:
  • Size: 2.4 MB
  • Tags: Source
  • Uploaded using Trusted Publishing? No

File hashes

Hashes for experimentdb-0.2.tar.gz
Algorithm Hash digest
SHA256 9759963e6538c2ff546cef77c5abfd15128bb969dda48ead7736f6196527dca6
MD5 93b9c0a6d8fcf96b4a549f169033af03
BLAKE2b-256 d41dda304bf9a015e4454d1b39f65fe71f8ac08a5e45a8f912c28406cbe8abf0

See more details on using hashes here.

Provenance

File details

Details for the file experimentdb-0.2.win32.msi.

File metadata

File hashes

Hashes for experimentdb-0.2.win32.msi
Algorithm Hash digest
SHA256 9d2ed00230eb66680231ae029339e402a0401fd2385ecd74b3a9f741ec6f2fbb
MD5 0457c40ef2e797a3575ebd5e44f42f12
BLAKE2b-256 906e084da08d5f995096e07b98f6a4335e84b56c2a5e78c19326df478da515d1

See more details on using hashes here.

Provenance

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page