SQLite may throw the following error:
Expression tree is too large (maximum depth 1000)
When using PHP PDO with SQLite, the error messages sometimes are not really self-explaining. Today I had an error stating "bind or column index out of range". The "column index" part made me check the tables index and data type.
When developing apps by using SQLite as a storage backend, you most likely will sometime get the error message:
The message very clearly describes what happened: you have prepared an SQL statement like "SELECT ... WHERE id=? OR id=? OR id=?" or at least something like that, and the placeholders (in this case the question marks) are too many.
Today I decided to provide a brief introduction into using SQLite compared to mySQL for PHP and webserver environments.
Traditionally mySQL is first choice when developing a dynamic website with PHP. Recently SQLite is another database system (I intentionally don't call it a database server, see below for reasons why) getting very popular. SQLite has two main usage areas: Webservers (mainly with little performance requirements) and applications.
In this quick article I'd like to comment a special case which is very much undocumented yet.
Zend_Date is a mighty class for handling date and time. As for all of such mighty tools, there is a heavy downside: it's really expensive at runtime. Using a Zend_Date instance a few times is no big deal, but using a hundred instances and generating thousands of ISO-style dates and times may take several seconds.
Today I decided to write a short review about my experience with a tool called Web Of Trust (WOT). People who install WOT get additional security relevant information about the websites they surf. How this works and why it is an additional risk is described in this article.
I'm writing this article on a netbook ASUS 1000HE. Actually I'm surfing a lot from the sofa and enjoy this tiny computer a lot. As it accompanies me on all trips whilst containing sensitive information like e-mails and certain account credentials, the first thing I did with it was, securing its hard disk.
Today I eventually started optimizing the performance (thereby reducing server load a bit). It appeared some pages of my larger websites have grown to round about 300 kb causing some latency for lower bandwidth visitor. Having a quite good connection myself, I didn't care about that much in the past. But that's ab pity, because it is very simple to add compression to pure PHP-generated content.
Bing is the latest remake of Microsoft's search engine. Since letdown live.com was closed, people start talking about the new search engine.