vFront (User front-end for MySQL and PostgreSQL databases)
-
So doing some side projects, and I am being empowered by this application:
I recommend all of the Database admins, and IT starters and medium level to check it out, it is very interesting, neat and active project, all done by: marcel loverona
You can donate to him here:
https://www.paypal.com/donate/?token=x1ga26nQJFKWio_jhWY2CsO_azO2H4lirtcgX6cxB-i_LYgVRnRWt70I_z-8QjP-XmvdZW&country.x=IT&locale.x=In Italy is its called donazione , everything is a YION in italy , please continuoin readion my guidion:
So what vfront does, is Rapildy build apps, the same way I came across Oracle 10g express builder, and the beauty of it, it does not touch your Database, it stores all its options and config, in an external DB (sqlite), you can also save it in your database as well, it will create separate table.
Supports
MySQL
MariaDB
PostgreSQLAll you have to do is create the DB schema with business logic (keys,indexes,relationship,triggers...etc), and make sure you have database user that has privileges to allow access remotely = user at % host.
Then drop the vFront folder to writable directory, in the same server or to an another server with Apache + PHP (nginx should work too), and access that web directory, and complete a very easy wizard to instruct the vFront about the whereabouts of your database.
Then you will have admin login, and you can create users and groups and easily give each user permission to view only /edit/add/delete...etc
It has 1 con, it does not allow file uploads in your DB even if you made a correct column with a BLOB type, it seems it uses a workaround for this and uses its internal DB.
All in all it is very good RAD tool for DBs, Rapid Application Development.
No screenshots, cause it is very easy to deploy and use, and spares you having to develop PHP frontend, works good for small 2 medium projects/business and truly 1 of kind.
Demo:
http://www.vfront.org/screenshots.php
http://www.vfront.org/demo.php?demo1 -
I've recommended vFront several times in the last few weeks to people who were looking at Access, in fact.
-
I have rounded up many tools like vFront, and they all state to do the same, but was unable to find anything with its simplicity and accuracy, and actually works.
I dont know why there is not a big opensource app like this that is better funded as such as PhpMyAdmin, I like phpmyadmin, and the amount of development put into it, but why not create something simple for end users as a target, and it seems vFront is the only thing like this.
-
@emad-r said in vFront (User front-end for MySQL and PostgreSQL databases):
I have rounded up many tools like vFront, and they all state to do the same, but was unable to find anything with its simplicity and accuracy, and actually works.
I dont know why there is not a big opensource app like this that is better funded as such as PhpMyAdmin, I like phpmyadmin, and the amount of development put into it, but why not create something simple for end users as a target, and it seems vFront is the only thing like this.
Maybe because just writing the software itself was so easy already
-
That's awesome. I've always been using Adminer (https://www.adminer.org/) when I need to manage databases.
-
@black3dynamite said in vFront (User front-end for MySQL and PostgreSQL databases):
That's awesome. I've always been using Adminer (https://www.adminer.org/) when I need to manage databases.
This isn't for managing them, this is for creating simple front ends, like Access used to do.
-
OK this is cool, thanks for posting this!
-
@scottalanmiller said in vFront (User front-end for MySQL and PostgreSQL databases):
@black3dynamite said in vFront (User front-end for MySQL and PostgreSQL databases):
That's awesome. I've always been using Adminer (https://www.adminer.org/) when I need to manage databases.
This isn't for managing them, this is for creating simple front ends, like Access used to do.
Ok, that makes more sense now.
The VFront Administration for DB Administration uses Adminer. Just have to enable the plugin.
-
@black3dynamite said in vFront (User front-end for MySQL and PostgreSQL databases):
@scottalanmiller said in vFront (User front-end for MySQL and PostgreSQL databases):
@black3dynamite said in vFront (User front-end for MySQL and PostgreSQL databases):
That's awesome. I've always been using Adminer (https://www.adminer.org/) when I need to manage databases.
This isn't for managing them, this is for creating simple front ends, like Access used to do.
Ok, that makes more sense now.
The VFront Administration for DB Administration uses Adminer. Just have to enable the plugin.
Correct, this is there for quick edits, but why use those when there are enterprise solutions like MySQL Workbench.
-
@emad-r said in vFront (User front-end for MySQL and PostgreSQL databases):
@black3dynamite said in vFront (User front-end for MySQL and PostgreSQL databases):
@scottalanmiller said in vFront (User front-end for MySQL and PostgreSQL databases):
@black3dynamite said in vFront (User front-end for MySQL and PostgreSQL databases):
That's awesome. I've always been using Adminer (https://www.adminer.org/) when I need to manage databases.
This isn't for managing them, this is for creating simple front ends, like Access used to do.
Ok, that makes more sense now.
The VFront Administration for DB Administration uses Adminer. Just have to enable the plugin.
Correct, this is there for quick edits, but why use those when there are enterprise solutions like MySQL Workbench.
Yep, I use that too.
But I do get a Connection Warning about an incompatible/nonstandard server or connection protocal detected (10.2.10) when connecting to MariaDB.
