News, Views, Rants and Raves About Technology and More

Archive for the ‘SQL’ Category

Sun Buys MySQL

with 2 comments

b1_msql_announcement.jpgSun could’ve just downloaded MySQL from the site and run without paying 🙂 .

Anyway, Sun buying MySQL is a big deal and a big surprise. Another slightly related acquisition news today is – Oracle buying BEA, the app server company. Incidentally, Oracle owns both InnoDB and BerkeleyDB – two of the better engine options of MySQL.

Written by Brajesh

January 17, 2008 at 12:11 am

Posted in Computing, Java, Money, SQL

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.

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

Navicat- Awesome GUI for MySQL

with 2 comments

Navicat – slick, fast and one can even print database table structure.

Written by Brajesh

September 19, 2006 at 4:27 am

Posted in Coding, SQL

Bitwise Expressions with Transact-SQL

with 5 comments

About Bit Field enumerations:
In C/C++/.net family of programming languages, there are 2 types of enumerations(enums) –

  1. Simple enums -Sequential or custom.
    e.g. Days of a week
  2. Flag enums -Bit field. Bitwise operators give us the ability to store multiple settings in a single primitive data type (e.g. an integer). This is useful when a single item has potentially more than one setting of the same type.
    e.g. bold, underline, italic style of text

Read the rest of this entry »

Written by Brajesh

September 3, 2006 at 8:29 pm

Posted in .net, Coding, SQL