Archive | March, 2003

SQLite: embeddable SQL engine for PHP-Gtk Apps

Posted on 10 March 2003 by Demian Turner

If you read PHPkitchen’s last article about desktop GUI apps in PHP (and checked the comments for tips on  creating PHP .exe installers) then you’ll be interested in the SQLite project over on Sourceforge.

SQLite is a C library that implements an embeddable SQL database engine. Programs that link with the SQLite library can have SQL database access without running a separate RDBMS process. The distribution comes with a standalone command-line access program (sqlite) that can be used to administer an SQLite database and which serves as an example of how to use the SQLite library.

SQLite is not a client library used to connect to a big database server. SQLite is the server. The SQLite library reads and writes directly to and from the database files on disk.

And check out the features!

  • Implements most of SQL92
  • A complete database (with multiple tables and indices) is stored in a single disk file
  • Two times faster than PostgreSQL and MySQL for many common operations
  • Supports databases up to 2 terabytes
  • Small memory footprint

Comments (0)

Watching Google Dance

Posted on 08 March 2003 by Demian Turner

The name “Google Dance” is often used to describe the index update of the Google search engine. Google’s index update occurs on average once per month. It can be identified by significant movement in search results and especially by Google’s cache of all indexed pages reflecting the status of Google’s last spidering. But the update does not proceed as a switch from one index to another at one point in time. In fact, it takes several days to complete the index update. During this period, the old and the new index alternate on At an early stage, the results from the new index occur sporadically. But later on, they appear more frequently. Google dances.

Comments (0)

Simple Web Architectures: Intercepting Filters

Posted on 08 March 2003 by Demian Turner

from ObjectMonkey

Quite an interesting article on another variant of the MVC design pattern, sounds very similar to Java Struts from the nomenclature however these examples are in PHP. Not sure if it makes sense to have core app services like logging and authentication functioning as filters at the same level as say, the Viewfilter, but worth a read all the same.

While on the subject of interesting web architectures, Redhat have something called Content & Collaboration Management Solutions (CCM) which is an Open Source CMS solution.  The Developer’s Guide has some interesting examples of site archictectures, guaranteed to captivate those working in this area.

CCM Software Architecture

Comments (0)

Object Prevalence: How To Speed Up OO Apps

Posted on 08 March 2003 by Demian Turner

from IBM developerWorks, logon required

Written by a particularly astute 19-year-old, this article covers some interesting ideas about an alternative way to design OO apps.  Code examples in Java, very few changes required to run it in PHP

Persisting state and data has always been a problem with object-oriented software. Over the years, developers have stored object data in many ways, including relational databases, flat files,and XML. None of these approaches really managed to keep the software purely object-oriented. The Prevayler team is changing this with the object prevalence concept. This article introduces object prevalence.


Comments (0)

Zeev Suraski of Zend Joins PHPCon East 2003

Posted on 04 March 2003 by Demian Turner

Zeev Suraski, CTO and Co-Founder of Zend, is set to close PHPCon East’s program with a keynote address on PHP5, Zend Engine 2 and the Future of PHP. Suraski’s work in PHP has led to many rewrites and redesigns including the creation of the Zend Engine which powers PHP 4.0 and the
design of other crucial PHP 4.0 components such as a server subtraction layer and multithreading support.

PHPCon East is three days of intensive learning through hands-on tutorials and three technical session tracks on Enterprise PHP, Applications Development and XML/Web Services. Suraski joins other PHP notables on the conference program including PHP inventor Rasmus
Lerdorf, MySQL’s Zak Greant,’s Jim Winstead and authors Luke Welling and Laura Thompson. Other highlights include:

  • Author Christian Wenz’s discussion PHP & Web Services – A Competitor to ASP.NET?
  • Community Connect’s Dan Cowgill on Understanding and Deploying the Alternative PHP Cache (APC)
  • OmniTi’s George Schlossnagle’s presentations on High Performance PHP and Unit Testing
  • Author/Consultant Sterling Hughes delves into the details of PHP and XML programming

Comments (0)

Building XML Trees With PEAR

Posted on 02 March 2003 by Demian Turner

If, for some strange reason, you’ve not subscribed to the Devshed newsletter, then you’ve missed out on a fantastic PEAR tutorial, this time XML_Tree.

The article takes you through the following:

  • dynamically constructing an XML document using XMLTree methods.
  • retrieving any segment of a dynamically-created document tree via the get() method
  • reading an existing tree into memory from a file
  • converting data stored in a MySQL database into an XML document, and writing it to a file for later use
  • pairing XML document with an XSLT stylesheet to produce HTML output.

Comments (0)

Gates reveals Windows code to China

Posted on 01 March 2003 by Demian Turner

from ZDnet
Microsoft on Friday signed a pact with the Chinese government to reveal the Windows source code, making China among the first to benefit from its program to allay the security fears of governments.

I can see the $ signs flashing in his eyes 😉

Comments (1)



Demian Turner's currently-reading book recommendations, reviews, favorite quotes, book clubs, book trivia, book lists



PHPkitchen recommends you also check out the following sites :

Accounting for Small Businesses

FreeAgent sign-up