Re: MySQL with Python

2012-10-15 Thread Roy Smith
In article , Dennis Lee Bieber wrote: > For routine database /access/ (that is, someone has created the > database user account that will be used), MySQLdb is the Python adapter > to connect to the server. For using THAT, you basically need to know SQL > (MySQL's flavor in particular), along wit

Re: MySQL with Python

2012-10-15 Thread Anurag Chourasia
Don't worry about what book you have (or don't have) in your Library..And let this not dictate your technology stack. PostgreSQL is one of the popular choice and you will never be short of documentation...Just Google and you will find lot of helpful tutorials... Regards, Anurag On Mon, Oct 1

Re: MySQL with Python

2012-10-15 Thread Chris Angelico
On Tue, Oct 16, 2012 at 1:47 AM, রুদ্র ব্যাণার্জী wrote: > On Tue, 2012-10-16 at 01:01 +1100, Chris Angelico wrote: >> But you may wish to consider using PostgreSQL instead. > Thanks, as I am very much new in database thing, I am not very aware of > the options I have. > But in my library, I did

Re: MySQL with Python

2012-10-15 Thread রুদ্র ব্যাণার্জী
On Tue, 2012-10-16 at 01:01 +1100, Chris Angelico wrote: > But you may wish to consider using PostgreSQL instead. Thanks, as I am very much new in database thing, I am not very aware of the options I have. But in my library, I did not found any thing on PostgreSQL. Though, I will google its supp

Re: MySQL with Python

2012-10-15 Thread Demian Brecht
On 12-10-15 06:45 AM, রুদ্র ব্যাণার্জী wrote: if yes, can you kindly suggest a book/reference on this? There are a few different ways to connect to MySQL, two of which are: For reference on connecting and querying MySQL through mysql-python, take a read through http://mysql-python.sourceforg

Re: MySQL with Python

2012-10-15 Thread Chris Angelico
t; > > I am new to python itself and gradually loving it. I mostly use it as an > alternative of shell-script. Since learning a new language for every new > project is not possible(its self assigned project, generally in free > time), can I do a "mySQL with python?" > >

Re: MySQL with Python

2012-10-15 Thread Anurag Chourasia
new language for every new > project is not possible(its self assigned project, generally in free > time), can I do a "mySQL with python?" > > if yes, can you kindly suggest a book/reference on this? > > -- > http://mail.python.org/mailman/listinfo/python-list > -- http://mail.python.org/mailman/listinfo/python-list

MySQL with Python

2012-10-15 Thread রুদ্র ব্যাণার্জী
e of shell-script. Since learning a new language for every new project is not possible(its self assigned project, generally in free time), can I do a "mySQL with python?" if yes, can you kindly suggest a book/reference on this? -- http://mail.python.org/mailman/listinfo/python-list

mysql with python

2008-12-18 Thread manojghimire
can anybody give me the link where I can directly download the _mysql.dll file required by MySQLdb for Python 2.6. I tried to build MySQL db but there is error: None. Is there a need for me to step down to Python 2.5 ?? Further any comments on the best ORM for Python ?? -- http://mail.python.org/m

Re: Performance Issues of MySQL with Python

2005-02-11 Thread Andy Dustman
Well, it does more than that. It converts each column from a string (because MySQL returns all columns as strings) into the appropriate Python type. Then you were converting all the Python types back into strings. So it's no mystery that using the command line client is faster, since it would take

Re: Performance Issues of MySQL with Python

2005-02-10 Thread Haibao Tang
There are no performance overhead except when you are dragging a huge chunk of information out of the database, in that case, python is converting the data to its tuple data type which adds one more processing. I found this when I didn't have the priviledge to do "mysql> SELECT * FROM TBL INTO OUT

Re: Performance Issues of MySQL with Python

2005-02-10 Thread Andy Dustman
There aren't any "issues", but there are a few things to keep in mind. First of all, prior to 4.1, MySQL does no parameter binding, which means that the parameters must be inserted into your SQL statements as literals. MySQLdb will do this for you automatically, but keep in mind that you will be c

Re: Performance Issues of MySQL with Python

2005-02-09 Thread Thomas Bartkus
"sandy" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi All, > > I am a newbie to MySQL and Python. At the first place, I would like to > know what are the general performance issues (if any) of using MySQL > with Python. > > By performance, I

Re: Performance Issues of MySQL with Python

2005-02-09 Thread Larry Bates
this area, YET. I hope my random thoughts are helpful. Larry Bates sandy wrote: Hi All, I am a newbie to MySQL and Python. At the first place, I would like to know what are the general performance issues (if any) of using MySQL with Python. By performance, I wanted to know how will the speed be, wh

Performance Issues of MySQL with Python

2005-02-09 Thread sandy
Hi All, I am a newbie to MySQL and Python. At the first place, I would like to know what are the general performance issues (if any) of using MySQL with Python. By performance, I wanted to know how will the speed be, what is the memory overhead involved, etc during database specific operations