Reverberations

News, Views, Rants and Raves About Technology and More

Archive for November 2007

Compiling Greasemonkey Scripts to xpi (Firefox Extension)

leave a comment »

Written by Brajesh

November 28, 2007 at 4:36 am

Databases vs Schemas

leave a comment »

PostgreSQL and MySQL differ on databases vs schemas terminology. While creating constraints such as foreign key, MySQL lets anyone reference tables across databases (without explicitally using schema). OTOH, PostgreSQL doesn’t have any way to maintain cross database references (as of PostgreSQL 8.2). So, although MySQL’s implimentation is non-standard (and incorrect) it is more functional in this case.
Wikipedia:

MySQL aliases schema with database behind the scenes, such that create schema and create database behave identically. It can be said that MySQL therefore has implemented cross-table functionality, skipped schema functionality entirely and provided similar functionality into their implementation of a database. In summary, Postgres fully supports schemas, but lacks some functionality MySQL has with databases, while MySQL doesn’t even attempt to support true schemas.

Written by Brajesh

November 6, 2007 at 8:57 pm

Posted in Coding, SQL

Only 38% Downloaders Paid for Radiohead’s Album “In Rainbows”

with one comment

In Rainbows,” a new record album from an English band Radiohead, has challenged the traditional music sales model by allowing listeners to determine the price they are willing to pay for the album which is available for download on its website.

Figures coming out from comScore – an internet marketing research company – 38% paying an average of about $6 seem much more realistic than the numbers floated earlier – average price between $5 and $8 for 1.2 million downloads.

I’m one of those 62%. Radiohead’s music is decent but not my taste. But, had the album not been available for download, I wouldn’t even have heard of them or their music. Moreover, they probably made much more money from these downloads than they could ever make from regular album release.

Written by Brajesh

November 6, 2007 at 8:57 pm