This is the last in my MySQL conference series.  Brian Moon, author of Phorum and Sr Developer at Dealnews.com, sat down and gave a recap of his two presentations.  We have here nearly a full hour of his insights in to PHP/MySQL scalability, both with an app like Phorum and a more complex environment like [...]

Posted in Conferences, Database, Design, Development, Job, MySQL, PHP, Podcasts, Software, Web 2 Comments »

I’ve been meaning to do this some time, and finally found the time to do it - jobs.webdevradio.com is up and functional (though quite empty at this point!) One of the things I mentioned on my podcast (webdevradio.com) one more than one occasion is that I tend to attract recruiters. Rather than just [...]

Posted in Business, Database, Development, Job, PHP, Software, Web No Comments »

Every so often I try to use PDO under PHP5, and every time I run in to basic functionality problems with no ability to find out what’s going on under the hood.  A recent example:
$dbh = new PDO(’mysql:host=localhost;dbname=db’, “user”,”pass”);
$stmt = $dbh->prepare(”SELECT * FROM table where service_type = ? and name = ? “);
if ($stmt->execute(array(2,$short_name))) {
….
The [...]

Posted in Database, PHP 15 Comments »

For anyone that has struggled with using PHP and MSSQL over the years, this one may come as some pleasant news (if you’re still in that situation).  Microsoft has put out a preview of “SQL Server 2005 Driver for PHP” back in October 2007 (yeah, I just found out this morning!).  Ehh… not as impressed [...]

Posted in Database, Development, Microsoft, MySQL, PHP, Software, Web 8 Comments »

Sun is acquiring MySQL

OK, well, I thought I’d be able to find a few more interesting tidbits, but these two are interesting enough to me for a Wednesday morning.  Obviously the Sun/MySQL thing is big - will they use the acronym SPAM for Solaris/PHP/Apache/MySQL?  I claim “first post” on inventing that acronym, although I’m sure [...]

Posted in Database, Development, Groovy, Java, MySQL, Software, linux, opensource 1 Comment »

I recently inherited a project.  My primary goal is to make it portable to the extent that it can run on another webserver setup.  This is a PHP4/LAMP system, but the people I’m getting it from didn’t write it themselves, and can’t spend the time to dig in to it and make it able to [...]

Posted in Database, Development, MySQL, Software, Web 2 Comments »

The codemash organizers have graciously donated a free pass to the upcoming Codemash conference to be given away to one lucky webdevradio.com listener.  To enter in to the drawing, listen to the codemash episode interview podcast on webdevradio with Jim Holmes, follow the instructions, and hope your name is drawn.
 Did you like this post? [...]

Posted in Codemash, Conferences, Database, Development, Microsoft, MySQL, PHP, Perl, Podcasts, Software, Testing, Web, linux, opensource No Comments »

I’ve seen this on and off for years, but never have it handy. So, here’s a quick demo:
mysql> create table sample ( timeUpdated TIMESTAMP, timeCreated TIMESTAMP, val INT );
Query OK, 0 rows affected (0.24 sec)
mysql> insert into sample (timeUpdated, timeCreated, val) values (NULL,NULL,1);
Query OK, 1 row affected (0.00 sec)
mysql> select * from sample;
+———————+———————+——+
| timeUpdated [...]

Posted in Database, Development, MySQL, Software, Web, opensource 2 Comments »

Over at webdevradio, I’ve posted an hour long discussion I had with Keith Murphy, a local MySQL DBA.  He’s recently started at icontact.com, fast becoming one of the industry leaders in managed mailing lists and community communication tools.  I’ve known David Rasch, their CTO, for close to 2 years now, and have watched them grow [...]

Posted in Database, Development, MySQL, Podcasts, Software, Web, linux, opensource No Comments »

I put together a small utility to generate random user data several months back. I realized yesterday that I hadn’t released the source code - I thought I had. This generates plausible names, addresses, phone numbers and social security numbers. The phone number area codes don’t generally match up with the address, [...]

Posted in Database, Development, Ideas, MySQL, PHP, Software, Testing, Web, opensource 3 Comments »