Linux - GeneralThis Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
I am looking for web page design tool which will allow rapid prototyping (with automated php code generation) of a web interface into postgresql whilst running it on a linux machine with Apache.
The main requirements of the web page are :
High security log in – ssl / https
Easy creation of table data presentation – add,delete,modify entries etc …
Configurable Search and Filter capabilities including conditional filtering and being able to sort by more than one column
multiple windows on the same database in the same log-on session.
multiple users of the web page at the same time on the same data
low development license cost
zero run-time costs
I was almost set on dbQuickSite but they do not offer encryption and they do not support postgresql.
Can I easily add an encryption module ?
Should I stick with MySQL (see below regarding stored procedures)?
Also they say they cannot present multiple windows on the same database in any given session ?
Stored Procedures are key in my application. So I am favouring postgresql over mysql because at the present time, stored procedures are much more tried and tested and better documented than in Mysql. – would you agree ?
I am concerned though about performance and I have heard that mysql can be faster than postgres – is this significantly true in the
case of stored procedures ?
Any thoughts would be very much appreciated as I am getting a very confused picture so far …
Should I continue looking for a tool ?
Pay someone to do it for me and hand-maintain the php code – keeping some expertise in house ?
Do it myself and hand-maintain the php code myself - keeping all expertise in house ?
I am not a php expert but the way the business seems to be going is
along the lines of auto-code gen.
Modifying the web page must be a fast and easy process.