User front-end for MySQL and PostgreSQL databases
What is VFront
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.
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
29 Apr 2011
In this version:
Added support for non-numeric PK
Fixed some postgres specific queries
Fix ENUM type bug
Added sortin [...]
26 Jan 2011
In this version:
Switched the default language as English
Added SQLite as option as DB data
Added SQLite as method for VF registr [...]
10 Nov 2010
We are proud to present the VFront online demo! http://www.vfront.org/demo.php[...]
26 Oct 2010
In this version was added the table alias (labels for the VFront user). Some minor bugfix was fixed.
23 Jul 2010
In this version:
Added improved english translation (thanks to John McClenahan!)
Fixed bug in updatable views (MySQL)
Fixed bug [...]
Last modified: 18/05/2013 - M.Marcello Verona 2007-2010 - marcelloverona at gmail dot com