DevShed: Introduction to Using SQLite with PHP 5
686373
DevShed has started a small series today that seeks to guide you through the world of SQLite as is interfaced through PHP5.   If you use PHP 5 to build web-based applications that access a database, you might want to consider SQLite. A "lighter" option than MySQL, this database may still suit your purposes if you don't need all of MySQL's bells and whistles. This three-part series covers many of SQLite's most useful features.   Their post today, part one talks about the basics of the protocol and how to get started with it in PHP5. Since it's enabled by default, the chances of it being on your installation are great. They only really look at grabbing data from the database in this part, saving pushing data back in for another time.
494845
Stuart Herbert has posted a new book review of a new offering from Packt Publishing - "Learning PHP Data Objects" (by Dennis Popel).    The folks at Packt Publishing sent me a copy of Dennis Popel's "Learning PHP Data Objects" to review. I'd never heard of Packt before, and was intrigued.   He includes a high-level overview of what the book contains, but notes that he couldn't get a hold of the code examples mentioned in the book (no CD and couldn't find it on their site). Overall, he found it a good book - it's a good primer to PDO in PHP, but you'll need to know SQL beforehand to work with it. He suggests that it's more of a one or two time read, though - not much in the way of a reference to come back to.
216585
A new submission was sent in from Filip de Waard today about an article on his site that talks about creating SQLite in-memory databases.
416901
Aaron Wormus has a new note on his blog today about his presentation at this year's Zend/PHP Conference & Expo and another speaker he's excited to hear.    One of the Zend conference sessions that I'm pretty excited about is Don Samisa Abeysinghe's (of WSO2) "Fully Fletched Web Services with PHP".   I'll be presenting a session on "Moving to PHP5 with Style." This tutorial/case study will be based on experience in transitioning several codebases from PHP4 to PHP5, creating unit tests & started a move towards a service based architecture without a complete platform rewrite.    Aaron's talk fits under the banner of the "PHP Development" talks, including others on topics like hosting PHP applications on Windows, working with PDO, unicoding in PHP6, and using PHPUnit.
449834
Sebastian Bergmann has posted the results of some benchmarking on the compilation he's done on the branches of PHP from version 3.0 all the way up to 5.3-CVS.   As people keep asking me for an update to my previous benchmarks (PHP / GCC / ICC Benchmark, PHP 5.1 / GCC Benchmark (Update), and PHP 5.1 Performance, I quickly ran a new benchmark today.   He rendered the results out into a series of charts defining the number of total seconds taken for the compile and how long each of the components took. It's impressive to see how much of a jump there was between the 3.0 series and 4.3.   He also includes his compile settings (and machine information) as well as the numbers for the results if you'd like to graph them out yourself.
616513
Popular posts from PHPDeveloper.org for the past week:Community News: Namespaces in PHP6Mike Potter's Blog: Sample Code From PHP / Flex e-SeminarThe Bakery: PremierMarinas.com, ScienceHack.com and an iPhone AppPHP F1: PHP Session TutorialCommunity News: GoPHP5 Official SiteCommunity News: jPOP Framework - Javascript & PHPTim Koschuetzki's Blog: Composing Methods: Remove Assignments to ParametersAlexey Zakhlestin's Blog: YAML: Syck for PHP is not read-only anymoreMatthew O'Phinney's Blog: File_Fortune refactoredSite News: Popular Posts for the Week of 07.06.2007
670884
Why a standard single-file SQL format is necessary and how SQLite can get us there.
636915
Popular posts from PHPDeveloper.org for the past week:RefreshinglyBlue Blog: PHP vs Ruby - Practical Language DifferencesAndreas Gohr's Blog: Determine StumbleUpon RankingsPHP.net: PHP 5.2.4 ReleasedThe Bakery: Five New Posts - Custom Views, CSS, ViewInFile, ActsAs and Email ValidationPHPBuilder.com: File uploads made easyStefan Mischook's Blog: Turning on display_errors in WAMP - Video Tutorialphp|architect: Pro::PHP Podcast - Newscast for August 2007MT-Soft Blog: Creating a secure PHP production environment from Source CodeCommunity News: Andi Gutmans to Present at AjaxWorld 2007HowTo Forge: How To Set Up A Facebook RSS Feed Reader
347086
On CodePoets.co.uk, there's a new tutorial posted by David Goodwin showing how to use PHP with the PEAR MDB2 component to access your database backend.   While writing some PHP Training materials for Pale Purple, I thought I'd add an updated guide on PHP and database access. I've already done one on PEAR::DB, but PEAR::MDB2 is it's successor and has a slightly different API.... and as PEAR::DB is now deprecated, it's probably about time I rewrote it anyway.   David looks at what the MDB2 package is, how to install it, connecting to your database and including some error handling as well. He (thankfully) also touches on one of the most handy features of the package - the prepared statements and the security they can offer.
396236
This month's issue of php|architect has been released and includes articles such as:  PHP5: Beyond the Objects The Ultimate PHP 5 Shopping Cart PHP and Databases Error Handling with PHP 5 and PEAR
650296
In a post from PHP Magazine today, there's mention of an interesting discussion that was had at the latest NYPHP meeting concerning the accessing of the NDB Cluster native API directly from PHP.
385236
Scott Mattocks is back with the latest installment of the PHP-GTK news, issue number 22.   It's been a while, but I finally have some time to get back to summing up the world of PHP-GTK. Things have slowed down a little in the past few months on the development side but that doesn't mean that the world of PHP-GTK 2 has stood still.   In this edition, there's a call for help for anyone that would want to join the other (4!) developers in working on the PHP-GTK 2 project as well as some general information about the project and its involvement in the community - from talks at php/db|works, International PHP Conference, and the Zend/PHP Conference to the many PHP-GTK-related articles being printed to a new online resource for PHP-GTK tutorials.
675185
In a new entry on his blog today, Marco Tabini introduces us to 5 PHP Performance Tips that we "probably don't want to hear".   I thought it might be interesting to write an article about the performance-enhancing tips you probably don't want to hear about - that is, those that are most likely to produce measurable (and durable) results but do require some effort on your part.   His list consists of:  You Don't Need To Plan Ahead In Order To Have A Plan Combat Database Abuse Do You Really Need A Database Anyway? Scale Horizontally Refactor To Scale Vertically  For each, he explains the title and gives a bit of validation to the point. There's some great mentions of tools that you can use to help accomplish them too - a profiler, the Lucene and Xapian full-text databases, and Lustre.
224992
The latest release of PHP in the PHP 5.2.x series has been posted for download to the main PHP website today - version 5.2.3.   The PHP development team would like to announce the immediate availability of PHP 5.2.3. This release continues to improve the security and the stability of the 5.X branch as well as addressing two regressions introduced by the previous 5.2 releases. These regressions relate to the timeout handling over non-blocking SSL connections and the lack of HTTP_RAW_POST_DATA in certain conditions. All users are encouraged to upgrade to this release.   Updates in this new version include many security fixes and enhancements - check out the Changelog for complete information.   Check out other comments on the release from Ilia Alshanetsky and Stefan Esser.
413982
DevShed continues their series looking at using PDO objects in PHP with part two, a look at handling the result sets in your PHP5 code.   All in all, at this point you hopefully learned how to use some basic methods included with this PHP extension, but logically you may want to learn a few additional ones, so you can have a more polished picture of the overall functionality of the library in question. [...] I'm going to show you how to use the PDO extension to handle different database result sets in all sort of clever ways, in addition to performing some common tasks, like counting rows and columns as well.   He starts with an example of the best place to start - fetching the results set from the database backend. In these simple examples, use the prepare, execute and fetch functions to get the results. Taking it one step further, they move into the use of the fetchAll function to grab columns and rows in the results as well.
318761
DevShed ramps up another new series today with this new article giving developers a look at working with object-oriented programming through the eyes of design patterns. It's another excerpt from the George Schlossnagle book "Advanced PHP Programming".   This chapter provides an overview of the advanced OO features now available in PHP. Some of the examples developed here will be used throughout the rest of this book and will hopefully serve as a demonstration that certain problems really benefit from the OO approach.   The article lays down the foundation for the more complex information to come. It introduces object-oriented programming briefly, and talks about some of the handy features of it - like inheritance, static attributes and methods.
579125
On the Windows Skills blog, there's a new post that talks about the use of a SQLite database (via PHP) to handle the assault that Digg.com can dish out to a popular webiste.   Physical memory was limited and Apache and MySQL soon started to fight for every remaining byte and eventually the page was unavailable. After this experience I started to look for a alternative for the database storage and I found an interesting one: SQLite.   He mentions some of the features the database has including zero-configuration, a simple API, and the portability of having a single database in a single file. The next step was getting it to work with his Apache/PHP5 installation and to run some statistics on it. The results show SQLite pulling ahead of MySQL (INNODB) by a bit and MySQL (MYISAM) by a good bit.