Database viewer
Summary
Database viewer is a tool that helps to keep track of bacterial or enzymatic stocks in our group.
The stocks of bacterial/enzymatic samples are frozen and stored in liquid nitrogen or in -70C storages.
In order to obtain instant information concerning location of the samples the database viewer can be used.
The program usage is not limited to bacterial or enzymatic records only, but rather can be applied to any types of stored materials.
Click below to download db_viewer (c++ executables, Ver. 1.13, limited functionality) as a zip archive, which includes the program and a sample database file.
Click below to download db_viewer (PyQt executables, Ver. 2.28, extended functionality) as a zip archive, which includes the program and a sample database file. Note! Requires Microsoft Visual C++ 2008 Feature Pack Redistributable Package
The program usage is not limited to bacterial or enzymatic records only, but rather can be applied to any types of stored materials.
Features:
- Works as stand-alone application (C++ executables, Python executables), or Matlab function;
- Connection to databases in Microsoft Access/SQLite3 formats, possibly to any ODBC compatible database;
- Fast database search;
- Viewing/editing of databases;
- Backups;
- Log files
- Printing of sorted data sets
- With some limitations can be used with any MS Access database (check Help).
Requiremens:
- Windows OS
- Installed ODBC Driver (check Help/About)
- The proper ODBC driver has to be selected from the Settings menu during the first run of the PyQt version
History:
- Ver 1.00 - First stable release
- Ver 1.13 - Some updates and fixes, last version of C++ executables
- Ver 2.00 - Written in Python, offers extended functionality
- Ver 2.10 - Compatible with SQLite3 database driver, Finnish translation
- Ver 2.20 - Stretching of the last column, Log files
- Ver 2.21 - Printing added, improved backup
- Ver 2.22 - Password check added
- Ver 2.23 - Fix of adding a first element into an empty table, warning message for the first run
- Ver 2.24 - Added Help pages
- Ver 2.25 - Fix of comma as decimal symbol
- Ver 2.26 - Shows the data with respect to text in the customSearch field
- Ver 2.27 - Clear of the Search field when open the database
- Ver 2.28 - Fix in removal of old backup files
Click below to download db_viewer (c++ executables, Ver. 1.13, limited functionality) as a zip archive, which includes the program and a sample database file.
Download c++ version
Download c++ version, source code
Click below to download db_viewer (PyQt executables, Ver. 2.28, extended functionality) as a zip archive, which includes the program and a sample database file. Note! Requires Microsoft Visual C++ 2008 Feature Pack Redistributable Package