MySQL for Python: Integrate the Flexibility of Python and the Power of MySQL to Boost the Productivity of Your Applications

There are too many mistakes in the coding provided as examples. I would have to work through other resources to correct the author's code. That is a very bad quality for a tutorial. Avoid.

There are a little simple example.But it was to explain detail and to useful information for me..So I recommended that book!

Based on the title, I was expecting in-depth coverage of Python's MySQL libraries, or at least for Python to be a main focus of the book. I was disappointed to find that the primary thing this book teaches is the SQL language and the coverage of Python was limited to the bare minimum needed to run the SQL examples. And although it does touch on some of the SQL language elements unique to MySQL, most of the content is standard SQL that would work on many different databases.If you are new to SQL and are developing non-web applications, using MySQL for a database and Python as your programming language, this book may be valuable to you. If instead, you already know SQL and especially if you are developing web applications, this is not the book for you. I mainly fault the book for claiming too broad of an audience and omitting some important concepts.Here are some of the major issues:1. The book never makes the distinction between SQL (the language), MySQL (the database server/DBMS), and MySQL's proprietary SQL extensions. These are important concepts to understand. If this was your first exposure to the SQL language, you would leave with some significant knowledge gaps.2. The only MySQL library covered is the aging MySQLdb, aka mysql-python. This is the default MySQL library that ships with Python, but there are other libraries, such as SQLalchemy or oursql, which at least deserved to be mentioned.3. Perhaps the most serious omission is that SQL injection attacks are never covered and throughout the book the example code construct SQL statement strings in a way that could easily be exploited in a web application environment.4. My jaw dropped when chapter 7 introduced a web-enabled MySQL administration example explained that CGI and PHP were good options for exposing a Python app over the web. That may have been true 10 years ago, but no one would use either in a modern Python web application. Any rational developer would use a web-app framework like Django, which include a nice database abstraction or ORM library - none of which ever get mentioned. The PHP example actually recommends running Python script using the (PHP) shell_exec() function. This sort of thing has no place in a Python book.5. The book says its examples were written for Python 2.5.2, which was released in Feburary 2008 and later found to have security bugs. I expect most people are smart enough not to blindly go download version 2.5.2, but I would have prefered they mention version 2.5.5 (release January 2010) which fixed the security issues. Better still would have been to target a more modern, mainstream version of Python, like 2.6 or 2.7.6. In chapter 7, as the book introduces HTML, it mentions the web site W3Schools as "one of the best" sources for HTML tutorials. This could not be more wrong. W3Schools is quite dated and contains many horrible examples that anyone new to modern web development would want to avoid like the plague. It unfortunately shows up at the top of many Google searches, so it gets cited frequently. That may sound trivial, but to me, this is further indication that the author has very limited experience with developing apps for web environments.In summary, I felt the book did not live up to its title or the various descriptions of its audience and scope. It does contain some good information and would certainly help novice Python programmers needing a broad introduction to using SQL, MySQL and the Python MySQLdb library. Unfortunately, I suspect that most "intermediate Python programmers" (which the book claims to target) will already know enough SQL and MySQL that this would be a disappointing read.(I would note that I was provided a free ebook copy this title and was invited to provide feedback.)

I am always for using the right tool for the right job. A lot of time, that tool is Python. I have always had trouble finding solid documentation on using MySQL with Python. There was generally enough to get by, but the more the merrier. Enter MySQL for Python by Albert Lukaszewski.As I mention in most of my reviews, on the of the things I love about Packt Publishing books is that they typically follow the same pattern: installation, teaching, project, summary. And my favorite piece is the mini projects given at the end of each chapter. It's a little reality check for the reader reminding them that everything that they are doing has a real life application.So skipping the installation chapter and jumping right in to the teaching, there is a lot of discussion about how to do the common stuff that one does in MySQL through Python. If you have a lot of experience with MySQL, then this is a handy reference. I also really like the fact that scattered throughout the book is information on becoming a better programmer (like tradeoffs on memory efficiency vs. performance).Chapter 4 contained information about exception handling. Just like previous chapters, the amount of information on the handling of warnings and exceptions exceeds the boundaries of just MySQL in Python. This was a great review for any Python programmer. No need for further discussion as this chapter is available from Packt Publishing here.The next few chapters deal with data manipulation in Python. This includes INSERTs, UPDATEs, DELETEs, etc. Chapter 8 specifically deals with user management in MySQL. This is a great skill to have regardless of the interface that you are using to tie into MySQL. Most programmers neglect the concept of administration and leave it to the DBAs or the SysAdmins. Albert takes the reader through some admin exercises including user management, backup and recovery, and accessing the MySQL meta information like information_schema tables. There was also discussion about the various storage engines which was unexpected.Bouncing backwards a little was a lesson on the string and aggregation functions built into MySQL. A lot of these capabilities are usually handled programatically and not off-loaded to the database like it should be. Again, this is a great refresher (or even initial) lesson for any programmer who spends a lot of time building and maintaining complex queries.Overall this book was another great teaching tool put forth by the folks at Packt. The audience is definitely not at the beginner Python programmer, but an intermediate level developer would have no issues understanding everything. You can find this book either at Amazon or directly from Packt Publishing.

A useful different approach to implementing data-driven applications with Python and MySQL. The target audience is python developers who have never worked with relational databases.

The book is srsly out of date. Don't buy it. It is full of old thing(Python 2.5, old MySQL) Just waste money.

I didn.t like because this book explain from start Mysql, all the selects, inserts.....was very bored. If I want to learn mysql i buy one about that, no about python.

Very nice book for data manipulation in MySQL through Python programming