473,320 Members | 2,124 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

advice for perl expert wanting to learn python

Now, why would I like to learn Python: because of IronPython port to CLR.
Perl port to CLR doesn't seem to be coming soon. First Perl6 for Parrot has
to be written, and then other backends..

What's the easiest way of learning python knowing perl? Is there somewhere
a 'how-to' cookbook with parallel examples of frequent idioms in perl and
python?

And most important thing, how does Python deal with database connectivity?
Is there a single API (akin to DBI) for connecting to databases?

How does Python support the following databases:
- Oracle
- Postgres
- MySQL
- SQLServer (maybe using freetds?)
- ODBC connectivity (connecting to MS Access)

Jul 18 '05 #1
13 1976
Zeljko Vrba wrote:
Now, why would I like to learn Python: because of IronPython port to CLR.
Perl port to CLR doesn't seem to be coming soon. First Perl6 for Parrot has
to be written, and then other backends..

What's the easiest way of learning python knowing perl? Is there somewhere
a 'how-to' cookbook with parallel examples of frequent idioms in perl and
python?
http://pleac.sourceforge.net/

And most important thing, how does Python deal with database connectivity?
Is there a single API (akin to DBI) for connecting to databases?
Yes, python has defined single API

How does Python support the following databases:
- Oracle
- Postgres
- MySQL
- SQLServer (maybe using freetds?)
- ODBC connectivity (connecting to MS Access)


I have tried MySQLdb package and mdb connectivity through
win32com.client package.
I read about Postgres and Oracle connectivity...

Stano Paska.

Jul 18 '05 #2
Zeljko Vrba wrote:
What's the easiest way of learning python knowing perl? Is there somewhere
a 'how-to' cookbook with parallel examples of frequent idioms in perl and
python?
A good start might be:

http://www.python.org/doc/Intros.html

under the "Introductions for programmers" heading.

Then there's http://www.python.org/doc/Comparisons.html#perl which has
direct comparisons.

And most important thing, how does Python deal with database connectivity?
Is there a single API (akin to DBI) for connecting to databases?
There is a DB-API standard, which is implemented by the various connectors.

How does Python support the following databases:
- Oracle
- Postgres
- MySQL
- SQLServer (maybe using freetds?)
- ODBC connectivity (connecting to MS Access)


Well.
Richard

Jul 18 '05 #3
On Tue, 3 Aug 2004 07:39:46 +0000 (UTC),
Zeljko Vrba <mo****@fly.srk.fer.hr> wrote:
What's the easiest way of learning python knowing perl? Is there somewhere
a 'how-to' cookbook with parallel examples of frequent idioms in perl and
python?


Jak Kirman wrote one around 1996. I've just put a copy in the Python wiki at
http://www.python.org/moin/PerlPhrasebook .

--amk
Jul 18 '05 #4
Zeljko Vrba <mo****@fly.srk.fer.hr> writes:

What's the easiest way of learning python knowing perl? Is there somewhere
a 'how-to' cookbook with parallel examples of frequent idioms in perl and
python?


There's this one:

http://makeashorterlink.com/?P6C226BF8

but it's a bit dated (probably good for simple stuff, though)...

Cheers,

--
ma***@reimeika.ca
Gunnm: Broken Angel http://amv.reimeika.ca
http://reimeika.ca/ http://photo.reimeika.ca
Jul 18 '05 #5
Zeljko Vrba wrote:
Now, why would I like to learn Python: because of IronPython port to CLR.
Perl port to CLR doesn't seem to be coming soon. First Perl6 for Parrot has
to be written, and then other backends..

What's the easiest way of learning python knowing perl? Is there somewhere
a 'how-to' cookbook with parallel examples of frequent idioms in perl and
python?

And most important thing, how does Python deal with database connectivity?
Is there a single API (akin to DBI) for connecting to databases?

How does Python support the following databases:
- Oracle
- Postgres
- MySQL
- SQLServer (maybe using freetds?)
- ODBC connectivity (connecting to MS Access)


I have used Oracle, SQLServer and Access via ADO - try adodpapi.sf.net
which is a wrapper for ADO to the Python DB-API.
But note that you may well not be able to use any of this database stuff
from IronPython

