Entries Categorized as 'MySQL'

SQL Server driver for PHP5

Date February 9, 2008

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 [...]

Sun buys MySQL and other interesting tidbits

Date January 16, 2008

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 [...]

GORM Goodness in PHP

Date January 10, 2008

I’m working on a way to port the ‘magic’ goodness of GORM to PHP.  I’ve thought about it for awhile, but haven’t had much of a need to.  I’ve got a need for it now, so I’ve whipped up a basic prototype.  This will allow me to do things like:
$user->findAllByFirstname(”Mike”);
and automatically get an SQL statement [...]

MySQL oddities in legacy project

Date December 22, 2007

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 [...]

PHP on mobile devices

Date December 20, 2007

I heard about this last week, which is an article about running PHP on Symbian mobile devices.  Haven’t seen much in the press about this, possibly because it’s not a full release, but just an announcement.  The crux of the article is that someone has ported Apache, MySQL and PHP to the Symbian E90.  They’re [...]

Codemash free admission drawing giveaway

Date December 6, 2007

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? [...]

Latest podcast up

Date November 26, 2007

I put up a new webdevradio podcast last week, day after Thanksgiving (or was it the day before?  I forget now).  Anyway, I’ve turned on the comments - apparently there was a bug that was stopping it from working - and am inviting more feedback and audio comments from listeners.  The podcast is short this [...]

Raleigh web job market

Date October 25, 2007

If you’re in the Raleigh area and are looking for a job in the web development market, give me a holler - I’ve had recruiters calling night and day.  AND they’re not all calling with the same position.  That used to happen once in a while - I’d have calls from three recruiters that were [...]

MySQL using two timestamps for created/updated values

Date October 24, 2007

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 [...]

Looking for book reviewers

Date October 10, 2007

Specifically of technical books.  I’ve got a small backlog of books I wanted reviewed for techbookreviews.com.  I thought I had more time than I did, but I don’t (isn’t that always how it goes?).  So, in the interests of time and getting other people besides myself involved, I’d like to invite some of you to [...]