Happy New Year 2008…!

I just wanted to put something on my blog on the 1st and so this is. But I have no specific things to say here. Normally many bloggers have written about the past, the furute and so many other things, but I have no such specific plans or may be I don’t know how to put them in words.

So I just wanted to mention one thing I just noticed on my blog, that this is my 51st post, meaning, I just finished my 50th post in 2007 starting from My blog, I’m learning… on Wednesday, July 19, 2006 to this on December 27, 2007. Other than that there is nothing special or significant to share for now.

Finally let be say this, ‘Its a new year, and I want to do some new things and continue with many other things I was doing, in my best possible way’.

And thanks for coming to my blog

Good luck to everyone and I wish you a happiness and success in this new year…!

The INTERSECT and EXCEPT operators of SQL are not supported in MySQL. So there there seems a workaround, you use a join with all corresponding attributes equated in place of an intersection.

For instance, to get the intersection of R(a,b) and S(a,b), write:
    SELECT DISTINCT *
    FROM R
    WHERE EXISTS (SELECT * FROM S WHERE R.a = S.a AND R.b = S.b);

To get the set difference, here is a similar approach using a sub query:
    SELECT DISTINCT *
    FROM R
    WHERE NOT EXISTS (SELECT * FROM S WHERE R.a = S.a AND R.b = S.b);

Note that both these expressions eliminate duplicates, but that is in accordance with the SQL standard.

So for example for something like this using EXCEPT,
    SELECT T.data_id from table T
    WHERE T.keyword = 'google'
    EXCEPT
    SELECT T2.data_id from table T2
    WHERE T2.keyword = 'yahoo'

Would become,
    SELECT T.data_id
    FROM table T
    WHERE T.keyword = 'google '
    AND NOT EXISTS (
        SELECT T2.data_id
        FROM table T2
        WHERE T2.keyword = 'yahoo '
        AND T2.data_id = T1.data_id
    )

This is just a small workaround that works for me, and I had to spend sometime finding this solution. So this is just for a reference of mine sometime later, but if its useful to anyone of you that would be great.

Hi All,

Saving Electricity is very important. So please read this doc & see whether we can do that. Then forward as much as possible.

Lightning is the working project name for an extension to tightly integrate calendar functionality (scheduling, tasks, etc.) into Thunderbird. Lightning brings the Sunbird calendar to the popular email client, Mozilla Thunderbird. Since it's an extension, Lightning is tightly integrated with Thunderbird, allowing it to easily perform email-related calendaring tasks.

Lightning is an iCalendar compatible integrated calendar application for Thunderbird and its just the perfect choice for me and gives me great flexibility and usability on day to day activities. Now you can directly addIt can be downloaded from https://addons.mozilla.org/en-US/thunderbird/addon/2313

Provider for Google Calendar is a Thunderbird extension that allows bidirectional access to Google Calendar. This extension allows Lightning to read and write events to a Google Calendar. And now all my existing Google Calender data a displayed in the Lightning calender and the updated I make are synchronized bidirectionally. It can be downloaded from https://addons.mozilla.org/en-US/thunderbird/addon/4631

Disclaimer: This is not a movie review or comparison of that sort. I just wanted to write something about some of the movies I watched during the month of November, 2007. If you are interested about these movies, just check on Wikipedia or IMDB or just Google.

1. License to Wed (2007)
   Watched on: 03/11/2007 - Xvid/DvDrip
   IMDB – Wikipedia
   Genre: Comedy / Romance
   MPAA: Rated PG-13 for sexual humour and language.

   Comments: Good movie to watch. Its about a couple who are getting married, and they had to complete a course before, which helps them understand each other better. Why don’t we really have something like this, here…

2. Gone in Sixty Seconds (2000)
   Watched on: 04/11/2007 - Xvid/DvDrip
   IMDB – Wikipedia
   Genre: Action / Crime / Thriller
   MPAA: Rated PG-13 for violence, sexuality and language.

   Comments:

3. A Walk to Remember (2002)
   Watched on: 05/11/2007 - Xvid/DvDrip
   IMDB – Wikipedia
   Genre: Drama / Romance
   MPAA: Rated PG for thematic elements, language and some sensual material.

   Comments:

4. Blood Diamond (2006)
   Watched on: 09/11/2007 - Xvid/DvDrip
   IMDB – Wikipedia
   Genre: Adventure / Drama / Thriller
   MPAA: Rated R for strong violence and language.

   Comments:

5. Apocalypto (2006)
   Watched on: 10/11/2007 - DVD
   IMDB – Wikipedia
   Genre: Action / Adventure / Drama
   MPAA: Rated R for sequences of graphic violence and disturbing images.

   Comments:

6. Zwartboek (2006) aka “Black Book”
   Watched on: 11/11/2007 - DVD
   IMDB – Wikipedia
   Genre: Drama / Thriller / War
   MPAA: Rated R for some strong violence, graphic nudity, sexuality and language.

   Comments:

7. Deja Vu (2006)
   Watched on: 13/11/2007 - Xvid/DvDrip
   IMDB – Wikipedia
   Genre: Action / Drama / Romance / Sci-Fi / Thriller
   MPAA: Rated PG-13 for intense sequences of violence and terror, disturbing images and some sensuality.

   Comments:

8. The Bourne Ultimatum (2007)
   Watched on: 14/11/2007 - Xvid/DvDrip
   IMDB – Wikipedia
   Genre: Action / Adventure / Mystery / Thriller
   MPAA: Rated PG-13 for violence and intense sequences of action.

   Comments:

9. Lucky You (2007)
   Watched on: 16/11/2007 - Xvid/DvDrip
   IMDB – Wikipedia
   Genre: Comedy / Drama
   MPAA: Rated PG-13 for some language and sexual humor.

   Comments:

10. Om Shanti Om (2007)
    Watched on: 17/11/2007 - VCD/DvDrip
    IMDB – Wikipedia
    Genre: Action / Drama / Romance

    Comments:

11. I Now Pronounce You Chuck and Larry (2007)
    Watched on: 21/11/2007 - Xvid/DvDrip
    IMDB – Wikipedia
    Genre: Comedy / Romance
    MPAA: Rated PG-13 for crude sexual content throughout, nudity, language and drug references.

    Comments:

12. Death at a Funeral (2007)
    Watched on: 23/11/2007 - Xvid/DvDrip
    IMDB – Wikipedia
    Genre: Comedy / Drama
    MPAA: Rated R for language and drug content.

    Comments:

13. Dnevnoy dozor (2006) aka “Day Watch”
    Watched on: 24/11/2007 - Xvid/DvDrip
    IMDB – Wikipedia
    Genre: Action / Fantasy / Horror / Thriller

    Comments:

14. Polladhavan (2007)
    Watched on: 25/11/2007 - VCD/CAM
    Wikipedia

    Comments:

15. Vel (2007)
    Watched on: 26/11/2007 - VCD/CAM
    Wikipedia

    Comments:

16. Perfume: The Story of a Murderer (2006)
    Watched on: 28/11/2007 - Xvid/DvDrip
    IMDB – Wikipedia
    Genre: Crime / Drama / Thriller
    MPAA: Rated R for aberrant behavior involving nudity, violence, sexuality, and disturbing images.

    Comments:

17. There’s Something About Mary (1998)
    Watched on: 29/11/2007 - Xvid/DvDrip
    IMDB – Wikipedia
    Genre: Comedy / Romance
    MPAA: Rated R for strong comic sexual content and language.

    Comments:

This month has been too much I suppose, its more than above my target of 8-10 a month. And I’m feeling lazy to write comments. I’ll update those when I’m not so.