David
Jul 18 '05 #6
David Fraser <da****@sjsoft.com> writes:
Zeljko Vrba wrote:
Now, why would I like to learn Python: because of IronPython port to CLR.
Perl port to CLR doesn't seem to be coming soon. First Perl6 for Parrot has
to be written, and then other backends..
What's the easiest way of learning python knowing perl?
For experienced scripters, I find Beazley's "Python Essential
Reference" is excellent. You already know what you want, just need to
see how Python does it, and don't need a lot of handholding. Get a
copy of "Python Cookbook" too, and scan that. Then rewrite one of
your exsiting perl scripts.
Is there
somewhere
a 'how-to' cookbook with parallel examples of frequent idioms in perl and
python?
An interesting variant on that is my pyperlish module, at
http://www.seanet.com/~hgg9140/comp/index.html

You can either use it as-is, or read the code to see how to emulate
perl in python. NOTE: I do not recommend using pyperlish once you get
the hang of python.

And most important thing, how does Python deal with database
connectivity?
Is there a single API (akin to DBI) for connecting to databases?
How does Python support the following databases:
- Oracle
- Postgres
- MySQL
- SQLServer (maybe using freetds?)
- ODBC connectivity (connecting to MS Access)


I have used Oracle, SQLServer and Access via ADO - try adodpapi.sf.net
which is a wrapper for ADO to the Python DB-API.
But note that you may well not be able to use any of this database
stuff from IronPython

David


More cross-platform and cross-DBMS is to code to the DB-API 2.0:
http://www.python.org/topics/database/

--
ha************@boeing.com
6-6M21 BCA CompArch Design Engineering
Phone: (425) 342-0007
Jul 18 '05 #7
Harry George wrote:
David Fraser <da****@sjsoft.com> writes:
Zeljko Vrba wrote:
And most important thing, how does Python deal with database
connectivity?
Is there a single API (akin to DBI) for connecting to databases?
How does Python support the following databases:
- Oracle
- Postgres
- MySQL
- SQLServer (maybe using freetds?)
- ODBC connectivity (connecting to MS Access)


I have used Oracle, SQLServer and Access via ADO - try adodpapi.sf.net
which is a wrapper for ADO to the Python DB-API.
But note that you may well not be able to use any of this database
stuff from IronPython

David

More cross-platform and cross-DBMS is to code to the DB-API 2.0:
http://www.python.org/topics/database/


Thats why I said to look at adodbapi.sourceforge.net although I misspelt
it - it is DB-API 2.0 compliant.

David
Jul 18 '05 #8
Zeljko Vrba <mo****@fly.srk.fer.hr> wrote in message news:<sl*******************@fly.srk.fer.hr>...
Now, why would I like to learn Python: because of IronPython port to CLR.
Perl port to CLR doesn't seem to be coming soon. First Perl6 for Parrot has
to be written, and then other backends..

What's the easiest way of learning python knowing perl? Is there somewhere
a 'how-to' cookbook with parallel examples of frequent idioms in perl and
python?

See the Perl/Python phrasebook:
http://www.python.org/moin/PerlPhrasebook

-- Marcel
Jul 18 '05 #9
David Fraser <da****@sjsoft.com> wrote in message news:<ce**********@ctb-nnrp2.saix.net>...
Zeljko Vrba wrote:
And most important thing, how does Python deal with database connectivity?
Is there a single API (akin to DBI) for connecting to databases?

I have used Oracle, SQLServer and Access via ADO - try adodpapi.sf.net
which is a wrapper for ADO to the Python DB-API.
But note that you may well not be able to use any of this database stuff
from IronPython


Assuming you find yourself working with .NET -- as you would with
IronPython -- I would expect it to have access to the stock database
namespaces under whatever environment you're in: under MS's
implementation of .NET, System.Data.* (same under Mono?). This would
be the most likely line, since there's a lot of prior work in .NET
that targets that namespace, including UI controls.

For documentation, search for "ADO.NET". It's actually a pretty good
framework, and doesn't require a database connection to make use of it
(ie, you want an in-memory database, but don't need persistent
storage).

I don't know what Jim's planning to do with the Python db api, but
between the two, I'd personally use ADO.NET when available. I'd
suggest the IronPython email list (www.ironpython.org) for more
information.
Jul 18 '05 #10
Keith Farmer wrote:
David Fraser <da****@sjsoft.com> wrote in message news:<ce**********@ctb-nnrp2.saix.net>...
Zeljko Vrba wrote:


And most important thing, how does Python deal with database connectivity?
Is there a single API (akin to DBI) for connecting to databases?


I have used Oracle, SQLServer and Access via ADO - try adodpapi.sf.net
which is a wrapper for ADO to the Python DB-API.
But note that you may well not be able to use any of this database stuff
from IronPython

