The Drizzle Beta was announced last week. It took me the better part of an hour to download and install Drizzle, mainly apt-geting packages not on the fresh install of Ubuntu I was using. Be sure to read the Drizzle Wiki on how to start Drizzle after building.

Anyone who has built MySQL or Postgres from source can build Drizzle. Anyone who has not done so needs to pay attention to the output of the make command and read through the documentation.

The default storage engine is the InnoDB plugin. The client program (pictured) will look familiar to MySQL-ers. Drizzle worked as expected on the simple tasks it perform. And now that I have …

We've just announced a new support offering for MySQL. There's a press release here, and product information page here. But what does this new service really mean for you, in practical terms? This is actually important -- it will open up a range of new choices for you. I'll explain two major points that matter to you.

Before I begin, I want to make it clear that in some ways, what we're offering is something we've always offered. That is actually why it took us a while to re-align the product a bit. We thought we were serving you fully. You told us that wasn't really true. Thank you. We've listened.

1. Sensible Pricing

We've always offered pay-as-you-go support, and we've had a dedicated support staff for a while. The missing ingredient was flat-rate pricing. Big …

I have my schedule pretty busy during a trip to Russia this year. In addition to giving a master class and Sphinx Conference I'm going to speak at HighLoad++. I'll also have a user meeting presentations in Samara on October 17 and Minsk on October 22 This looks like it is going to be a lot of fun …

Microsoft sues Motorola. Oracle says no to LibreOffice. Time to fork Java? And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca, and daily at Paper.li/caostheory
“Tracking the open source news wires, so you don’t have to.”

# Microsoft is suing Motorola over alleged Android patent infringements.

# Oracle confirmed to SJVN that it will not be working with the Document Foundation on LibreOffice.

# Sean Michael Kerner reported that Red Hat has settled an alleged patent infringement case with IP firm Acacia Research.

# Greg Luck …

Often we make some sketches of the database we plan to create on a blackboard or a sheet of paper before we actually design its structure on computer. After that we discuss the entities we’ve got, normalize them and repeat these actions several times. As a result we get a completely approved database structure in the form of an image file in the project documentation.

Question:
How to create a database diagram basing on the image available?

Let’s try to do this using Database Designer of dbForge Studio for MySQL.

Let us suppose that you have a sketch of the future database:

Database Structure

To place this picture onto an empty diagram you should create an empty document, for …

By default Drizzle has two schemas in the local catalog.

drizzle> SHOW SCHEMAS \G
*************************** 1. row ***************************
Database: DATA_DICTIONARY
*************************** 2. row ***************************
Database: INFORMATION_SCHEMA
*************************** 3. row ***************************
Database: version_test
3 rows in set (0 sec)


The tables in INFORMATION_SCHEMA are just what is found in the ANSI SQL standard. We have added zero custom columns or tables to the schema, it is just the standard. The goal of this was to make it easy for tool vendors to support Drizzle via their current tools without having to make special exceptions for Drizzle. The tables are populated with information via Table Functions (which are completely new to Drizzle). Table Functions generate data on an as needed basis and do not materialize tables …

By default Drizzle has two schemas in the local catalog.

drizzle> SHOW SCHEMAS \G
*************************** 1. row ***************************
Database: DATA_DICTIONARY
*************************** 2. row ***************************
Database: INFORMATION_SCHEMA
*************************** 3. row ***************************
Database: version_test
3 rows in set (0 sec)


The tables in INFORMATION_SCHEMA are just what is found in the ANSI SQL standard. We have added zero custom columns or tables to the schema, it is just the standard. The goal of this was to make it easy for tool vendors to support Drizzle via their current tools without having to make special exceptions for Drizzle. The tables are populated with information via Table Functions (which are completely new to Drizzle). Table Functions generate data on an as needed basis and do not materialize tables …

Ejemplo práctico de paginación de resultados en Php

<?php
mysql_connect("localhost", "root", "");
mysql_select_db("dev");
$noRegistros = 3; //Registros por página
$pagina = 1; //Por default, página = 1
if($_GET["pagina"]) //Si hay página por ?pagina=valor, lo asigna
    $pagina = $_GET["pagina"];
echo "Pagina: ".$pagina."<hr>";

//Utilizo el comando LIMIT para seleccionar registros
$sSQL = "SELECT * FROM alumnos LIMIT ".($pagina-1)*$noRegistros.",$noRegistros";
$result = mysql_query($sSQL) or die(mysql_error());
while($row = mysql_fetch_array($result)) { //Exploracion comun de registros
    echo $row["nombre"]."<br>";
}

//Imprimiendo páginas
$sSQL = "SELECT count(*) FROM alumnos"; //Cuento el total de registros
$result = mysql_query($sSQL);
$row = mysql_fetch_array($result);
$totalRegistros = $row["count(*)"]; //Almaceno el total en una variable

echo "<hr>Total registros: ".$totalRegistros.", Pagina: ";

$noPaginas = …

The title is SEO bait – you can’t do it. We’ve seen a few recurring patterns trying to achieve similar – and I thought I would share with you my favorite two:

Option #1: Use a table to insert into, and grab the insert_id:

CREATE TABLE option1 (id int not null primary key auto_increment) engine=innodb;

# each insert does one operations to get the value:
INSERT INTO option1 VALUES (NULL);
# $connection->insert_id();

Option #2: Use a table with one just row:

CREATE TABLE option2 (id int not null primary key) engine=innodb;
INSERT INTO option2 VALUES (1); # start from 1

# each insert does two operations to get the value:
UPDATE option2 SET id=@id:=id+1;
SELECT @id;

So which is better? I don’t think it’s that easy to tell at a first glance, since option 2 does look more elegant – but if the next value is fetched as part of a transaction – I can see a potential …

The rise of open source software within both public and private organizations is something well understood, and well documented - industry analysts estimate 80%+ of organizations use open source software within their IT projects.

Typical uses include web infrastructure, internal network infrastructure, IT Development & Test environments and departmental applications.

But open source solutions are not restricted purely to these (very important) "horizontal" apps.  With the wealth of open source projects out there now, it is possible to build highly specialized solutions, addressing very specific problems, that previously could only be addressed with expensive and time consuming internal custom development.

A great example is from a new case study of …