Provides a graphical user interface to view tables stored in MySQL databases and provides basic record editing, addition and delete functions.

DbiFace automatically detects table names, field names and types - so requires no configuration. You will need relevant permissions set on the database to enable the necessary functions.

DbiFace is work in progress and written for my own convenience. At present, form fields are provided as text boxes - except for boolean, date and integer fields - where basic validation is carried out. For more advanced validation, server-side validation might be an option.

If you have auto incrementing fields setup on the database, just leave these boxes empty when entering data.

DbiFace is not intended to be used to manage the database or server, to do this use MySQL Administrator, available from http://www.mysql.com/.

Security

DbiFace communicates with the server using the MySQL protocol, using TCP on port 3306 (by default). Transmissions are not encrypted. For privacy, you could tunnel data using a VPN or SSH connection.

DbiFace only uses the necessary permissions to carry out its functions, so it can be used to only view/edit/append data as necessary. See the MySQL Server documentation for details of how to set these permissions.

Copyright

DbiFace

Copyright (C) 2008 Tony Chung

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.

Download

Download - ver 1 - Java JAR - 53KB

MD5: 8acc15ae33b747b957e853ce5046d299

You also need the MySQL Connector JAR. You can get it from the MySQL site, or download the copy below.

Download - ver 5.1.6 - Java JAR - 687KB

MD5: 40be305ee91fb6a7a385eeb260c7c08a

Installation

The software is currently provided as a JAR file and does not need to be installed. First download both the JAR files into the same directory.

• Some operating systems will run the program if you double click the dbiface.jar file. Try this.
• Otherwise, open a terminal, change to the download directory and run: java -jar dbiface1.jar

< Back to Downloads.