Nimal's Weblog

Nimal blogs here

Its a new year…

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…!

  • Comments Off
  • Filed under: Writing
  • 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.

  • 2 Comments
  • Filed under: Tech Notes
  • Save Electricity

    Hi All,

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

  • Comments Off
  • Filed under: Tech Notes
  • 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

  • Comments Off
  • Filed under: Tech Notes
  • Movies I watched in November

    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
      IMDBWikipedia
      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
      IMDBWikipedia
      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
      IMDBWikipedia
      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
      IMDBWikipedia
      Genre: Adventure / Drama / Thriller
      MPAA: Rated R for strong violence and language.

      Comments:

    5. Apocalypto (2006)
      Watched on: 10/11/2007 - DVD
      IMDBWikipedia
      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
      IMDBWikipedia
      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
      IMDBWikipedia
      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
      IMDBWikipedia
      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
      IMDBWikipedia
      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
      IMDBWikipedia
      Genre: Action / Drama / Romance

      Comments:

    11. I Now Pronounce You Chuck and Larry (2007)
      Watched on: 21/11/2007 - Xvid/DvDrip
      IMDBWikipedia
      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
      IMDBWikipedia
      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
      IMDBWikipedia
      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
      IMDBWikipedia
      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
      IMDBWikipedia
      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.

  • 2 Comments
  • Filed under: Media