Recently, I switched my spam blocking software from SpamAssassin , to DSPAM It's pretty cool, it seems to be working better for me. Setup with MySQL was a breeze, the documentation etc was great. Unfortunately, it seems not a lot of people use the WebUI with MySQL. Lots of tutorials on how to make dspam work with email addresses in MySQL. But the WebUI, which people can use to administer their preferences, and quarantine's etc. Relies on http auth. The CGI has no way of authenticating against MySQL, and they really don't mention anything about mod_auth_mysql etc.

So, I wrote a little script that will connect to my mysql db, and create a simple password file, which can be used for authenticating against, via a normal .htaccess.

You can get …

Recently, I switched my spam blocking software from SpamAssassin , to DSPAM It’s pretty cool, it seems to be working better for me. Setup with MySQL was a breeze, the documentation etc was great. Unfortunately, it seems not a lot of people use the WebUI with MySQL. Lots of tutorials on how to make dspam work with email addresses in MySQL. But the WebUI, which people can use to administer their preferences, and quarantine’s etc. Relies on http auth. The CGI has no way of authenticating against MySQL, and they really don’t mention anything about mod_auth_mysql etc.
So, I wrote a little script that will connect to my mysql db, and create a simple password file, which can be used for authenticating against, via a normal .htaccess.
You can get …

More and more companies are discovering LAMP as an enterprise-grade, OpenSource stack to built mission-critical applications on it. Web development companies are developing LAMP applications for businesses like Disney, Deutsche Telekom, Sueddeutsche.de, Lufthansa and such. But what about a professional support with guaranteed response times up to 2 hours? That's where our PHP/LAMP support is targeted at, including support for databases like MySQL for example.

We provide support for enterprise companies that have their own development department, but need someone who is helping them if they experience problems while developing their application, including application management and monitoring. The support program is for an unlimited number of servers in your company.

If you are an ISV or SI with your own PHP developers, then this support is also for you: we …

PHP has been used in the business for years. In fact, we and many other companies provided business-critical solutions based on PHP (or LAMP) for several years now. Magazines like PHP Magazin or web sites like PHP-Center.de or Dynamic-Webpages.de, not forgetting the world's first PHP Conference that took place here in Germany provided the fruitful ground for a market that continously attracted larger businesses searching for a fast, reliable and easy-to-deploy solution for their critical business processes.

General IT magazines like iX or …

Update: Dynamic Materialized Views
Please read this article also. Its an improved versio of the technique described below.

Today i found a workaround for a feature that was realy missing in MySQL.
Let's say you got a really complicated query that requires a lot of cpu and time to complete, but the resulting data is quite static. That's the perfect opportunity to use a "Materialized View". The Bad Thing™ is, mysql does not support what's usually known as materialized views. But today i found a nice workaround for MySQL 5.
But first let's clarify what a materialized view is. I found a good explanation here:
"A materialized view is a stored summary containing precomputes results (originating from an SQL …

IP Concerns are very real; I’ve had a couple of customers bring them up in the past. It boils down to trust; It doesn’t matter if you and a thriving community have written the best code in the world; without someone to vouch that all proper measures were taken, there is an increased risk associated with your project.

This is the second time I’ve heard IP as one of the motivations behind the Zend Framework.. The first time was from David, and now there’s this line from Wez.

I never used to think about clean IP. I knew that some organizations, such as the Apache Foundation, make committers sign contributor license agreements, but as I am not an ASF contributor, it wasn’t something I had to deal with.

That’s changed now that I’m …

There are two calls for papers open right now for two great conferences: The 2006 MySQL User Conference and the 2006 PHP Quebec Conference.

Both conferences are excellent and I have loved being a speaker at both. I will be submitting for the MySQL conference but cannot attend the PHP Quebec conference (which I regret because it was an awesome conference).

I'd suggest you submit if you have something you would like to present, both conferences treat their speakers very well.

Calls for papers:

MySQL UC
PHP Quebec

WWW SQL Designer This is a pretty cool application. Once again, demonstrating the power of “Ajax” and DHTML etc. It’s not perfect, but it sure is pretty .
Checkout the live demo.

WWW SQL Designer This is a pretty cool application. Once again, demonstrating the power of "Ajax" and DHTML etc. It's not perfect, but it sure is pretty :).
Checkout the live demo.

So, I read a post by Chris Schifflet about a book titled Upgrading to PHP 5. I must say, this book is awesome. I’ve only gotten to chapter 2 , but thats because of the excellent writing and explanation of some of the reasons why PHP 5 is doing things the way it is. I believe I’m in the majority of PHP developers, where we don’t have a formal background in programming. I took 1 C++ course in community college in 1997. Since then, I’ve written in perl, php, and a little bit of Java. This is a great book to read if you want to figure out what exactly is new in PHP 5, and why you want to use it. I have started writing a new program that will run 100% in PHP 5 …