1.0 first public release
- a CLI to pass queries written in SQL directly to the database
- a GUI ("Wizard") that can be used for simple queries to the database by less tech-savy researchers
- a pharmacovigilance tool (proportional reporting ratio & Chi square) for detecting new adverse drug reactions
- quite agnostic data view; OpenVigil could be used on similar databases (e.g., WHO/VigiBase)
- GUI redesign for better comprehensibility
- boolean concatenations between filtering condition instead of AND-only
- new query mode: show all data to a certain ISR (case number)
- new GUI ("Wizard in novice mode") for users unfamilar to the FDA database format
- Wizard in basic mode can now calculate single PRRs
- improved readability of human-readable result pages
- password protection for directly-passed SQL
- Support for reverse PRR analysis prepared (implementation planned for v2.0)
1.2.2 and 1.2.3
- Wizard-crafted SQL query is shown on the bottom of the tables
- minor bug fixes
- ROR and RRR support, PRR formula corrected
- information on the imported data (earliest to latest report)
- additional security (including CAPTCHAs) but also support for large requests and the use of an asterisk in SQL
- exact and similar matching for drugnames and adverse events
- new importer for FAERS datasets
Note that drugnames are free-text. OpenVigil 2 supports drugname mapping.
- import logfile and errors are now saved within the database and can be queried
- unification of initsql4aers and the three importers into one importer
Currently there is NO support for generation of images/graphs. This is planned for v2.1.
Ruwen Boehm, Holger Tag
The FDA AERS database can be downloaded from http://www.fda.gov/Drugs/GuidanceComplianceRegulatoryInformation/Surveillance/AdverseDrugEffects/ucm082193.htm. Download the ASCII-files and unpack the data-containing files only into one directory.
- Install a webserver, PHP and MySQL. Set up a SQL user account.
- Unpack OpenVigil (http://openvigil.sf.net) to a directory on your server. Configure sql.php and db.php according to your needs and settings.
- Initialise and populate the database with "php ./aers2sql_v2.php " (or enable the web functionality and run it from your browser).
- Put "openvigilXXX.php" somewhere on your webserver document directory, (rename it,) link to it!
Please refer to the tutorial or our recent publications concerning OpenVigil.