Paul Jones has a post to his site looking at SQL schema naming conventions and some of his own thoughts on the matter. There's a lot of different camps of thought around naming, much less database ones, and he makes a few suggestions learned from his experience over time.

Several weeks ago I asked on Twitter for SQL schema naming conventions from DBA professionals. (I’m always interested in the generally-accepted practices of related professions; when I can, I try to make my work as compatible with theirs as possible.)

I got back only a handful of responses, representing MySQL, PostgreSQL, and DB2 administrators, really not enough for a statistically useful sample. Even so, I’m going to present their anonymized responses here, because they led me to work I had not previously considered at length.

He asked about things like singular vs plural names, primary key choices and naming of association tables. The uses the rest of the post sharing the responses he got from his questions with a good range of responses representing both sides of each question. He wraps up the post looking at what these answers mean to the average developer and the answers that Joe Celko and Simon Holywell have to say on the matter.

On the ThinkingPHP Blog today, Felix brings another feature of the popular Rails framework over to the world of PHP - in CakePHP specifically:

The idea behind it is pretty simple: Often you have two Models that are associated with each other where setting the associations themself via hasAndBelongsToMany isn't quite enough for what you try to to.

He gives an example of the code, a method to get around the typical CRUD pattern without breaking it. His example involves users and groups and storing information surrounding them. Storing the data about the groups and which users belong to which groups is easy - it's when you start including some meta-data into the mix that things get a little complex.

He provides the sample code to make it all work - three models and three controllers - and the database structure to work behind the scenes.

On the ThinkingPHP Blog today, Felix brings another feature of the popular Rails framework over to the world of PHP - in CakePHP specifically:

The idea behind it is pretty simple: Often you have two Models that are associated with each other where setting the associations themself via hasAndBelongsToMany isn't quite enough for what you try to to.

He gives an example of the code, a method to get around the typical CRUD pattern without breaking it. His example involves users and groups and storing information surrounding them. Storing the data about the groups and which users belong to which groups is easy - it's when you start including some meta-data into the mix that things get a little complex.

He provides the sample code to make it all work - three models and three controllers - and the database structure to work behind the scenes.

The Zend Developer Zone has posted some information about some freelancing work that the International Press Association is looking to have done.

If you’ve got spare cycles and want to help a brother out, read on. I received this from Leonard Rapoport of the International Press Association, (Disclaimer: Zend is a member of the IPA) The IPA is looking for some help. As you can see from the email below, they need a PHP programmer to help them out on some small projects and know of some larger projects they could turn you on it.

Any interested parties should contact Leonard via email and get things started.

The Zend Developer Zone has posted some information about some freelancing work that the International Press Association is looking to have done.

If you’ve got spare cycles and want to help a brother out, read on. I received this from Leonard Rapoport of the International Press Association, (Disclaimer: Zend is a member of the IPA) The IPA is looking for some help. As you can see from the email below, they need a PHP programmer to help them out on some small projects and know of some larger projects they could turn you on it.

Any interested parties should contact Leonard via email and get things started.

Previously, it was mentioned that Zend had recieved a nomination by Red Herring towards an award sponsored by the Israel Venture Association to be the honored Israeli Start-Up. Well, according to this new post on Zeev Suraski's blog today, they've won the award.

Yesterday, Zend won Israel Venture Association (IVA) and Red Herring's Best Software Startup award for the year 2006. Those of you who know the Israeli hitech landscape can understand what an amazing feat this is; For those who don't, Zend (and two other startups in other hitech areas) won out of a list of 400 nominees, which in turn are only a small fraction of the startups in the country. Israel has the highest concentration of startups in the world, second only to the Silicon Valley. So, the fact Zend won is pretty amazing and a great honor for all of the team.

Zeev shares his own thoughts on the occasion, noting that he believes it's really the testament of PHP's success, it's growth, and powerful features that pushed Zend over the top to win.

Many congratulations to all of those at Zend!

Previously, it was mentioned that Zend had recieved a nomination by Red Herring towards an award sponsored by the Israel Venture Association to be the honored Israeli Start-Up. Well, according to this new post on Zeev Suraski's blog today, they've won the award.

Yesterday, Zend won Israel Venture Association (IVA) and Red Herring's Best Software Startup award for the year 2006. Those of you who know the Israeli hitech landscape can understand what an amazing feat this is; For those who don't, Zend (and two other startups in other hitech areas) won out of a list of 400 nominees, which in turn are only a small fraction of the startups in the country. Israel has the highest concentration of startups in the world, second only to the Silicon Valley. So, the fact Zend won is pretty amazing and a great honor for all of the team.

Zeev shares his own thoughts on the occasion, noting that he believes it's really the testament of PHP's success, it's growth, and powerful features that pushed Zend over the top to win.

Many congratulations to all of those at Zend!