Showing posts with label postgresql. Show all posts
Showing posts with label postgresql. Show all posts

Practical Web 2.0 Applications with PHP (Expert's Voice) Review

Practical Web 2.0 Applications with PHP (Expert's Voice)
Average Reviews:

(More customer reviews)
The only quip I have with this book is the title "Practical Web 2.0 Applications with PHP" it should be called "Practical Zend Framework Applications using PHP"
There is not one example in the book that doesn't use the Zend Framework. That being said the Zend Framework is a great framework - by far the best web framework I've seen. I'm PhD student in Computer Science at UCLA whose dissertation research involves the web. I've used a lot of web applications and frameworks. Symfony, Drupal, Joomla, Ruby on Rails, etc.
Most of these applications and frameworks just suck - that is, it is more work using them than not using them and many severely limit what one can ultimately do.
I like Ruby on Rails but I love the Zend Framework. There are two big differences between the Zend Framework and Ruby on Rails: 1) they both promote MVC style programming but Ror forces you to use it everywhere and the Zend Framework allows you to mix MVC with simply using their framework as a library wherever you want. For example, I am building a social network but want to mix that with a related wiki. I can use MVC for all the social network code and use and existing MediaWiki (which is not MVC based). All I need to do is rewrite some of the mediaWiki code to hand over user authentication to my controllers.
2) it's Php based ... there is much, much more existing Php code to cannibalize for applications than Ruby code
The book itself basically takes you through setting up user profiles, a blog, an image gallery, prototype (javascript) and Google maps using the Zend Framework. The code is very professional and complex at times so a beginning user may have to read a chapter 2-3 times to fully understand it. Still the only way to really learn to write "professional" code is to see it and understand why it was written as it was.
There are some issues I have with the book. In places where something could reasonably be done in multiple ways the book only shows one without any explanation why that way was chosen. For example, in the installing Zend chapter the book tells you to edit the httpd.conf file to set your paths. Most people who use a commercial hosting company don't have access to edit httpd.conf or restart the server. There are ways to reset the path within the Zend bootstrap (which I did) but if I didn't know how to do that I would not have been able to get the examples to work without setting up a server locally on my machine.
Also the bootstrap is left in the index.php file when Zend recommends using the index.php to call the bootstrap.php file from a non-public web directory.
The Zend Framework is only a few months old and this is by far the best web framework out there. There is only one other (decent) book on the framework. This book is about the Zend Framework and only marginally about "Web 2.0" (you use Google maps). The book that should have been titled "Practical Zend Framework Applications using PHP" will teach you how to use the best web framework out there. If the next book shows one how to really use web services, ajax and present web services using the Zend Framework then it can be called "Web 2.0" not this one.

Click Here to see more reviews about: Practical Web 2.0 Applications with PHP (Expert's Voice)

There are many technologies that go into creating a successful modern web application, but few books that cover how to use them all together effectively. Practical PHP Web 2.0 Applications does just that - it marries together PHP and MySQL, XHTML, CSS, and JavaScript/Ajax, covering how to create a cutting edge PHP web application from planning and design right up to final implementation. Application features covered include must haves such as search, maps, blogs, dynamic image galleries, and more.

Buy Now

Click here for more information about Practical Web 2.0 Applications with PHP (Expert's Voice)

Read More...

Discovering SQL: A Hands-On Guide for Beginners (Wrox Programmer to Programmer) Review

Discovering SQL: A Hands-On Guide for Beginners (Wrox Programmer to Programmer)
Average Reviews:

(More customer reviews)
Without being cocky or pretentious, this book is too simple for my current skills and I know that. But I always check for new titles and authors. You will be surprised of how many new things you can learn from "intro" books. However, this book is too simple, even for a newbie. There are also 2 or 3 chapters that I would categorize as fillers and won't add useful T-SQL skills for a newbie, like the one for Performance and Normal forms (very important topics for being barely mentioned on a few pages)
1st, the positive
Nice style. The books reads like a novel. It honors its title so if you're new on the SQL arena, you will learn from this book without getting confused with lot of complex examples or SQL terminology. I also like the RDMS comparisons. I am learning Oracle and MySQL and it is really useful how the author compares similar commands among different engines; as a matter of fact, this is probably one of the things I like most of this book. It reminds me Itzik in some way who is a wonderful SQL writer and programmer but always try to be not code dependent.
The not so positive
I think that without being too complex, author could be a bit more technical. The examples are good but too simple. The Performance Tuning chapter is a joke! About 10 pages? Please ... and does not mention anything specific. For such a complex and important topic, I would remove the whole chapter altogether. Better not mentioning anything about Performance than just write about lot of generic concepts without really teaching something.
Overall, this is an ok book and a nice attempt, but it is too simple, even for the novice. For someone new into SQL arena, I would recommend "Microsoft® SQL Server® 2008 T-SQL Fundamentals" instead. But I really like Alex's writing style and how he tries to compare same command across several products. Wish I can give 3.5 starts, so I will round it to 3.

Click Here to see more reviews about: Discovering SQL: A Hands-On Guide for Beginners (Wrox Programmer to Programmer)

Teaching the SQL skills that businesses demand when hiring programmers
If you're a SQL beginner, you don't just want to learn SQL basics, you also want to get some practical SQL skills you can use in the job market. This book gives you both. Covering the basics through intermediate topics with clear explanations, hands-on exercises, and helpful solutions, this book is the perfect introduction to SQL. Topics include both the current SQL:2008 standards, the upcoming SQL:2011 standards, and also how to use SQL against current releases of the most popular commercial SQL databases, such as Oracle, SQL Server, and MySQL.
Introduces SQL concepts, explains SQL statements, and clearly shows how to write efficient and effective SQL code
Uses a hands-on style and a sample database that incorporates all SQL concepts taught in the book; this database will be enhanced through the book as key points and lessons are covered
Covers topics such as how SQL interacts with the sample database via various interfaces, including vendor-provided utilities, programming languages, SQL clients, and productivity software
Includes appendices with primers on database normalization, set theory and bollean algebra, RDBMS software step-by-step setup guides, and database connectivity

Learn how to write effective, efficient SQL code with Discovering SQL: A Hands-On Guide for Beginners.

Buy Now

Click here for more information about Discovering SQL: A Hands-On Guide for Beginners (Wrox Programmer to Programmer)

Read More...