Several information systems and application software suites use a RDBMS (Relational Database Management System) as a persistence mechanism for their own data. The range of RDBMS usage shows a tendency of expansion. Most RDBMSs are used as a background service for information systems and application software. However, such systems can also be accessed directly for data mining, quicker commercial operation and maintenance. An appropriate RDBMS can be chosen to match the characteristics of the target information system and application software. As a result, multiple RDBMSs are often used simultaneously in the same business operation and maintenance environment. However, multiple RDBMS usage is characterized by the following problems:
- Different data reference software applications need to be provided, which may increase the learning cost.
- Data reference software needs to be installed on each client-side PC. The cost of introduction is therefore higher with a greater number of client PCs.
CmdFreak is a relational database viewer (data reference software) that provides solutions for the above problems.
- CmdFreak supports the major free RDBMS MySQL, PostgreSQL and MariaDB systems, providing a common user interface for these RDBMSs and enabling data reference as a common operation. It does not need to learn different reference software applications for multiple RDBMSs, which helps to reduce related learning costs.
- CmdFreak works as web application software, and comes with an all-in-one installer incorporating web server software. This eliminates the need for web server pre-configuration and the use of script language. The introduction cost is practically zero.
CmdFreak provides the following functions for database reference:
- List records/paging
- Table selection
- Table information reference
- Column filtering and sorting
- DBMS selection
CmdFreak works on systems with the following specifications:
- CPU: 2 GHz or more
- Memory:1 GB or more
- Free disk space: 20 MB or more
- Operating systems/editions supported:
Windows 10
Windows Server 2016
Windows Server 2019 - Web browsers supported:
Microsoft Internet Explorer 11
Microsoft Edge
Google Chrome
Mozilla Firefox - DBMSs supported:
MySQL 5.7 (+ ODBC Driver: MySQL Connector/ODBC 5.3)
MySQL 8.0 (+ ODBC Driver: MySQL Connector/ODBC 8.0)
MariaDB 10.3 (+ ODBC Driver: MariaDB Connector/ODBC 3.0)
MariaDB 10.4 (+ ODBC Driver: MariaDB Connector/ODBC 3.1)
PostgreSQL 9.6 (+ ODBC Driver: psqlODBC 9.6)
PostgreSQL 12.2 (+ ODBC Driver: psqlODBC 12.1)
- Responsive design has been adopted for smartphone user.
- User management function has been added.
- Support for displaying unlimited record.
- Performance improvement for multiple user access.