Friday, June 12, 2009

Oracle + Python



It's been a long time I have visited Oracle web site. As, now a days I am not really working on technical stuff and some how missed visiting the site. When I was Googling about how I can connect to database from Python, interestingly I found some Oracle links. I just glanced through and really felt happy to see something about Python on Oracle site. It didn't mean that Oracle started promoting Python but it definitely started considering one of the fastest growing language. One more exciting news is a new forum has been started on OTN network for Python. The forum has many questions regarding cx_Oracle (a Python extension module that allows access to Oracle, you will see more posts on it soon) as of now. Cheers database programmers, now you have something new to try. Enjoy the following links and keep looking the space for more updates.


Article: http://www.oracle.com/technology/pub/articles/devlin-python-oracle.html

Forum: http://forums.oracle.com/forums/forum.jspa?forumID=376

Feed: http://delicious.com/OracleTechnologyNetwork/python


Wednesday, June 10, 2009

Difference between Apache Server and Tomcat Server

I was trying to use python for web programming and found I need some web server to execute them. When I went into to more details, Apache is recommended. So, I just wanted to check my system before installing a new software and I found Apache Tomcat server is installed already in my computer. It is installed along with the IBM Eclipse in fact. Then, I just jumped and tried to configure the Tomcat server to run Python scripts. I could not do it as there were no mentioned files in the TomCat Server. Then I caught some web developers around my desk and asked what is the difference between Apache Server and Tomcat Server? and I was answered "Apache is an organization/company and Tomcat is a product", I got the same answer may be with different words. Then I went back and tried the setup again (I didn't want to install another software, if I had already something to work with). Oooops, it didn't work again. At last I wanted to contact my Google uncle and here is the answer what I am looking for probably you too:

Apache Server:

~The Apache Httpd Server commonly referred to as Apache is powerful, flexible, HTTP/1.1 compliant web server

~Apache is primarily used to serve both static content and dynamic Web pages on the World Wide Web.

~Implementation: C

Tomcat Server:

~Apache Tomcat is a servlet container developed by the Apache Software Foundation (ASF). Tomcat implements the Java Servlet and the JavaServer Pages (JSP) specifications from Sun Microsystems, and provides a "pure Java" HTTP web server environment for Java code to run.

~Implementation: Java

So, the answer from my friends was not wrong, but there are two different web servers with different features. Finally, I realized that I could not work with Tomcat and downloaded and installed Apache server to work with Python for web.