This is a list of all entries published on the NetBeans PHP blog. Features

• NetBeans 7.0
  • Generating Getters and Setters Improved
    
• NetBeans 6.5
  • JavaScript Debugger Screencast
    
  • Code completion for a class field
    
  • Software as a Service in NetBeans PHP
    
  • …

Here is a little tid bit about a useful MySQL extension to the SQL standard, since I have given this same hint to several people in a short timeframe. A good friend from good old Berlin who runs a site for selling car parts was the first to ask, so I am giving him credit for bringing this nifty operator back to mind. Essentially the problem is that frequently we want to easily handle matching against some value or NULL with the same code. Obviously the standard expects you to switch from the standard equal operator to "IS" for matching a NULL. After all NULL is not equal to anything. Right, but its tedious to handle this in the code so MySQL invented the "<=>" operator aka the "NULL-safe equal to operator". Also very useful in combination with prepared statements.

Side note: I must …

Tomorrow, there’s a particularly interesting MySQL University session coming up: The OpenSolaris Web Stack.

This session is presented by key experts outside the Database Group, but inside Sun:

• Jyri Virkki, lead for OpenSolaris Web Stack community, Sun Microsystems
• Murthy Chintalapati, Web Stack development, Sr Engineering Manager, Sun Microsystems

For practical reasons, this session happens three hours later than normal. To decipher that into a timezone which may be familiar to you, this means 9:00 PST / 16:00 UTC / 17:00 GMT / 18:00 CET.

Abstract:

OpenSolaris Web Stack is an OpenSolaris project and community building an integrated stack of …

Tomorrow (Thursday, 11th of September) at 9:00 PST/16:00 UTC/17:00 GMT/18:00 CET, there will be an new free MySQL University Session. MySQL University started as an internal training program for MySQL engineers, to share and spread knowledge about their areas of expertise and has been available to the public for quite some time now. It covers a wide range of technical topics around the MySQL Server and usually takes place once per week.

For the first time, the presentation will not be performed by (former) MySQL employees/developers, but by two of our "Sun Classic" colleagues: Jyri Virkki (OpenSolaris Web Stack community lead) and Murthy Chintalapati (Sr Engineering Manager, Web Stack development) will talk about the …

Here is a little tid bit about a useful MySQL extension to the SQL standard, since I have given this same hint to several people in a short timeframe. A good friend from good old Berlin who runs a site for selling car parts was the first to ask, so I am giving him credit for bringing this nifty operator back to mind. Essentially the problem is that frequently we want to easily handle matching against some value or NULL with the same code. Obviously the standard expects you to switch from the standard equal operator to "IS" for matching a NULL. After all NULL is not equal to anything. Right, but its tedious to handle this in the code so MySQL invented the "<=>" operator aka the "NULL-safe equal to operator". Also very useful in combination with prepared statements.

Side note: I must …

So, here is a hypothetical problem:

There exists a table on a MS SQL "client" server (think, one step up from Access, or MS SQL Server stripped way down)

That machine is on the other side of a VPN link

I want to keep a table or the appearance of a table in MySQL that shadows that table, in close to real time as possible.

The MS SQL table doesnt have a "time this row was last updated" column.

The MS SQL developer cant/wont put on update triggers on his system.

So far, I've considered the following possible solutions:

* Have the PHP and Perl apps that speak to MySQL also keep a connection to the MS SQL table, and do the necessary joins and such in the app, instead of the database.

* Write a daemon that keeps a DBI::MSSQL connection and a DBI::MySQL connection open, and keeps polling the MS SQL table and writing it to MySQL. This is …

We are going to show the effects of the new patches applied to Percona HighPerf release. As you see from the following graphs, there is significant difference to normal version when the data bigger than buffer pool (right graph shows CPU usage)

The workload emulates TPC-C and has a same characteristic to DBT-2 (it is not DBT-2, but custom scripts, we will publish them eventually). There are no delays between transactions (no thinking time, no keying time), it uses MySQL C API and the server side prepared statement.

The server has 8core CPU and RAID storage (RAID10 / 6 disks). The data population is along to the scale factor 40WH (:=~4GB). It is enough bigger than the data cache of the storage.

main common settings

innodb_buffer_pool_size = 2048M
innodb_thread_concurrency = 0 …

If you are a football (soccer) fan, then F.C. Internazionale may mean something to you. Or perhaps its more common name, Inter Milan sounds familiar? Next in our Use Case Competition articles, here's Corrado Pandiani's experience, about using MySQL to power inter.it, one of the most popular soccer sites in Europe. Not only that, but inter.it is using the latest MySQL 5.1 technology.

Sacha asks whether switching support providers is really that difficult, while Bill brings up the question of open standards. READ MORE

CA and IBM, two of the so-called Big Four in systems management software, announced this week a federated configuration management database (CMDB) system for interoperability of their software. Something like this comoing from two of Big Four (BMC, CA, HP and IBM) wouldn’t normally hold much meaning for open source players such as GroundWork, Hyperic and Zenoss, but it actually does for a couple of reasons.

First, part of the technology that CA and IBM are using to link up their systems management software, which allows it to share information between the two CMDBs, is actually open source software itself from the Eclipse Cosmos Project. CA and IBM said the Eclipse Cosmos software accelerated implementation of the CMDB Federation (CMDBf) specification and the two vendors plan to contribute code …