VFront
User front-end for MySQL and PostgreSQL databases

What is VFront
VFront is a free, open source front-end for MySQL or PostgreSQL databases written in PHP and Javascript. With VFront you can create forms for manage your data in AJAX style, different rules and privileges for groups, report in XML,HTML,PDF,statistics and much more. VFront is released under GPL license (version 2.0).
To whom and what VFront is useful
- VFront is useful for companies,brands or organizations, which use MySQL or PostgreSQL, in need of an easy consulting or modyfing access to database by their own employed whithout developing a specific client for that but simply using a web browser.
- Think about VFront as an interface tool for database, similar for some functions to MS access, but taking the lead with an easy access via web.VFront is not a database administration tool like phpMyAdmin and it's not replacing it : interface is for basic user working on data.
- VFront is created for non-expert users capable to work safely on data using an intuitive graphic interface.
- VFront is particularly useful when various and/or several users have to access to database using different privileges: a highly customizable system of groups and privileges makes access possible for various employed to specific tables or views, shows/hides specific fields, sets rules for input validation and keeps under control all the database activities.
- VFront has export data modules, statistics and report management based on xml, xsl and xsl-fo protocols.
- VFront can be useful too for those who, generically, are in need of an easy to install and configure database front-end.
The three VFront rules
Grabbing the paragraph shape from Asimov, we try now to express the general principles we used for developing VFront
- VFront won't dirty your database, won't create tables or added views to your DB and won't modify data on tables unless you want expressly do it by creating queries. It will create his own discreet rules DB (or a personal schema on PostgreSQL) indeed. It won't seize your DB but let you use it.
- VFront won't bypass rules set on your DB. Using VFront you can create new more restrictive bond rispect on those you made on your DB (in terms of foreign keys, accettable inputs on fields, etc) and not vice versa.
- VFront will work as much best, as the definition of your database has been stricter. VFront loves normalization, foreign keys, primary keys (better if numerics), comments on tables and fields, etc... garbage in, garbage out : no escape.
All updates, new versions or contributions will follow these guide lines.
System requirements
Here are listed briefly the general characteristics of the system. For more details see the manuals .
- Apache Web server, version 2.x
- PHP 5.x
- MySQL 5.x, PostgreSQL 7.4 or 8.x (PostgreSQL support is in beta state)
- Linux server (preferably), but can also work correctly under Windows server
Latest News
VFront 0.95l is out
23 Jul 2010
In this version:
Added improved english translation (thanks to John McClenahan!)
Fixed bug in updatable views (MySQL)
Fixed bug in Mysql Version Test
Added Labels values in custom buttons
Added default image for hotkeys
Add
VFront on alternativeto.net
22 Jul 2010
VFront is on alternativeto.net!
Please visit (and vote!) on http://alternativeto.net/desktop/vfront/
VFront 0.95i is out!
06 Jul 2010
In this release was added settings in Custom buttons for shadowbox.
Added PHP 5.3 compatibility
Fixed some bugs in UTF-8 encoding and better support for UTF-8
Added JS controls for postgres field type "numeric"
Changed rules for onlyr
VFront 0.95h is out!
29 Mar 2010
New features: added shadowbox for Custom buttons, mobile support added, export search results. New bug fix and enhancements.
VFront 0.95g is out
17 Mar 2010
This version has added a major new feature: Custom buttons.
With custom bottons you can create links from forms with variable parameters according to the records that you are watching.
New bugfix: in this version the update script was fi
VFront 0.95f is out
14 Mar 2010
In this version:
Added change user data for the administrator level 2 and 3 (only in vfront internal authentication)
Added iSchema class: VFront now no longer uses the INFORMATION_SCHEMA with Mysql (better performances)
Fixed report
VFront 0.95d is out!
22 Feb 2010
In the new version:
Fixed PostreSQL installation bug
Fixed PHP-CGI installation bug
Fixed delete option in link and attachments
Added new English translations
Fixed JS error in ENG install (password control)
VFront 0.95c: critical Windows bugfix
11 Nov 2009
The new VFront version has been released. In this version there are a major bugfix for the installation process in Windows
Bugfix in VFront 0.95b
06 May 2009
The new release is a bugfix in update process. Plese use this version
Last modified: 03/09/2010 - M.Marcello Verona 2007-2010 - marcelloverona at gmail dot com

