We had discussions about the value of doing SQL completion in PHP. The argument was that developers normally just write and test their queries in a "real" SQL editor (which comes with completion already), and then cut-and-paste into their PHP code. So why do all the work to do completion in the PHP editor? I even asked my Dear Readers for their thoughts on this. It was generally positive, so we're plugging ahead.

But the comments and tweets I've seen since Petr blogged about SQL completion in PHP are very encouraging that we're on the right path...

Here are some sample tweets - I love the "scribbling on the wall" nature of tweets. It's almost like being in a bathroom stall :)

…

Hi,

Been a while since I lasted posted.

It has been a busy year with testing on 5.1, 5.1 Replication, the Telco branches of cluster and doing test Automation.

I know many have read the post that one of the founders did about MySQL 5.1 GA and the known issues with it. I as QA wanted to extend my take.

I started working for MySQL back in April of 2005. Official QA had only been around since Feb of 2005 and I think I was the 3rd or 4th brought in. My position at another DB software provider had gone to India which allowed me to find this opportunity.

When I first started, there were not many things in place for QAing the product and very limited automation. Even so, finding bugs was like shooting fish in a barrel with and over sized shotgun.

In fact, I spent more time writing bug reports then I did testing. There was a lot of low hanging fruit. Some the size …

My MythTV store lives on an LVM volume that is spread over 2 disks, one of them is an external USB disk. So the cleaninglady seems to have touched a cable and after coming back from holiday I had a read-only filesystem that afer a remount had about 350Gb in lost+found with irrelevant filenames.

1. total 337407844
2. drwx------ 2 tv tv 4096 Dec 17 22:47 .
3. drwxrwxrwx 15 tv tv 4096 Dec 17 22:44 ..
4. -rw-r--r-- 1 root root 423343556 Dec 14 07:10 I303109.RCN
5. -rw-r--r-- 1 root root 2990538924 Dec 13 19:05 I303107.RCN
6. -rw-r--r-- 1 root root 1023691768 Dec 13 08:10 I319494.RCN
7. -rw-r--r-- 1 root root 1023622348 Dec 13 07:45 I327684.RCN
8. -rw-r--r-- 1 root root 423735892 Dec 13 07:10 I327682.RCN
9. -rw-r--r-- 1 root root 466749476 Dec 12 15:43 I135169.RCN
10. -rw-r--r-- 1 root root 1023314212 Dec 12 07:45 I098309.RCN
11. -rw-r--r-- 1 root root …

So I wanted a fresh MySQL 5.1 release on my Fedora 10 box.
Fedora comes with a mysql 5.0 package and the MySQL community packages for 5.1 conflict with that in different ways. (to start with MySQL vs mysql)

For some weird reason libmysqlclient (in mysql-libs) is required by redland, which is required by openoffice.org-core. I probaly never need the RDF funtionalities that redland provides me but I`m stuck with them anyhow.

So Fred pointed me to

Remi repo for mysql 5.1

1. yum --enablerepo remi install mysql-server

Now gives me a very nice MySQL 5.1 to play around with.

Welcome to the 128th edition of Log Buffer, the weekly review of database blogs.

Let’s begin with some PostgreSQL blogs. Jignesh Shah shares his recipe for making a PostgreSQL 8.3 appliance based on OpenSolaris using VirtualBox. While we’re on appliances, Dave Page shows off PostgreSQL management on the iPhone with an application he himself wrote. Stealth DBA for the bus-rise home.

On Database Soup, Josh …

Last week I got a question about sharding using our Spockproxy.  The question was how can I create a query for the proxy so it effectively runs:

/*in shard 1*/
SELECT * FROM table_a WHERE f_key IN (a, b, c);

UNION

/*in shard 2*/
SELECT * FROM table_a WHERE f_key IN (d, e, f);

By design our proxy will not do this.  The whole point is to hide the sharding from the application.  Given a query it will either send the same query to all the shards and combine the results or only send that query to one shard when it can figure out that the results(s) can only come from one shard (because you specified the shard key in the where clause).

I did figure out a way it could be done using views but would this ever be desirable?  

Like “Hard Coding” where values are built into the code of your application I’ll call this technique “Hard …

I visit a large number of organizations every year to deliver training, short term consulting as well as business and technology seminars in the area of database servers, security, software development and middle-tier technology. So I thought I would share some of the trends I have seen in 2008 that I believe will continue in 2009.I'm always being asked the following questions; "How do I stay

I've been working on our Freiwild Shop website today making it compatible with Django 1.0.2 (final(ly)!). Basically, what I've done is try to run it and fix where it errors following the direction documented in the manual. I think that the next days I'll see how I can optimize the MySQL usage a bit.

The shop I've build has little models and doesn't use to much fancy tricks. Among the changes:

• Templates: extends should be on the first line
  
• Models: should not contain anything Admin-related. This is actually very nice, seperating models.py and admin.py.
  
• Model Fields: maxlength changed to max_length, oldforms/newforms options disappeared, small stuff like this.
  
…

Red Hat increases its service levels. Linux Foundation appoints Ted Ts’o CTO. Sun delivers VirtualBox update. Novell cancels BrainShare. BBC enables iPlayer for Linux. And more.

Note: This is the last 451 CAOS Links post of 2008. We’ll be back with a bumper holiday special on January 2. Happy holidays!

Official announcements
Red Hat Increases Service Levels and Reduces Costs for Customers with Extended Update Support Red Hat

Linux Foundation Appoints Ted Ts’o to Position of Chief Technology Officer Linux Foundation

…