PHP Developers

Hartmut Holzgraefe's Blog: PHPReboot Braindump

In this new post to his blog Hartmut Holzgraefe looks at a new effort that wants to be "the next PHP" while still being PHP. Confused? Take a look at PHPReboot. PHP.reboot is a reboot of PHP, each Hollywood movie has its own reboot, why not doing the same for one of the most popular programming language. The aim is to keep the philosophy of PHP but adapt it to be more in sync with the Web of 2010. Hartmut's post is a "braindump" of some of his thoughts about the project including responses to some…

2011-10-12 02:22:51

Zendcon Presentations

I will be at Zendcon next week with two presentations. What’s New with MySQL will be on Wednesday the 19th and The Care and Feeding of a MySQL Database on Thursday the 20th. Other MySQL centric session are by Bill Karwin on SQL Injection Myths and Fallacies and MySQL 5.5 InnoDB Tuning. Plus Ligaya Turmelle will present Character Sets Suck.

2011-10-12 02:25:18 by Dave Stokes

Gonzalo Ayuso's Blog: Display errors on screen even with display errors = off with PHP

Gonzalo Ayuso has posted a handy tip to his blog today about showing errors even with "display_errors" being off in your application (could be helpful in debugging those difficult problems). Shared hosting are cheap, but normally they don't allow us the use some kind of features. For example we cannot see the error log. That's a problem when we need to see what happens within our application. Normally I work with my own servers, and I have got full access to error logs. But if we cannot see the…

2011-10-12 03:03:07

What SYSDATE is it?

I was looking into the history about why SYSDATE() and NOW() behave differently in MySQL, and it looks like in 4.0 and 4.1 they used to be the same. But as of MySQL 5.0, SYSDATE() was changed to emulate Oracle’s behavior, that is, it returns the time as of the function execution, not as of the statement start. There are a number of bug reports related to this: 15101, 12480, 12481, and 12562. I am not an Oracle expert. Does NOW() return a constant result within an Oracle query, like NOW() in…

2011-10-12 03:07:24 by Baron Schwartz (xaprb)

Carson McDonald's Blog: Google OAuth for Installed Apps PHP Example

Carson McDonald has posted an example of how to use the Google OAuth for Installed Apps tool to authenticate users. I have been working on a long needed update to the Google analytics dashboard plugin for WordPress and one of the items I had on my TODO list was using Google's OAuth login instead of the old ClientLogin. Setting OAuth up for a WordPress plugin is complicated because it isn't a hosted application and as such I can't register it to get OAuth keys. That is where a special way of doing…

2011-10-12 04:13:10

TechRepublic Article: "Are tech certs valuable or not?"

I normally do not repost articles and make teeny tiny blog posts (I have noticed a few bloggers who do that, and it bothers me), but I found a short article on TechRepublic called Are tech certs valuable or not? to be quite interesting.The author did an informal poll of a few CBS interactive higher-ups, and it was interesting to note that in addition to the expected "it depends" and "experience is the most important thing" and "beware the person with many certs and no experience" answers, the MySQL…

2011-10-12 05:07:42 by Sheeri Cabral

Community News: Pusher Challenge (Make Your App Realtime)

The folks over at Pusher (the real-time push notification service) have announced a contest they're holding for developers (not just PHP either) to enter for a shot at a MacBook Air and a ticket to the Keeping it Realtime Conference - the "Pusher Challenge". We believe you can massively improve the user experience and engagement of your existing applications by making them realtime. Pusher lets you do that quickly and simply with our hosted API. In the Pusher challenge, we want to see the innovative…

2011-10-12 05:57:34

The MySQL Source is Now Back on Launchpad!

Last Friday, I had posted that the MySQL Source Code on Launchpad had not been updated (or rather not accessible by Lauchpad) in nearly a month. I had actually started to file a bug report about this, but when posting the relevant links for documentation, I had noticed new information had been posted yesterday (10/10/2011). Here was the orignal MySQL Launchpad page: https://code.launchpad.net/~mysql/mysql-server/mysql-trunk Here is the new message on this page: “This is the old MySQL server…

2011-10-12 06:19:40 by Chris Calender

ScaleBase at Percona Live in London – Come see how to transparently shard your MySQL

ScaleBase is happy to sponsor the Percona Live London MySQL Conference. If you plan to attend, you can catch our booth on the expo floor or attend Liran’s session – “The Benefits of Database Sharding” at 2PM, October 25th at the Bishopsgate Suite.

2011-10-12 07:52:11 by Liran Zelkha

Same query, 3 databases, 3 different results

The SQL standard leaves a lot of room for different implementations. This is a little demonstration of one of such differences. SQLite 3.7.4sqlite> create table t1 (id serial, t time);sqlite> insert into t1(t) values ('00:05:10');sqlite> select t,t*1.5 from t1;00:05:10|0.0MySQL 5.6.4-m5mysql> create table t1 (id serial, t time);Query OK, 0 rows affected (0.01 sec)mysql> insert into t1(t) values ('00:05:10');Query OK, 1 row affected (0.00 sec)mysql> select t,t*1.5 from t1;+----------+-------+|…

2011-10-12 17:35:24 by Daniel van Eeden

PHP DEVELOPERS