Oracle buys Sun. Sun previews MySQL update, makes GlassFish Portfolio, OpenSSO and OpenDS available on EC2. Numerous partner announcements from the MySQL conference. Red Hat maps open source adoption. And more.

Follow 451 CAOS Links live @caostheory

Oracle to acquire Sun
Unless you’ve been living under a rock (or like me you decided to take a few inappropriately-timed days off) you probably noticed that Oracle announced an agreement to acquire Sun this week. Jay delivered our assessment on Oracle’s open source credentials, while I followed up with some …

Registry, Registrar, Registrant, (Registratum, Registrata, Registrunt). Ok, so the last 3 are made up words, and the domain name industry wasn't really founded in ancient Rome nor part of your everyday Latin dialect, but what do the first three words actually mean and how does the domain name industry work? We've been working in the industry for years, so we have a pretty good idea. But we can also understand why all this really can just sound like ancient Greek to many people and not mean a thing. So in the spirit of lifting the lid and keeping things honest (as Gandi likes to do), we thought we'd give you a quick overview of what it all means.

Who's who in the domain name world?

Which one are you? Well you're the registrant, the purchaser of domain names and the last link in the chain that runs from ICANN at the top to you at the bottom. But there are several …

A four part tutorial that explains the PHP / MySQL extensions - mysql, mysqli, and pdo_mysql - with simple examples is now accessible from Sun Developer Network. While most of the information presented in the tutorial is available elsewhere in bits and pieces, the real value-add is in the introduction of the MySQL native driver for PHP, mysqlnd.

Here is a brief description of all four parts in the series. Check them out, and as always feel free to send the corrections, comments, suggestions, etc., to my Sun mail ID: Giri.Mandalika@Sun.COM

• Part 1: Using the MySQL Improved Extension, mysqli -- describes mysqli, the MySQL Improved Extension that is the successor to the mysql extension

• …

Today at Percona Performance Conference, I did my presentation on the optimizations / tweaks that I developed for running Pathtraq, one of Japan's largest web stats service. Thank you to people who listened, I hope you enjoyed my talk. And thank you to the people at Percona. I have uploaded my slides to Slideshare. So for more information, please refer to them.

My final presentation during the 2009 MySQL Conference and Expo week was with the Percona Performance Conference on the topic of The Ideal Performance Architecture. My talk included discussions on Technology, Disk, Memory, Indexes, SQL and Data.

The Ideal Performance Architecture View more presentations from Ronald Bradford.

A four part tutorial that explains the PHP / MySQL extensions - mysql, mysqli, and pdo_mysql - with simple examples is now accessible from Sun Developer Network. While most of the information presented in the tutorial is available elsewhere in bits and pieces, the real value-add is in the introduction of the MySQL native driver for PHP, mysqlnd.

Here is a brief description of all four parts in the series. Check them out, and as always feel free to send the corrections, comments, suggestions, etc., to my Sun mail ID: Giri.Mandalika@Sun.COM

• Part 1: Using the MySQL Improved Extension, mysqli -- describes mysqli, the MySQL Improved Extension that is the successor to the mysql extension

• …

A four part tutorial that explains the PHP / MySQL extensions - mysql, mysqli, and pdo_mysql - with simple examples is now accessible from Sun Developer Network. While most of the information presented in the tutorial is available elsewhere in bits and pieces, the real value-add is in the introduction of the MySQL native driver for PHP, mysqlnd.

Here is a brief description of all four parts in the series. Check them out, and as always feel free to send the corrections, comments, suggestions, etc., to my Sun mail ID: Giri.Mandalika@Sun.COM

• Part 1: Using the MySQL Improved Extension, mysqli -- describes mysqli, the MySQL Improved Extension that is the successor to the mysql extension

• …

Around 300 certification exam were given this year at the MySQL Users Conference! That is 50% more than last year. Much of that is due to having the exams online. But the biggest part is from the dedication of Ricky Ho who not only did a fantastic job keeping the exams running smoothly but will spend most of the next week printing up certificates and getting them in the postal system.

An example of a basic MSSQL (Microsoft SQL Server/SQL Server Express) query using PHP.

1
2
3
4
5
6
7
8
9

$szQry = "SELECT column1, column2 FROM foo";
$szDBConn = mssql_connect("host","username","password");
mssql_select_db("database_name", $szDBConn);
$saResults = mssql_query($szQry, $szDBConn);
while($obResults = mssql_fetch_row($saResults))
{
   echo $obResults[0]." ".$obResults[1];
}
mssql_close($szDBConn);

Comments/description of Example

Line #1

SQL statement that will be sent to the MySQL database server.

Line #2

MSSQL database login credentilas; host (127.0.0.1), username and password.

The “host” is the server name or IP address of your database server. If your host has multiple instances the “host” value would be formatted like so …