Assuming you find yourself working with .NET -- as you would with
IronPython -- I would expect it to have access to the stock database
namespaces under whatever environment you're in: under MS's
implementation of .NET, System.Data.* (same under Mono?). This would
be the most likely line, since there's a lot of prior work in .NET
that targets that namespace, including UI controls.

For documentation, search for "ADO.NET". It's actually a pretty good
framework, and doesn't require a database connection to make use of it
(ie, you want an in-memory database, but don't need persistent
storage).

I don't know what Jim's planning to do with the Python db api, but
between the two, I'd personally use ADO.NET when available. I'd
suggest the IronPython email list (www.ironpython.org) for more
information.


The disadvantage of using ADO.NET is that you'll lose the portability
advantages of the Python db API (i.e. you'll only be able to use the
code on IronPython).
The correct approach is to write a DB API-compatible wrapper for ADO.NET
:-) (as has been done for ADO)

David
Jul 18 '05 #11
Harry George <ha************@boeing.com> wrote in message news:<xq*************@cola2.ca.boeing.com>...
For experienced scripters, I find Beazley's "Python Essential
Reference" is excellent. You already know what you want, just need to
see how Python does it, and don't need a lot of handholding. Get a
copy of "Python Cookbook" too, and scan that. Then rewrite one of
your exsiting perl scripts.


OTOH, It should be a crime to purchase the Python Developer's Handbook
[1]. I'm glad I only paid six dollars for a used copy, because its a
load of crap.

[1] http://makeashorterlink.com/?H10123029
Jul 18 '05 #12
I'm surprised nobody mentioned Martin Brown's book "Perl to Python
Migration".

The reviews indicate that although it has a lot of typos it is useful.

Also, cheap. You can get a used copy for $2.50 (plus shipping) from
Amazon.

http://www.amazon.com/exec/obidos/tg...glance&s=books
Jul 18 '05 #13
In article <b1**************************@posting.google.com >,
Stephen Ferg <st***@ferg.org> wrote:

I'm surprised nobody mentioned Martin Brown's book "Perl to Python
Migration".

The reviews indicate that although it has a lot of typos it is useful.


Well, that is not a review I would make. I think it's just a couple of
notches better than "horrible" -- I believe any Perl programmer would be
much better off with a regular Python book.
--
Aahz (aa**@pythoncraft.com) <*> http://www.pythoncraft.com/

"To me vi is Zen. To use vi is to practice zen. Every command is a
koan. Profound to the user, unintelligible to the uninitiated. You
discover truth everytime you use it." --*****@lion.austin.ibm.com
Jul 18 '05 #14

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

75
by: Howard Nease | last post by:
Hello, everyone. I would appreciate any advice that someone could give me on my future career path. Here is my situation: I am a bright Junior in a very well-respected private high school, taking...
2
by: Randall Smith | last post by:
When I had been programming for a few years, I realised that as much as a love to learn, I can only explore and be proficient at a limited subset of technologies. I explored different languages to...
7
by: Alberto | last post by:
I was trying to understand the reasons why I should learn Python. More like a pros/cons about this language. Currently, I use C, C/C++, Java, Perl, Visual VB and was looking to see the usefulness...
31
by: surfunbear | last post by:
I've read some posts on Perl versus Python and studied a bit of my Python book. I'm a software engineer, familiar with C++ objected oriented development, but have been using Perl because it is...
5
by: Martin Piper | last post by:
Hi all. I've recently landed myself the position of trainee C++ programmer which I'm extremely pleased about, but also nervous. According to the feedback from the interview, I have a good...
3
by: alpha | last post by:
Hello, i was hoping someone in this group can give me a pointer in the right direction. I have no knowledge whatsoever about programming but am keen to learn. I want to learn a language which i...
8
by: Xah Lee | last post by:
i'm starting a yahoo group for learning python. Each day, a tip of python will be shown, with the perl equivalent. For those of you perlers who always wanted to learn python, this is suitable. (i...
0
by: alex23 | last post by:
On Jul 24, 11:53 pm, Brett Ritter <swift...@swiftone.orgwrote: I've never used Perl myself, so I can't comment on the quality, but this document was recommended earlier this week:...
28
by: Hussein B | last post by:
Hey, I'm a Java/Java EE developer and I'm playing with Python these days. I like the Python language so much and I like its communities and the Django framework. My friends are about to open a...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.