<div dir="ltr"><br><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div class="im">
> I have learnt python and used it for various purposes for scietific<br>
> computing using sage and GUI development using Tkinter and lots more. I<br>
> want to start web development using python My goal is to learn the web<br>
> development in python from the basic level and understand the big web<br>
> development projects like Django , MoinMoin Wiki , Plone and network<br>
> programming further with twisted.<br>
><br>
> I have found Web2Py to be an easy library to quickly use and develop the<br>
> web application. Is there any other library to start my development with.<br>
> and<br>
> does my plan of learning Web2Py is good for Web development and getting<br>
> involved in the big projects like Django , MoinMoin Wiki , Plone.<br>
><br></div>
<br>
Modulok suggested using ORM software. ORM should not really be needed if<br>
you are aiming at scientific content for your application, you should<br>
be fine with straight SQL (many consider ORM a hindrance rather than<br>
help for any project [1], [2]). But if you do find the need for ORM<br>
then SQLAlchemy is very good and is considered pretty much a de facto<br>
standard in the Python world.<br>
<br>
Good luck, and I'm sure comp.lang.python posters will be happy to help<br>
you with any problems you come across!<br>
<br>
[1] <a href="https://en.wikipedia.org/wiki/Object-relational_mapping#Controversy" target="_blank">https://en.wikipedia.org/wiki/Object-relational_mapping#Controversy</a><br>
[2] <a href="http://goo.gl/ECNSp" target="_blank">http://goo.gl/ECNSp</a><br>
<span class=""><font color="#888888"><br><br>
</font></span></blockquote></div><div class="gmail_extra">In SQLalchemy you can use straight SQL, or a database abstraction, or a full</div><div class="gmail_extra">ORM depending on your needs. The full ORM scared me at first. It was</div>
<div class="gmail_extra">over-complicated nonsense, black magic and I already had a background in SQL on</div><div class="gmail_extra">a console. I knew the exact queries I wanted. I didn't need this technical</div><div class="gmail_extra">
obfuscation wedged between me and greatness. However the more I used it the</div><div class="gmail_extra">more I started to like it. (Slowly!) It's kind of an acquired taste. It's not</div><div class="gmail_extra">
perfect for everything, but it's usually quite useful once you become</div><div class="gmail_extra">comfortable with it. Even so there are some valid points made against them.</div><div class="gmail_extra"><br></div><div class="gmail_extra">
The nice part about SQLalchemy over most other "orm" packages is it doesn't</div><div class="gmail_extra">really care how high or low level you interact with your data. It supports them</div><div class="gmail_extra">
all. You can do a raw SQL query on a cursor if you want. If you need more, you</div><div class="gmail_extra">can use the database abstraction. Or more still is setting up a full ORM.</div><div class="gmail_extra">You're never locked into anything.</div>
<div class="gmail_extra"><br></div><div class="gmail_extra">The down side to SQLalchemy however it is a very large library to learn. There</div><div class="gmail_extra">are books about it alone. For leaner requirements I use psycopg2, simply</div>
<div class="gmail_extra">because I use postgresql as my data store and it's pretty much the</div><div class="gmail_extra">pythyon/postgresql de-facto standard. Internally this is what SQLalchemy uses</div><div class="gmail_extra">
to access a postgresql database. If you're on MySQL or Oracle or whatever your</div><div class="gmail_extra">low level package will be different.</div><div class="gmail_extra"><br></div><div class="gmail_extra">What you use depends on your preferred learning style: top-down or bottom-up.</div>
<div class="gmail_extra">If you already know SQL the bottom-up approach of learning the low level lib</div><div class="gmail_extra">will serve you well and you'll feel more immediately productive.</div><div class="gmail_extra">
<br></div><div class="gmail_extra">Good luck!</div><div class="gmail_extra">-Modulok-</div></div></div>