Database and Web interfacing programming language?
Hello SuSE folks, Could somebody please share your personal experience what language/software is a best suited for the following need. Ability to retrieve/enter information from/to SQL database and display it in a form of table or graph in a Web interface. I'm using Perl for this things but may be you know a better solution? What is about Java, Java script, PHP and others. Please share your own experience pros and cons. Thank you in advance. Alex -- MS Windows users should be covered under the Americans with Disabilities Act! --------------> Try Linux and you'll understand why <--------------
On Sunday 13 May 2001 02:25 pm, Alex Daniloff wrote:
Hello SuSE folks, Could somebody please share your personal experience what language/software is a best suited for the following need. Ability to retrieve/enter information from/to SQL database and display it in a form of table or graph in a Web interface. I'm using Perl for this things but may be you know a better solution? What is about Java, Java script, PHP and others. Please share your own experience pros and cons. Thank you in advance. Alex
-- MS Windows users should be covered under the Americans with Disabilities Act! --------------> Try Linux and you'll understand why <--------------
PHP4 is much easier to use that PERL, imho. It's extremely easy.. almost frighteningly so. MySQL or PostgreSQL are the contenders for the SQL database, and it's up to you which you use. MySQL is supposed to be faster, but experienced DBA's and Programmers that are used to putting the SQL logic inside the DB (which MySQL doesn't do as well as PostgreSQL) would argue with that statement. Read all about them, and make your own informed decision :-) Javascript is a way to do fancy things with graphics and text on the client side. Since it is so well supported in all of the most popular browsers (IE4+, NS4+, Mozilla, and even Opera), you can go to town with it and know that it'll probably work. It's best to use Javascript for client side validation of form input, so that you don't have to make round trips to the server. You should still validate all form input on the server though, just in case the user has javascript turned off. Java Server Pages are supposed to be great too, but you'd have to ask someone else, as I have no experience with them. Have fun, and I hope this helps! -Steven
On Sunday 13 May 2001 18:01, Steven Hatfield wrote: You may want to consider zope and its integration and use of python. It's now mature enough to allow for integration of Java, perl, php and allows for rendering through apache and its supported modules. In fairness however DTML (the logic process) is a bitch to learn for non programers as myself and when they speak of the zen of zope, well there is something too that. On the other hand for programmers is a challenging joy. Zope is marvelouse in seperating logic from presentation allowing for a completely distributed (but organized) web development process. DB integration is well support with both OS and commercial dbs being made accessible. see: http://www.zope.org/Products/external_access and following references.(at the bottom of the page) See http://www.zope.org for more info and in particular take a look at the zope book available on line if this interests you. http://www.zope.org/Members/michel/ZB/ -- Best Chris
hello there alex in my experience i've used perl to input the data into the sql databases (because perl is more familiar territory) and i use php to retreive the data into webpages because it is way easier to do that in php plus php's webpage output is much easier to control since the php commands are imbeded in the html. i havent tried java so i cant advise on that . good luck :) jorge. On Sun, 13 May 2001, Alex Daniloff wrote:
Hello SuSE folks, Could somebody please share your personal experience what language/software is a best suited for the following need. Ability to retrieve/enter information from/to SQL database and display it in a form of table or graph in a Web interface. I'm using Perl for this things but may be you know a better solution? What is about Java, Java script, PHP and others. Please share your own experience pros and cons. Thank you in advance. Alex
-- MS Windows users should be covered under the Americans with Disabilities Act! --------------> Try Linux and you'll understand why <--------------
-- To unsubscribe send e-mail to suse-linux-e-unsubscribe@suse.com For additional commands send e-mail to suse-linux-e-help@suse.com Also check the FAQ at http://www.suse.com/support/faq and the archives at http://lists.suse.com
participants (4)
-
Alex Daniloff
-
Chris Herrnberger
-
Steven Hatfield
-
Th3 Hav3n's Keeper